Add a row from form input and an API call

Queries and Resources
1

Most of my data to add a row to a Postgres database table will come via a standard jsonschema form. Mapping the fields to a query is easy enough... however, I need to get a value for a non-sequential identifier from an API call. Is there some way I can add the data from a GET request to the data from this form?

As a simplified example, say I have a form that collects:

  • name
  • logo
  • description

And the table requires those fields as well as a value for a snowflake field that must be retrieved from an API roughly like this:

GET https://api.example.com/snowflake

How can I add the data from this call to my insert?

Thanks in advance :slight_smile:

2

Figured this out! I was able to just add a new RestQuery resource that called the endpoint and then reference that from the jsonform fields by value.

3