Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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