Forum Discussion

rsderby68's avatar
rsderby68
Resolver I
3 years ago
Solved

API Query looping and not stopping at null results? Help!

Hello Helpful Query Experts,   I am trying to get data from a particularly troublesome API.  It requires a POST command to get results and hides the total record information in return headers which...
Need Help
  • rsderby68's avatar
    rsderby68
    3 years ago

    Nevermind I figured it out.  It was actually returning an empty list {} of all things which was causing the loop.  Got it working now!!  

ppm1's avatar
ppm1
Solution Sage
3 years ago

An empty record does not equal null (see pic below). Try using Record.FieldCount([Result])>0 as your condition instead.

 

 

Pat

  • rsderby68's avatar
    rsderby68
    Resolver I
    3 years ago

    Is this what you are suggestion?  When I run this I get this error.  What am I doing wrong? 

     

     

    let
    Source = List.Generate(()=>
    [Result = try fTessPage(1) otherwise 0, tpage=1],
    each Record.FieldCount([Result]) > 0,
    each [Result = try fTessPage([tpage]+1) otherwise 0, tpage=[tpage]+1], each [Result])
    in
    Source