Save REST API results into a database

Workflows
1

I am new to Retool and hope someone will point me in the correct direction. I have a REST API that when run gets records from an online service in json or csv format. I want to save the results into a database to use in a web app. Data from the REST API call is updated once everyday.

Is this accomplished with workflows?

Sorry for the trivial question. I could not find a "new guy" category to post in.

2

Yes, you need a workflow for this if you want this to run at selected intervals.

  1. Create a workflow
  2. Add a start trigger and configure it to run once everyday
  3. Configure a rest API in query library and import it into workflow or create the rest API in workflow itself
  4. Create a table in Retool database
  5. Map the rest API response to table rows.