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...
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.