This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
There's been a lot of great ideas and discussion on here, thanks a lot for everyone's help! I've attached a workflow that uses the GeoJSON API that powers the Johns Hopkins COVID-19 dashboard. This should help in getting data more periodically throughout the day rather than at the end of the day when the csv files are posted to JHU's GitHub page. Here is the link on ESRI's site for more info on the data:
Error: Designer x64: The Designer x64 reported: Error running Event #1: The external program "gitpull.bat" returned an error code: 1: The system could not find the environment option that was entered. (203)
Is this because I've already run the git pull today? The .bat itself will execute outside of Alteryx.
I downloaded your original workflow and I think it processed all the files in the daily reports directory, but I have just revisited it and it seems to only process up to the end of March. Do you have a later version?
Hello Chriscuk - I had noticed some small tune up that might be required, I have seen for instance some column headers that may be affecting when you run but at the end I included a version based on David's that I am currently using to load my own dahsboard. Please take a look to the attached one, I just used it to load till April 12 Data that is the latest available Data file.
This workflow is wonderful! I used it yesterday for the first time and worked well. I used the latest daily reports from JHU which included all reports up to 5/7/2020, but when the flow ran, I only had up to 3/22/2020. I went through the flow, but was unable to determine why.