Serial REST calls

Hello. I am developing a new workflow that needs to call different endpoints of the same REST API. Essentially I want to loop through each row URL, call and get the results, and save each in respective new tables that I plan to transfer to a SQL Server using indb functions

I started following the instructions here: https://community.alteryx.com/t5/Engine-Works-Blog/REST-API-In-5-Minutes-No-Coding/ba-p/8137 using the text input tool. Is this the right way to go about it? I understand how to use the download tool to call the first, but how would i loop to rows 2-*?

Macros

API

Accepted answers

Claje

Gotcha - in that case use Append Fields to append the Token to ALL of your calls for step 2. I'd just make sure you are only passing in one Token row into that Append fields tool.

All comments

Claje

Hi,

I'd recommend changing this slightly - put your client_id and secret in a different input, and use the Append Fields tool to put the two together. That way you will pass your client_id and secret through for each call.

If you are calling services with different client_id and secret, consider a Join instead of Append Fields.

Otherwise, this looks good! The download tool will automatically loop through all requests, and then you can later parse them out into specific logic.

jt7Princeton

So I think I can just put those 2 values in the payload of my download tool. Essentially the first step is to call that clientauth endpoint with a post and those 2 values to get a token. I then use that token in the header for all subsequent calls. So like you said, I created a separate input with just the URL and put the post values in the 1st download tool. I am guessing that will give me the token back. I see the download tool has output as a string. What tool would be the best to capture that and ultimately pass it to the next download tool's header that loops through all the URLs?

I noticed the download tool can have only 1 input so I couldn't hook up a 2nd input tool (with my URLs) and the precededing download tool (with the token output) to a subsequent download tool.

Thanks!!!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703