Using Download Tool to get file from site with login

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!

dowloadtoolpic.bmp

Download

Accepted answers

AndrewW

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.

Troy

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.

All comments

AndrewW

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.

michael_treadwell

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.

Troy

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

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703