How to insert data to an existing Retool table using REST API?

💬 Queries and Resources
3

Hello @Tracy_Samuel , Welcome to Retool Community.

Retool doesn’t directly provide an API for interacting with your database. However, you can set up a custom REST API or use Retool's internal queries and webhook triggers to achieve the goal.

Use Retool Workflows

If you’re using Retool Workflows:

  1. Create a Workflow:
  • Go to the Retool Workflows section and create a new workflow.
  • Add a trigger to receive webhook data.
  • Add a PostgreSQL step to insert the data using an SQL query.
  1. Configure the Webhook URL:
  • Use the Webhook trigger's URL in your external application.
  1. Map Data Dynamically:
  • Parse the webhook JSON payload and map the fields to the database columns.
4 Likes