CURL type request

Queries and Resources
#1

Hi Everyone!

Is it possible to query data with a CURL type request? For example - I run this command to get data from an online source in XML. Would there be a way to get this information into retool?

curl "https://marketnews.usda.gov/mnp/fv-report?&commAbr=BROC&step3date=true&locAbr=&repType=shipPriceDaily&refine=false&Run=Run&type=shipPrice&repTypeChanger=shipPriceDaily&environment=&_environment=1&locAbrPass=ALL%7C%7C&locChoose=comState&commodityClass=allcommodity&locAbrlength=1&organic=&repDate=11%2F02%2F2022&endDate=11%2F02%2F2022&format=xml&rebuild=false"

#2

Hello @darenhunter,

This is possible.

To get the Data into Retool, you would have to set up a Rest-API resource and run this as a GET request.


\

1603×885 169 KB


This will retrieve your data and retool can parse it.

You would need to write some form of JS query to manipulate this data into a form that can be loaded to a table component\

#3

Here is how I set up my resource

1410×944 77.6 KB

#4

Alternatively, you can add an XML parser library like fast-xml-parser to retool.

then use this to parse your data with ease unto a table

Docs for using libraries in Retool

1906×878 178 KB

I have attached an export of the App to help you get started
XMLParser.json

#5

Oh my word- thank you so much for this! So so helpful!