Forum Discussion
Loop through list a to perform a REST API call and produce a table for each item in the list
Hi All I am creating our own custom data connector to retrieve data stored in some custom software we had developed for us. I can get to the data via a REST API One of the REST API calls, if...
Yes. Just start with a query that has your assettypecodes in a table (so you can refresh it to add/remove more in future), and then add a custom column that makes your web call for each. For example, Web.Contents("Your Base URL?assettypecode=" & [AssetTypeCode] & "other url parameters if needed"). This will return a column of Tables that you can expand to combine all the data.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat