Forum Discussion

stew_ia's avatar
stew_ia
Frequent Visitor
6 years ago
Solved

JSON with empty array

I'm working with a 3rd party REST API that returns an empty Results array when all of the data has been consumed.  "Results":[]    This seems like it should be easy enough but it has me stumped.  I'...
Need Help
  • stew_ia's avatar
    stew_ia
    6 years ago

    That did it JirkaZ,  prolem solved.  

    Results2 = if (Record.HasFields(Results1{0}, {"Id"})) then Results1 else null

JirkaZ's avatar
JirkaZ
Solution Specialist
6 years ago

stew_ia Not sure from the top of my head but Json.Document typically returns a record, correct? So you could test the record with Record.HasFields perhaps?

stew_ia's avatar
stew_ia
Frequent Visitor
6 years ago

That did it JirkaZ,  prolem solved.  

Results2 = if (Record.HasFields(Results1{0}, {"Id"})) then Results1 else null

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi stew_ia ,

     

    Glad to hear that. Please accept your reply as a solution so that people who may have the same question can get the solution directly.

     

     

    Best Regards,

    Icey