Hi guys,
I've been looking around the internet but cant find the answer. Is there a way to use an input to get a table from a monday.com board? Something similar to the sharepoint connectors?
Thanks
Solved! Go to Solution.
Hi @Jimrich88
Breaking it down into pieces:
POST - This is the type of HTTP action so the payload tab needs to have the drop down selecting POST as the option
-H "Content-Type:application/json" - the H in front of this tells you that it is a header. Create a new value where name is Content-Type and value is application/json
-H "Authorization: TOKEN" - This is another header. You can create another value where name is Authorization and value is the token
-d "{\"query\":\"query{boards(ids: XXXX){name}}\"}" - This is the actual query itself which can be hard coded into the query box in the payload tab
"Monday API Link" - This is the URL which can be put in a text input tool before the download tool. Make sure that the first tab of the download tool configuration points at this field to pull the URL from
If you aren't getting any data back but the API call is executing successfully it is probably due to the query being incorrectly formatted. I would try to do this in the Monday.com API playground https://monday.com/developers/v2/try-it-yourself and then copy the query exactly as it is into the download tool.
Hi Brandon,
Thanks very much for your reply.
I have tried the exact same configuration that you detailed in your post but it doesn't work.
The error I get is Internal Error 500
I have tested the query in the Monday.com API playground and it works fine.
I can only get it to work via the command promt.
Is it possible to send you some screen shots of my Alteryx configuration?
Thank you!
@Jimrich88 sure a private message is probably best