PostgreSQL Query Action
Execute PostgreSQL query completely serverless via Thingsup IoT Platform. Create custom query from MQTT Rules Engine or HTTP APIs.
This provides a way to run PostgreSQL Query. Before adding PostgreSQL Query Action, user has to define a PostgreSQL Connection. User need to provide following parameters to add PostgreSQL Query Action.
PostgreSQL Query with "$1/$2/$3...$n" present on Dynamic Fields
SELECT * FROM books WHERE author = $1
- User can write JavaScript code to supply dynamic data to query.
- "payload" object and "params" array object is available in this code which can be used to supply dynamic data to written query.
- '$n' will be replaced sequentially from nth parameter from params array contents.
//Example 1
params.push(payload.author);
User need to provide a Connection ID of PostgreSQL database connection.
Add PostgreSQL Query Action
Please note the following points:
- "payload" object is supplied from Action Trigger like Rules, Action Command etc.
- '$n' in Query will be replaced sequentially from params array.
- In case of Static Query don't write anything in Function
- Data Response of PostgreSQL query will be available as Action Response.