Weather History Question

[teades]

Hello,

I am a new user and trying to build some proof of concept appliactions.  I am currently trying to call an API service to get a list returned of past weather data of temperature, precipitation, humidity (that I can just to join by datetime to my existing data set for my equipment) by lat/long.

Is there any examples that would return a bulk list like this based on a date range and lat/long being passed into the api?  Something like:

Thank you for any help you can provide!

[RaphaelSilva]

I think it will be unlikely to find weather information on that level of detail, forecast as usually on a specific region level - that can be translated to a lat/long centroid point later.
What is your final goal with the application?

[teades]

For the final goal, I am trying to perdict how my equipment functions depending on these weather elements.  I have a water flow meter that will record data every min.  I was trying to match this up with weather data to provide some sort of indication / prediction of how this will change future flow rates.

I really dont think I need it by hour but probably by day.

[CharlieS]

I think what you're looking for depends more on the capabilities of the API/data service than Alteryx. You could use Alteryx to make many individual calls to the service, or perhaps the API has options to specify ranges.

Could you link us to this API? Is it from the NOAA? 

[usmanbashir]

@teades - I found this: Try the Historical Weather API:

https://open-meteo.com/en/docs/historical-weather-api#latitude=28.5383&longitude=-81.3792&hourly=tem...

This is an example API call

https://archive-api.open-meteo.com/v1/archive?latitude=28.5383&longitude=-81.3792&start_date=2024-03...

[teades]

Thank you, I will try that!  I am new at this and really excited to try to intergrate this into my workflow.

[usmanbashir · Accepted solution]

@teades - Here's a workflow that pulls the data and parses the data! Enjoy!