Forum Discussion

Squarefoot's avatar
Squarefoot
Frequent Visitor
2 years ago

Loop REST API with List.Generate with continuation token

Hi,   I have Power Query script below, but am returning empty list in the Loop step and suspect I am not understanding List.Generate correctly. The API is described here let Source = Xml.Tabl...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago

Looks like your actual data may be a sub-element of [Result].  Unless [IsFinished]  is repeated for every record?

Squarefoot's avatar
Squarefoot
Frequent Visitor
2 years ago

Thanks for your reply. Just to check I understand what you're asking: fn_Next returns IsFinished everytime until true. The actual data are in ResultXml -- I'm attempting to generate a list of all the results of fn_Next, then keep only the ResultXml's. Am I using List.Generate correctly in this scenario? Apologies if I'm misunderstanding your comment.

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Your code looks a little off.  Not sure what 

     

    CombinedData = {Loop, ChangeType}

     

    is supposed to do. Create a list of a list and a table ?

     

    Does your first call (before the List.Generate) produce data ?

     


    As you can probably appreciate it is nearly impossible to help with API queries without access to said API  (which you may not be willing to provide for understandable reasons)

    • Squarefoot's avatar
      Squarefoot
      Frequent Visitor
      2 years ago

      Yes, the first call does produce data. In Combined result i was attempting to combine the inital results with loop results as list to fit with List.Generate -- I can appreciate my code is off, this is my first attempt to work directly in M rather than in the UI. I appreciate your comments and help though!