Power Platform Community Forum Thread Details

Hello All,

I have done lots of searching for the solution to this issue but no matter now much I look, I can only find partially similar issues which does not help resolve what I am encountering.

My Flow

What I am trying to achieve is to obtain ID numbers from an API endpoint, then use them ID numbers in another API call within an apply to each loop to request additional data, I am going to output this via email once I have compiled the data.

Background

I have been success in calling both endpoints however, when attempting to compile the data from all of the calls, I am running into issues. Some of the calls that are being made are returning "body": [], this is expected as I know that there will be several calls where no data is expected. Unfortunately, I do not know on any given day, which of the calls will not i.e. ID number 5 today provides data, tomorrow it may or may not provide data. I have determined that the length is 30 when body = [] so have used a condition which appears to work. I have then parsed the JSON if the length is greater than 30 so that I can rebuild the JSON outside of the array that it is currently in.

Issue

When composing the data outside of the loop (which I have done before), it is creating multiple null's in the JSON, no matter what I do, I cannot seem to get rid of them.

Screenshots