Parse JSON not showing all columns

[ReneAlvarezM]

Hi all. I'm building a (simple) flow to test some scenarios. Basically I'm getting data from a REST API call.

After the call, I'm getting rid of the first part of the response to properly pass it to the Parse JSON step like this:

And then I'm parsing the JSON response with a schema created from the original output. Only thing I needed to modify is that I added a "null" data type option because otherwise I got the error of a null being returned instead the data itself. This is the beginning of the schema:

{
"type": "array",
"items": {
"type": "object",
"properties": {
"Id": {
"type": ["string","null"]
},
"Name": {
"type": ["string","null"]
},
"Created": {
"type": ["string","null"]
},
"Modified": {
"type": ["string","null"]
},
"ModifiedBy": {},
"CreatedBy": {},
"PlanId": {
"type": ["string","null"]
},
"ParentTaskId": {
"type": ["string","null"]
},
"Leaf": {
"type": ["boolean","null"]
},
"WorkTypeId": {
"type": ["string","null"]
},
"WorkType": {
"type": ["string","null"]
},

The flow works fine and I'm getting all the values if I run it, however most of the columns are simply not there if I try to use them in a new step. For example, the next thing I need to do is filter this output by a known value for the "WorkType" column but that option is not present at all.

Obviously I'm missing something but cannot figure out what. What am I missing/doing wrong?

Thanks!

[v-litu-msft · Accepted solution]

Hi @ReneAlvarezM,

If the dynamic content disappears, how about you using the expression to get them?

For example:

item()?['WorkType']

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ReneAlvarezM]

Great suggestion and actually it works!