Automating API calls from information in a cell

[Wadeknight]

I am an absolute beginner to excel so I don't know if I have the language to phrase this question right. I learned how to make an API call and make a table using Get & Transform. The problem that I am facing is the data I need to extract is contained in three separate categories. We'll call them name?, table1? and table2?

I was able to make a sheet from the first category, name? From Which I got a name (in column A) and an ID number (Column B). The ID number is what is needed to make an API query in the other two categories. (Ex. api/table1?idNumber=) Is there a way that I can automate making API calls using the ID number in column B, extract information and put it in column C?

 

[QuietRiot]

I believe what you are trying to accomplish would require VBA code, but you can definitely iterate through it grabbing the ID number each time to update your API query, read the response and get the information for column c.