Forum Discussion

Wayne74's avatar
Wayne74
Helper I
3 years ago

PowerQuery API Pagination Help

Hi All,   I am really stuck here at the moment and just need a pointer or hint or something to know where to look.  I am calling an API from Canvas to get accounts, courses and enrollments.  Accoun...
Need Help
lbendlin's avatar
lbendlin
Super User
3 years ago

You asked for Value.MetaData - that will not give you the payload of the request which has the data and pagination information.

 

Note that your approach will not work for scheduled refresh.  Read about RelativePath.

Wayne74's avatar
Wayne74
Helper I
3 years ago

I have looked into Relative path and I am fixing that thank you.  Still haven't worked out how to get the header yet though with the link to the next bookmark.

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    Use Web.Contents directly.  That should give you the header data and the payload.