Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Need to get data from a website

irajesh2017
7 - Meteor

Hi Everyone,

I need to get data from a website.

I do have a their url to download data, user name, password and API key.

But not sure where to enter all these information.

I have put url in text input but after that  I am not getting any prompt to put other information.

Need your help.

Please let me know where to put API key and User name and Password so that I can download data.

 

Thanks!

Regards

 

4 REPLIES 4
echuong1
Alteryx Alumni (Retired)

The data is actually in the DownloadData field.

 

You'll need to parse out the data. For example, you can use the text to columns to split the data into rows, regex, etc.

 

echuong1_0-1614798089416.png

 

irajesh2017
7 - Meteor

Hi,

Thanks for your reply.

I am very new to Alteryx. Do not know much about this tool.

Requesting you to please help me by creating a work flow and attach in this thread.

 

Thanking you for your help!

 

Regards

Rajesh

 

irajesh2017
7 - Meteor

Hi, Another question is that data is secured and is available by using API key only. Where to put API key in the workflow.

 

Thanks!

Regards

Raj

randreag
11 - Bolide

hi @irajesh2017 

 

You have to check the documentation ofthe  API 

 

So you can put the data in different ways:

 

1. Can be write the variables like this, you have to chose if it a post or a get (it depends what you want to do)

aruiz-itp_0-1614814605528.png

 

Another way is concatening the variables to the url, it depends in the way the API receives de info

 

aruiz-itp_1-1614814784937.png

 

You have to check the documentation and there should be an example that you can follow

 

 

 

Labels