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!
