Calling API multiple times
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- API
- Batch Macro
- Macros
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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:-
Best,
Jagdeesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Doh!
![](/skins/images/6056C79A596CAB15526D64C598622101/responsive_peak/images/icon_anonymous_message.png)