Forum Discussion

rdorsey's avatar
rdorsey
Frequent Visitor
1 year ago
Solved

Using List.Generate for Token-Based API Call

This is my first time building something like this and I'm missing something really fundamental. I built a function in M called "Output" which takes text as a parameter and runs an API call using ...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    1 year ago

    Your syntax doesn't look right to me.

     

    Compare to the examples in this highly-related article:
    How to use List.Generate to make API Calls in Power Query M

    Code snippet from the article:

    List.Generate( 
  ()  =>  [ Offset = 100, Pokemon = GetPokemon(0) ], 
  each [Offset] <= 200,  
  each [ Pokemon = GetPokemon( [Offset] ), Offset = [Offset] + 100 ],  
  each [Pokemon] 
)

     

    Your code should probably look more like this:

    List.Generate( 
  ()  =>  [ token = "", results = Output("") ], 
  each [results][EarliestEntryDate] > Date.FromText("6/15/2025"),
  each [ token = [results][continuationToken], results = Output(token) ],  
  each [results]
)
V-yubandi-msft's avatar
V-yubandi-msft
Community Support
1 year ago

Hi rdorsey ,

Could you let us know if your issue has been resolved or if you are still experiencing difficulties? Your feedback is valuable to the community and can help others facing similar problems.


Thank You.

v-achippa's avatar
v-achippa
Community Support
1 year ago

Hi rdorsey,

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the issue is resolved? or let us know if you need any further assistance.
If any response helped in resolving the issue, please mark it as "Accept as solution" and give kudos if you found it helpful.

 

Thanks and regards,

Anjan Kumar Chippa