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.

Query

PostgreSQL Query with "$1/$2/$3...$n" present on Dynamic Fields

SELECT * FROM books WHERE author = $1

Function

• 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);

Connection ID

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.