Hi Folks,
I connect to the Monday.com api from Alteryx.
I get all the first 500 records with issue but having trouble with the next 500 by using next_items_page. By using the cursor from the first 500 records, the query works well in API playground. However, when I use the same query in Alteryx, I just keep getting error messages.
When I try to query with Content-Type = “application/json”, I receive an error message for DownloadHeaders:
HTTP/1.1 500 Internal Server Error
Date: Fri, 16 Feb 2024 16:46:42 GMT
Content-Type: text/html
Transfer-Encoding: chunked
Connection: keep-alive
x-request-id: 1b0d73bf-b731-99b8-b1a0-0308cc78235e
x-runtime: 8.957594
x-envoy-upstream-service-time:…
When I try to query without Content-Type = “application/json”, I manage to get through with DownloadHeaders return “HTTP.1.1 200 OK” but I receive an error message for the DownloadData, {“errors”:[{“message”:“No query string was present”}],“account_id”:12345678}
Like I previously mentioned, the query works perfectly fine in the API playground but just does not work in Alteryx.
Here is the query that I use for the first page and works in Alteryx:
{“query”: “query{boards(ids: 123456789) {items_page(limit: 500) {cursor items {id name column_values {column {title} text value}}}}}”}
Here is the query that I use for the second page and it works in the API playground but not in Alteryx:
{“query”: “query{ next_items_page(limit: 500, cursor: “xxxxxxxxxxxxxxxxxxxxxxxxxx”) { cursor items { id name column_values {column { title} text value }}}}”}
Any help will be greatly appreciated!!