Forum Discussion
How to call XML API call using cell value
Hello everyone.
I need to make an XML API call to the web. As you can see the only thing that changes is the typeID= Number XXXX
On my main table i have a few TypeIDs (Column E) that are the ones i need to use to their own API call. I would like to grab those numbers and dynamically change the last part of the api call (&type=XXX) to call each API. Info that's grabbed on the API call needs to get printed on column F (below "Jita").
If i can make all the API calls at once that would be ok too, but keep in mind than TypeIDs are probably gonna be changed with some checkbox.
2 Replies
If your TypeID column is part of a defined table then you can use the each operator to iterate through the list an call your XMLdownload function, like so:
Table.AddColumn(PreviousStep,"XML", each GetXML([TypeID]))
Exactly...my TypeID column is the one that i would manually input with whatever values i want to lookup for. Why?
https://api.evemarketer.com/ec/marketstat?typeid=34
As you can see...the red number will change whatever XML call information i get.
To be honest, never did a foreach or anything related to it on PQ.
As you can see on my XML call, first row called named is the one who matches with TypeID column. Obviously i'm doing the calls manually typing each TypeID.
