API download by looping through existing dataset

[romanzdk1]

hello, 

I need to download JSON from API by looping through existing dataset.

Here is a link: https://atp-scraper.herokuapp.com/api/player_overview/Roger Federer

Instead of "Roger Federer" in the end I need to iterate through list of other players which I already have prepared.

So basically I need to download:

1) https://atp-scraper.herokuapp.com/api/player_overview/Roger Federer

2) https://atp-scraper.herokuapp.com/api/player_overview/Rafael Nadal

etc.

How I can achieve this please?

[afv2688 · Accepted solution]

Hello @romanzdk1,

Try using this. You need to edit the macro to give you the results you want.

If not, try to run it and see the results

Regards

[romanzdk1]

Thank you very much for your reply.

I tried to change macro to desired output, however I keep getting only first record (first URL only).

How to make it loop through whole "API" column please?

EDIT: I changed Output mode in the Batch macro settings and it works just fine. Thank you again.

[DavidP]

Have you tried adding a Browse tool after the macro in your workflow?