How do I pull data using an API?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
download tool -> headers.
