Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Download report from website

Highlighted
8 - Asteroid

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

Highlighted
Alteryx Certified Partner

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!!

 

Capture.JPG

I'm sure no one will care much but for me this was a pretty impressive piece of work

 

Highlighted
11 - Bolide

@LordNeilLord Nicely done! 

Highlighted
Alteryx
Alteryx

@LordNeilLord , Very impressive work. You're a stronger man than I am, gave up after an hour. 

Highlighted
8 - Asteroid

@LordNeilLord  Thanks a ton for this. Awesome work!!! Take a bow buddy.

Highlighted
8 - Asteroid

@LordNeilLord 

 

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?

 

Highlighted
8 - Asteroid

@LordNeilLord 

 

How do I view the downloaded excel data in the same workflow? Appreciate if you could help out on this.

 

Regards,

Raghu

Highlighted
Alteryx Certified Partner

Hey @raghusrealm 

 

You should be able to use a dynamic input tool to read the data straight back into the workflow

Highlighted
8 - Asteroid

@LordNeilLord 

 

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

 

Highlighted
Alteryx Certified Partner

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

Labels