I have searched high and low for this and cannot find a solution.
I want to create a response schema for my Logic App.
The app selects data from the document db which includes metadata fields like _etag, _ts, _rid etc.
I want to remove those fields from the reponse object.
I tried Parse Json and it just ignores the schema and adds in all the fields I don't want.
Here is the input it gets..
[
{
"id": "1",
"provider": "Microsoft",
"examCode": "AZ-900",
"body": "Question 1 about blah blah blah",
"_rid": "vLoPANg8VjcBAAAAAAAAAA==",
"_self": "dbs/vLoPAA==/colls/vLoPANg8Vjc=/docs/vLoPANg8VjcBAAAAAAAAAA==/",
"_etag": "\"79001ad3-0000-0d00-0000-60e823830000\"",
"_attachments": "attachments/",
"_ts": 1625826179
}
]
Here is the schema..
{
"type": "array",
"items": {
"type": "object",
"properties": {
"body": {
"type": "string"
},
"examCode": {
"type": "string"
},
"id": {
"type": "string"
},
"provider": {
"type": "string"
}
},
"required": [
"id",
"provider",
"examCode",
"body"
]
}
}
Here is the output..
[
{
"id": "1",
"provider": "Microsoft",
"examCode": "AZ-900",
"body": "Question 1 about blah blah blah",
"_rid": "vLoPANg8VjcBAAAAAAAAAA==",
"_self": "dbs/vLoPAA==/colls/vLoPANg8Vjc=/docs/vLoPANg8VjcBAAAAAAAAAA==/",
"_etag": "\"79001ad3-0000-0d00-0000-60e823830000\"",
"_attachments": "attachments/",
"_ts": 1625826179
}
]
So what's the point of Parse Json if it doesn't follow the schema?

