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.
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.
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.
Go to Solution.
Go to Solution.
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.
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.
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.
I am new to Alteryx, completed my core certification. Here I am also require same kind of help.
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
Troy, can you upload your Curl Command workflow? Thanks!