Excel 2013 - WEBSERVICE and FILTER XML

[Robby19]

Trying to pull the Manufacturing cost index from an XML pull. The XML comes from https://api.eve-industry.org/system-cost-index.xml?name=Osmon

I successfully used the WEBSERVICE function in excel to create and pull the data;
<CODE>

B2 = Above Link, C2 = System name (i.e. Osmon)

</CODE><CODE>

=WEBSERVICE(CONCATENATE(B2,C2))

</CODE>
My question is, how do I used FILTERXML to pull just the Manufacturing data? So far I have
<CODE>

=FILTERXML(P29,"//Manufacturing")

</CODE>But it only returns a #VALUE ! error. I have also tried a bunch of other ways.

 

[John_w]

Try

=FILTERXML(A11,"//solarsystem/activity[@name='Manufacturing']")

or

=FILTERXML(A11,"//activity[@name='Manufacturing']")

 

[Robby19]

Thank you! Works beautifully.

 

[Robby19]

Here is another question for you, if you don't mind. If I have another API that I want to pull. Which works fine. This one is for the "Base Installation Cost" https://api.eve-industry.org/job-ba...845,42138,42136,42137,23918,28849,12732,12754

If I have a table, outlined below. Is there a formula that I can copy/paste with FilterXML that will autopopulate based off of the blueprint name?
[TABLE="width: 500"]
<TBODY>[TR]
[TD]Blueprint Name
[/TD]
[TD]Base Job Installation Cost
[/TD]
[/TR]
[TR]
[TD]Aeon Blueprint
[/TD]
[TD](Formula goes here)
[/TD]
[/TR]
[TR]
[TD]Archon Blueprint
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Avatar Blueprint
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bowhead Blueprint
[/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]
Tried this, but it doesn't work xD (O3 is the (Formula goes here))

=FILTERXML('API Pulls'!B11,"//job-base-cost[@name=O3]")

Or do I just have to manually input them, 1 by 1?

 

[John_w]

You still need single quotes around the name attribute value, then use ampersands to concatenate the strings and cell reference:

=FILTERXML($A$5,"//job-base-cost[@name='"&A9&"']")

 

[Robby19]

Thank you kindly!