hourly or hourly10day in Excel

  • 1
  • Question
  • Updated 4 years ago
This is a follow-up on a previous question from ~1 month ago.

I get a #VALUE! error in Excel when trying to call the hourly or hourly10day feature which seems to be related to Excel only being able to handle 32767 characters per field. As I'm really only interested in extracting the temperatures on an hourly basis, is there a way to call a limited set of these features?

Any help greatly appreciated.
Photo of cstoltz

cstoltz

  • 3 Posts
  • 0 Reply Likes

Posted 4 years ago

  • 1
Photo of Tim Roche

Tim Roche, Official Rep

  • 328 Posts
  • 36 Reply Likes
There are currently no ways to get smaller payloads
Photo of cstoltz

cstoltz

  • 3 Posts
  • 0 Reply Likes
Tim,

Thanks for the quick reply. Do you know of any other simple way I may be able to make this work? I"m trying to develop this in Excel for ease of use by some colleagues.

Thanks,
Chris
Photo of Tim Roche

Tim Roche, Official Rep

  • 328 Posts
  • 36 Reply Likes
easiest way would be to write some sort of shim app that calls the API and outputs a smaller JSON or XML structure.  

Python or PHP would be good choices for this type of project.