[VBA] Loop API

[steefq]

Hi!

I need some help with API where i need to extract the data to an excel sheet called "Query" and wants the data to start at cell "A1".

Its a website that allows people to extract items for an game called "Albion online" The items that will get extracted are marketplace values "Item: and Price: and Location:"

The link for API

https://www.albion-online-data.com/api/v2/stats/History/T6_RUNE.json?locations=Fort%20Sterling&time-scale=6

Its searching for "T6_RUNE" and retrieving that item

I got around 6000 requests/items i need to pull, i got them in JSON format/Text format and also in cells in Excel.

Is there by any chance i can manipulate the string/api to retrieve everything in one request instead of looping through the cells and use the cells as "ITEM" eg. "T6_rune"

 

[Kerryx]

Not sure if this is what you want but seems you can add more seperated by a comma

https://www.albion-online-data.com/api/v2/stats/History/

T4_BAG,T5_BAG,T6_RUNE.json?locations=Fort%20Sterling&time-scale=6

 

[steefq]

Not sure if this is what you want but seems you can add more seperated by a comma

https://www.albion-online-data.com/api/v2/stats/History/

T4_BAG,T5_BAG,T6_RUNE.json?locations=Fort%20Sterling&time-scale=6

Hi, thanks for the input and its working great!

My next question, could i input an .text(RAW) from githup file so the api could read from it instead of having to put all 6000 items in the link?

Or is it better to make the API dynamic with VBA?
The VBA loops through cells and input the value in the api string?

API
Heres the link: Swagger UI

ITEMS:

https://raw.githubusercontent.com/broderickhyman/ao-bin-dumps/master/formatted/items.txt

 

[Kerryx]

will defer on this to someone with more experience as it is getting more complicated