Push a single value of the Json file into a Google spreadsheet cell using =ImportData

  • 2
  • Question
  • Updated 5 years ago

I ́m really struggling trying to use the =ImportData function in Google Spreadsheet so I can push the current temperature of a city in a Google spreadsheet cell.
I ́m getting real close, but I keep getting the whole contents of the Json file instead just the value from temp_c

This is what I ́m using:
=ImportData ("http://api.wunderground.com/api/MY-AP...")

(of course I use my API key)

I know I should use select "current_observation" and "temp_c" from the Json file, but I ́m struggling to get this ImportData to work
Is there anyone out there who can help me out please?
Photo of weermanmax


  • 1 Post
  • 0 Reply Likes

Posted 5 years ago

  • 2

Be the first to post a reply!