topic Re: Pagination for Graphql (Monday.com)data using Rest Connector in Connectivity & Data Prep

Pagination for Graphql (Monday.com)data using Rest Connector

Aditeeraipurkar1 — Thu, 14 Jul 2022 07:36:46 GMT

Hello Team,

I am struggling to page the data from Monday.com in qliksense.Monday.com stores data in the form of Graph ql.

I have tested the query already in Monday.com and also its giving result when I use it through POST method tab in Qliksense. As I need to page the data through custom pagination ,I have used WITH CONNECTION for it.

The script is as follows:

But it is giving me below error .

Re: Pagination for Graphql (Monday.com)data using Rest Connector

techbuilders — Wed, 03 Jan 2024 02:42:52 GMT

For those facing the same issue with Monday.com, use Postman to generate your query. You'll be able to directly copy and paste this query into your variable (vBody) and then you'll have to replace your double quotes with two Chr(34)'s to escape them.

LET vBody = Replace(vBody,'"',chr(34) & chr(34));

You'll then use this variable in your WITH CONNECTION(Body "$(vBody)") -- see snip. This is using Monday API version 2013-10