Calling API multiple times

I am trying to get stock information from the AlphaVantage API. I need to run for a list of tickers, but it only wants return the data for the 1st ticker.

In the attached worfklow I have AAPL and MSFT in the text in put tool, but it's only returning AAPL.

Am I feeding the data into the API incorrectly? Are the tools configured correctly? How can I get the api to take and return the results for a list?

The API key embedded is a free one I created. My corporate API key is NOT in the workflow.

Thanks for any help!

Craig

AlphaVantage sample.yxmd

Macros

API

Batch Macro

Accepted answers

patrick_digan

@csh8428 I think there was just an issue with your crosstab. You should group by Ticker and RecordID in your crosstab. Then you can change your select tool to just keep the ticker field and uncheck _null. You don't need your 2 multi-row tools either.

AlphaVantage sample.yxmd

All comments

JagdeeshN

Hi @csh8428 ,

If the API limits you to just one ticker per call, have you tried the concept of a Batch Macro. This would enable you to make multiple calls to the API, one each for the different tickers.

Please refer to the below link for more information:-

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Batch-Macros/ta-p/488165

Best,

Jagdeesh

patrick_digan

AlphaVantage sample.yxmd

csh8428

Doh!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703