Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Aditeeraipurkar1
Contributor
Contributor

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

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:

Aditeeraipurkar1_1-1657783991690.png

 

But it is giving me below error .

Aditeeraipurkar1_0-1657783915778.png

 

Labels (3)
1 Reply
techbuilders
Partner - Contributor
Partner - Contributor

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

techbuilders_1-1704249743933.png