Forum Discussion

Wayne74's avatar
Wayne74
Icon for Helper I rankHelper 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
Icon for Super User rankSuper 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
    Icon for Helper I rankHelper 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
      Icon for Super User rankSuper User
      3 years ago

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