Forum Discussion

rbreneman's avatar
rbreneman
Icon for Helper II rankHelper II
4 years ago
Solved

Looping M code function for ServiceNow API

Hi!   I'm hoping someone can help me. I feel like I'm close and I've seen lots of information online about this I just can't seem to get the right combination or syntax. I have a function built and...
Need Help
rbreneman's avatar
rbreneman
Icon for Helper II rankHelper II
4 years ago

Disregard. I found a solution!

 

Here is my working table query:

 

let
    Source = List.Generate(
        () => [Offset = 10000, x = function_user(0)],
        each not List.IsEmpty( [x][result] ),
        each [offset = [Offset] + 10000, x = function_user([Offset]) ],
        each [x]
    )
in
    Source

 

 

This video and article were a huge help: https://gorilla.bi/power-query/list-generate-api-calls/, https://www.youtube.com/watch?v=a_RJzoj1cnM.

 

Hopefully this helps someone else!

njglen's avatar
njglen
New Member
4 years ago

Just a correction in table Query:

let
    Source = List.Generate(
        () => [Offset = 10000, x = function_user(0)],
        each not List.IsEmpty( [x][result] ),
        each [Offset = [Offset] + 10000, x = function_user([Offset]) ],
        each [x]
    )
in
    Source

 
Capital O in the 5th line for the first Offset --> each [Offset = [Offset]


This rbreneman for this it works really well for my ServiceNow report.