Power Platform Community Forum Thread Details

Hi all,
I'm using an API that returns data in JSON format. The data is returned 500 records at a time and has a skip function that allows you to return the next 500 results e.g. $skip 500. Note that if you say skip 5000 records and there was only 4900 the call will still function (won't error out), it just returns with minimal information (example below).
I am trying to set-up a loop that will stop running when the JSON data is missing the value field will be empty. It will also be missing the @OData.nextLink field. So far I have tried setting a condition that if

empty(body('Convert_HTTP_JSON_-_Get_Daily_Booking_Members_2')?['@odata.nextLink']) equals true will break the loop but this hasn't worked due to the empty check returning the opposite result then expected.

How can I create a loop that if value is empty it will break?

If it helps the last page always returns the following JSON:

{

"@odata.context": "https://samplewebsite.com",

"value": []

}

Sorry if this is an easy one.

Categories:

Building flows