Power Platform Community Forum Thread Details

GET HTTP Body - Empty Object not coming through as null (or anything at all) using items() expression using SELECT Data Operation flow

I access data via a HTTP action to a REST API service.

The HTTP response has an object which mostly has and Item "ProjectManager" and properties (ID,Name) but this can be empty - depending if a user has updated this on our cloud service or not.

I have performed "Parse Json" to the HTTP Body and attempted to use a SELECT Data operation flow to map the response before eventual movement of this to SQL server, but I get the following error:

The execution of template action 'Select' failed: The evaluation of 'query' action 'where' expression '{ "Project_ID": "@item()['ID']", "Project_Manager_ID": "@item()['ProjectManager']['ID']", "Project_Manager_Name": "@item()['ProjectManager']['Name']" }' failed: 'The template language expression 'item()['ProjectManager']['ID']' cannot be evaluated because property 'ID' doesn't exist, available properties are ''. Please see https://aka.ms/logicexpressions for usage details.'.

Sample response as follows:

[

{

"ID": 71571,

"ProjectManager": {

"ID": 123,

"Name": "John"

}

{

"ID": 71250,

"ProjectManager": {}

{

"ID": 21286,

"ProjectManager": {

"ID": 569,

"Name": "Ben"

}

{

"ID": 81250,

"ProjectManager": {}

{

"ID": 41818,

"ProjectManager": {}

}

]

I've tried to follow a few of the suggestions others who have had a similar issue with, making changes to the auto generated schema etc but nothing has work. I'm by no means an expert so hopefully someone has a few ideas I could try?

Thanks

Quick Links

Leaderboard