GraphQL Query and Header for API

Question

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

BrandonB · Answer

@jbotbyl can you make a new post and tag me in it and provide the relevant details? I'd be happy to help out!

jbotbyl · Answer

I have been having issues with this as well. I have tried many different ways including what is shown in this post, cant seem to figure this out. Is it possible to have a example of the solution. I can also paste screenshots of my configurations as well. Any help would be appreciated. Thanks!

BrandonB · Answer

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.