Join our Community in its new Home - The Datorama Trailblazer Community Group!
It's been an amazing 3 years coming together in this forum to collaborate, innovate, support, and inspire each other about our shared usage of Datorama. While this is not quite a goodbye, we are excited to announce that we are getting a fresh start in our new home within the Salesforce Trailblazer Community. We have a ton of fun new content planned and you may even see the revival of some of our most popular posts from the past few years.
We’ll be keeping this group around for a bit for you to peruse, but as of November 15, we will no longer be allowing new posts or comments. Be sure to join our new group at https://www.salesforce.com/success-datorama to keep the conversation going.
We can’t wait to see you there!
It's been an amazing 3 years coming together in this forum to collaborate, innovate, support, and inspire each other about our shared usage of Datorama. While this is not quite a goodbye, we are excited to announce that we are getting a fresh start in our new home within the Salesforce Trailblazer Community. We have a ton of fun new content planned and you may even see the revival of some of our most popular posts from the past few years.
We’ll be keeping this group around for a bit for you to peruse, but as of November 15, we will no longer be allowing new posts or comments. Be sure to join our new group at https://www.salesforce.com/success-datorama to keep the conversation going.
We can’t wait to see you there!
Is there a weather API I can connect to?
Cristina
MelbourneACCOUNT_ADMIN 
in Help Center
Hi all,
I've been struggling to find a solution here - essentially, I'm looking to automate the retrieval of weather data to display to a client.
What I'm currently doing is quite manual: exporting the spreadsheet data from a page like this - http://www.bom.gov.au/climate/dwo/202107/html/IDCJDW2168.202107.shtml, then uploading that file directly into Datorama to display both a table of daily min. temp, max temp, rain, and sunshine hours, and widgets that display an overall monthly average.
As you'll see on the BoM website, each month of data goes onto a new page, which is annoying, but the URLs follow a simple naming methodology so these could be guessed for each ensuing month.
The problem: I can't extract data from the BoM website, which I have recently discovered is because they have put a block on scraping. I had a vague plan to maybe use Google Sheets to import the tables via the IMPORTHTML function and guess the URLs for future months and then pull this into Datorama so it could all be in one stream and I wouldn't need a new stream for each month, but the scraping block is stopping my progress here.
Similarly, the HTTPS datastream function in Datorama won't let me pull data directly from the website.
I don't know another way around this that won't involve a manual upload every month, so wondering if there is a weather API I could connect to that would achieve what I'm trying to do here?
Thanks.
I've been struggling to find a solution here - essentially, I'm looking to automate the retrieval of weather data to display to a client.
What I'm currently doing is quite manual: exporting the spreadsheet data from a page like this - http://www.bom.gov.au/climate/dwo/202107/html/IDCJDW2168.202107.shtml, then uploading that file directly into Datorama to display both a table of daily min. temp, max temp, rain, and sunshine hours, and widgets that display an overall monthly average.
As you'll see on the BoM website, each month of data goes onto a new page, which is annoying, but the URLs follow a simple naming methodology so these could be guessed for each ensuing month.
The problem: I can't extract data from the BoM website, which I have recently discovered is because they have put a block on scraping. I had a vague plan to maybe use Google Sheets to import the tables via the IMPORTHTML function and guess the URLs for future months and then pull this into Datorama so it could all be in one stream and I wouldn't need a new stream for each month, but the scraping block is stopping my progress here.
Similarly, the HTTPS datastream function in Datorama won't let me pull data directly from the website.
I don't know another way around this that won't involve a manual upload every month, so wondering if there is a weather API I could connect to that would achieve what I'm trying to do here?
Thanks.
Tagged:
Comments
I would recommend creating a ticket to our [email protected] team.
If they are not able to find a solution, then will ask our Tier 2 team to either find a solution or raise a Feature Request.