I have a large array that looks something like this (heavily summarized):
[
{
"@ID":
"StandardFeature":
"EOBACNetFeature":
},
{
"@ID":
"StandardFeature":
"EOBACNetFeature":
"ParameterFeature":
}
]
I've tried to make a flow that pulls out all the values. item().['@ID'], item().StandardFeature, and item().EOBACNetFeature gets the values correctly, but item().ParameterFeature returns the error:
...cannot be evaluated because property 'ParameterFeature' doesn't exist, available properties are '@ID, StandardFeature, EOBACnetFeature'.
Because 'ParameterFeature' isn't in the first item in the array. How do I get 'ParameterFeature'? I've tried
if(equals(item().ParameterFeature,null),'',item().ParameterFeature)
for 'Value 2' in the table and that gives the same error.
(The whole JSON is super complicated with each array having different objects so the Parse JSON function doesn't work for me. I have to use this workaround)
