Download report from website
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can anyone help out to download a report from a website.
here is the link to the website - https://340bopais.hrsa.gov/Reports
Below are the steps that needs to be executed to download the report
1. Once the above link open, click on "Daily Reports" and a dropdown list of report will show
2. Click on "Covered Entity Daily Report" to download the report
3. Save the output file to desktop
Appreciate if anyone can help out on this one.
thanks in advance.
Regards,
Raghu
Solved! Go to Solution.
- Labels:
- Download
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @raghusrealm
Sometimes you see posts like this and you think "this should be easy", then you look at the website and you think "this is impossible"....then you find yourself 4 hours later thinking "I may have actually solved this one"
I took a while, several experiments with postman but I've finally done it!!
I'm sure no one will care much but for me this was a pretty impressive piece of work
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@LordNeilLord Nicely done!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@LordNeilLord , Very impressive work. You're a stronger man than I am, gave up after an hour.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@LordNeilLord Thanks a ton for this. Awesome work!!! Take a bow buddy.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
There has been a further development on the workflow you shared.
As per your workflow, the output file is getting saved on my desktop (which was my earlier requirement).
Now, I want to save the file to a restricted folder location on a shared drive. I changed the file path in the formula tool to the restricted folder and I was able to successfully download the file to the restricted folder when I run the workflow from Designer.
I published the workflow to Alteryx Gallery and also given the user access credentials to access the restricted folder. But, when I ran the workflow and I am getting an error for the download tool (Error transferring data: Couldn't resolve host name).
Any thoughts?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How do I view the downloaded excel data in the same workflow? Appreciate if you could help out on this.
Regards,
Raghu
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @raghusrealm
You should be able to use a dynamic input tool to read the data straight back into the workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I tried doing that but I was not able to succeed. Can you help in adding that piece to your earlier workflow and send it?
Regards,
Raghu
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
There is something strange with this file as Alteryx can't read the data back in!
It seems to write fine and I can open it in Excel