Pull high temperate for a specific date from XML forecast10day API output, in Excel

  • 1
  • Question
  • Updated 2 years ago
I am trying to populate a specific cell in Excel to show the forecasted high temperature on a specific date.

Using the forecast10day API call, how do I query the XML using the =FILTERXML function to find out the high on a specific day?  All of the examples I see use arrays over multiple rows & columns, I am trying to do this for just one cell (as part of an itinerary where we visit different cities in each column).

Ie.  What is the high on January 21, 2015 in the 94101 zip code?
Photo of eon


  • 1 Post
  • 0 Reply Likes

Posted 5 years ago

  • 1
Photo of Mike C

Mike C

  • 9 Posts
  • 0 Reply Likes
Did you ever figure out how to get this result ?