Download JSON/CSV from REST API and set to table

Queries and Resources
1

I have the following query to a REST API:

Image 2022-02-13 at 14.23
Image 2022-02-13 at 14.232236×1466 193 KB

The data is not in the response but rather points to the file. In JS we use csvData=response.text() to get the CSV formatted data from the fetch request. In ReTool, the preview panel has a handy button that allows to get, in json, the exact data we want, demonstrating Retool knows how to get to it.

The question is, how do we get to the JSON or CSV data and set it to a table?

Regards and long live ReTool!

2

Hey @dmnC, You should be able to reference the data and metadata with AV_IPO_Calender.data and AV_IPO_Calender.metadata respectively. I hope that helps!

3

Thanks for reminding me this was still open.

For the benefit of others,
here is how I managed to get my hands on the data and set it to a table:
{{Papa.parse( query1.data.message, {header:true}).data}}

1 Like