Alteryx Designer Desktop Discussions

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

API Call to website--Can I put the JSON Body here?

Archaeopteryx
10 - Fireball

Hi,

Please see screen shot. I have validated my JSON Body through Postman and it works, I get Payload, no errors, but, I get this error in my "DownloadHeaders" of my results pane in Alteryx Designer 2019.2:

 

HTTP/1.1 400 Bad Request
Date: Wed, 14 Oct 2020 15:24:19 GMT
Content-Type: application/json; charset=UTF-8
Content-Length: 96
Connection: keep-alive
x-ratelimit-remaining: 9
x-ratelimit-limit: 10
x-ratelimit-reset: 284
Strict-Transport-Security:...

 

In the Payload tab of the Downloads tool I am using the "Use Following for Query String/Body" and placing the Body of the JSON request in that box. My Headers are set up the same as in Postman. What am I missing? AlteryxJSONBodyInPayloadTabDownloadTool.png

3 REPLIES 3
TheOC
15 - Aurora
15 - Aurora

Hi @Archaeopteryx 

I've seen a similar issue before that was caused by no User-Agent Header within the request. I have an example of what to set this as here:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Download-Data-from-URL/m-p/646866/high...

I'd recommend giving this a go and seeing if it works - this was when the same issue arose of it working in postman but not within Alteryx, Postman assigns its own User-Agent.

If this doesn't work give me a shout and i'll have a further look!


Cheers!

Owen


Bulien
Archaeopteryx
10 - Fireball

Thank you,

I had an incomplete User-Agent header.

 

Thank you,

Chris

TheOC
15 - Aurora
15 - Aurora

Hi @Archaeopteryx 

Glad I could help, have a great week!


Bulien
Labels