FILTERXML Function

I am trying to set up an automatic plant disease predicting model using excel.

I have tried to use the filterxml function to grab data from the dark sky weather api, but I just can't get it to work.

Could anybody help?

This is the formulae I am trying to get to work.

=FILTERXML(Sheet1!$A$2, //"windSpeed"/)

Sorry if this has been done already.

Hi Ben,
I tested Dark Sky Api and the response is a JASON not an XML so I think you cannot use FILTERXML

Please Login or Register  to view this content.

So you need to look for the time node and then for the windSpeed
Cheers
Sergio