Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
I am trying to get data from a Graphql API, but I am struggling with getting the header and query correct. It is very well documented for how to do it from python etc (https://monday.com/developers/v2#queries-section) but I am struggling to adapt this to doing it in Alteryx. I have the connection working in excel, so I can confirm the API works.
I think the URL part is fairly simple:
When it comes to creating the query and body I am struggling to compose the correct terms. Particularly struggling with where the ' and " should be going as I cant find any documentation to tell me where it is required. I have hidden the API key from the below to keep data privacy, but that API key works in excel where I can connect.
My download tool is configured as per the below images, I have tried changing various settings here but none have helped
The output I get is as follows:
---------------
Update: I managed to get it to work by building the query in the URL, I don't understand why it didnt work in the payload part would be interested to understand what I was doing wrong there but it is now working
For the headers have you tried hard coding them into the download tool like this:
And then for the query, either putting it in the "Take Query String/Body from Field" or "Use Following for Query String/Body"
I think your issue is most likely coming from this second part. Maybe instead of checking the box for the query field in the payload, you instead use the "Take Query String/Body from Field" and choose the query column that you have created.
