Alteryx Designer Desktop Discussions

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

How do I pull data using an API?

GIS_User01
7 - Meteor

Hello!  I have had success with this functionality in the past.  I am using the Download tool and then the JSON parse tool.  Evidently the API I was pulling from in the past was very simple and this new one I am working with is a bit more difficult.  I am not understanding how to add the necessary parameters to get a response.  Because the data is proprietary, I cannot share the actual credentials, but here is basically the syntax I need to pass to get a response:

 

POST https://abcdefg.com/v1/responses.flat

{
"token": "123",
"pretty": true,
"form_id": 123456
}

 

Can anyone assist with how to get that 'stuff' to pass to the API exactly?  It needs the { } brackets and all!

 

Thanks so much in advance as I am stuck!!

3 REPLIES 3
apathetichell
19 - Altair

Hey - so there are a few thousand posts on this here. 1) post the API specs (this is the documentation of the source systems API) -  this is not private (in 99% of cases). Your credentials are. Don't post your credentials. ever.

2) test this in Postman. Get it to work in Postman. Transfer what you have in Postman to Alteryx.

3) That is JSON. you can put it as a single field in single quotes like

'{

"key":"value"

}'

 

you should set your content-type in your headers to application/json.

 

 

GIS_User01
7 - Meteor

I could not find any good examples relative to this specific format.  Working in Postman with no issues.  Documentation image attached.  Still do not know how to get it structured correctly since Alteryx does not allow me to see the full request it is making.  Where do I set the content type to application/json?

 

 

apathetichell
19 - Altair

download tool -> headers.

Labels
Top Solution Authors