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:
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:
How can I add the data from this call to my insert?
Thanks in advance