community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Using Download Tool to get file from site with login

Highlighted
Alteryx Certified Partner

I'm not having much luck of going to a web site and getting past the login form using the Download tool.  See picture of the Payload tab of the Download tool configuration.

 

Process:

1.  Goto website (in this case it is freshbooks.com)

2.  login with credentials (I can't seem to get past this point)

3.  get report data from page and put into process

 

Any suggestions would be appreciate as well as how to troubleshoot the download tool.


Thanks!

Fireball

I had to do something similar last week and ended up writing a simple script using Curl.exe and the Run Command tool instead of the Download tool.

Alteryx Certified Partner
Alteryx Certified Partner

You will more than likely have to utilize the FreshBooks API https://www.freshbooks.com/developers to authenticate and access information from your account.

 

The best way that I have found to troubleshoot the Download tool is using Fiddler http://www.telerik.com/fiddler to monitor the requests it sends.

Alteryx Certified Partner

Thanks for this after lots of tinkering got to work. This is more flexible and I can't see why it wouldn't work on any web site.  

 

For the next person, here is my cURL script

 

curl -c cookies.txt -X POST -F username=<Your_UserName> -F password=<Your_Password> https://<URL of login page> - H "Accept: application/json" --next -X GET https://<URL>/internal/export_Report_EstimatedBilling?format=excel --output text.xls

 

which does the following:

1. Goes to the URL of the login page and posts the user name and password

2. Goes to the report and gets the XLS file

3. Saves the file to text.xls

 

Also sure there are many ways but I put the above in a batch file and added a pause for debugging and called with the run command in my workflow.

 

Hi,

 

I am new to Alteryx, completed my core certification. Here I am also require same kind of help.

 

Process:

Step 1: Need to login into one website with my credentials.

Step 2: Need to search with one 'tag word' on one particular search field of that page

Step 3: Compare the results with the other tag name and select the link

Step 4: Open the links and process the output to alteryx

 

Please elaborate the steps involved or possibly with a small work flow about dealing with login and opening the links that are part of the page.

 

Thank you in advance

Atom

Troy, can you upload your Curl Command workflow? Thanks!

Labels