-Goal: REST API response data to Retool Datasbase using workflow.
-Steps:
Created a new workflow, added a trigger to run everyday.
Added REST API resource component and using POST method to fetch the data from the API.
Created a table in Retool Database manually as per API response.
Ran the API component and fetched the data.
Trying to parse the above response data and store into the table created in Retool Database using JS/Python, but it is not working. Find below the screenshot:
My best guess based on what I see here is that you have an invoice in your apiData array that does not have the InvoiceInfo property (or is null) or there isn't an array stored in the Detail property (or it is null)
I noticed you built in a check for null Invoice data, so you might want to try to error catch these other properties the same way.
Can you use a code block just to return the Invoice data to see if there is anything that jumps out at you in the data's properties?