Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Solution Sage
Solution Sage

Help writing a function to avoid pagination limits in Web.Contents query from Wrike

Hi, I'm tring to pull data from Wrike via an API call and they have a limit on 1000 records on any query and provided me this feedback.


"However, you can use pagination to work around this limit ( To request pagination in your call, please, specify the pageSize parameter and use the nextPageToken from the response to query for additional pages until you get a page with no next page token, which is your last page in the data set. This way you should be able to get the full task list if it's longer than 1000 tasks."


Doing some research I found methhods for handling it but this requries parameters that the API does not support.  Instead they include a token as the last record than can be used to fetch the next record and I'm uncertain how to handle that.


Any help in allwoing me to make recursive calls to get around this 1000 record limit would be appreciated. 


Here is a copy of my base query


    Source = Web.Contents("",
                Headers=[#"Authorization"="bearer m5...IUK"]
    convertToJson = Json.Document(Source),
    data = convertToJson[data],
    #"Converted to Table" = Table.FromList(data, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"id", "accountId", "title", "description", "briefDescription", "parentIds", "superParentIds", "responsibleIds", "status", "importance", "createdDate", "updatedDate", "completedDate", "dates", "scope", "authorIds", "customStatusId", "hasAttachments", "attachmentCount", "permalink", "priority", "superTaskIds", "subTaskIds", "metadata", "customFields", "sharedIds", "dependencyIds"}, {"id", "accountId", "title", "description", "briefDescription", "parentIds", "superParentIds", "responsibleIds", "status", "importance", "createdDate", "updatedDate", "completedDate", "dates", "scope", "authorIds", "customStatusId", "hasAttachments", "attachmentCount", "permalink", "priority", "superTaskIds", "subTaskIds", "metadata", "customFields", "sharedIds", "dependencyIds"}),
    #"Fix Created Dates" = Table.TransformColumns(#"Expanded Column1",{{"createdDate", each Date.From(DateTimeZone.From(_)), type date}, {"updatedDate", each Date.From(DateTimeZone.From(_)), type date}}),
    #"Fix Complted Dates" = Table.TransformColumns(#"Fix Created Dates",{{"completedDate", each Date.From(DateTimeZone.From(_)), type date}}),
    #"Expanded dates" = Table.ExpandRecordColumn(#"Fix Complted Dates", "dates", {"type", "duration", "start", "due", "workOnWeekends"}, {"type", "duration", "start", "due", "workOnWeekends"}),
    #"Fix Date formatting" = Table.TransformColumns(#"Expanded dates",{{"start", each Date.From(DateTimeZone.From(_)), type date}, {"due", each Date.From(DateTimeZone.From(_)), type date}}),
    #"Removed Columns" = Table.RemoveColumns(#"Fix Date formatting",{"accountId", "metadata"})
    #"Removed Columns"
Not applicable

Hi @Seward12533 and @difg 


One way of getting around this is by using a third party tool – check this out:


It's a simple platform that does all the syncing for you.


– Bryce

Regular Visitor



Did you find the solution with nextPageToken of wrike?

I'm looking for a solution... I've made a lot os proves, but... it doesn´t work!


Thanks in advance.

Community Support
Community Support

Hi @Seward12533

Could you check this thread and discussion under it?

It may give you some ideas.


Best Regards


Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.