Store query data from API in Retool database

Queries and Resources
1

  • Goal: Trrying to store data from an API query in to Retool database

  • Steps: I created an Rest API to our payment provider to load relevant payments reports into a table in an app. I want to store those data in a Retool database

  • Details:

  • Screenshots:

    image
    image1506×378 46.2 KB

  • App json export:

2

Hi @Lamine_Gueye - welcome to the forums. Since you already have the data coming back from the API and into a table, you are well on your way. Your next steps would be to create the table in the Retool DB with the columns you need, and then to create an INSERT (or UPSERT) query using the table as a source.

Have you tried doing that yet? Is there a step you are stuck on?