Hello all o7
I have an industry worksheet on Google Sheets that I want to use to pull market data from Eve Marketer. Here is the situation I need some assistance with.
I am using this formula in cell D2.
=importxml(“https://api.evemarketer.com/ec/marketstat?usesystem=30000142&typeid=34","//sell/min”)
I’m trying to pull the sell/min data from Jita for the item listed in typeid, in this situation it is Tritanium. I get a “Formula Parse Error” with this entered into cell D2.
How do I complete this call? Also, how would I be able to use cell B2 to reference typeid, instead of typing each specific id into every formula?
TIA
Apollo North