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


Connection ID

User need to provide a Connection ID of PostgreSQL database connection.

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.

Last updated