how to remove json element using json parse in logic app?
Question
Tuesday, November 12, 2019 9:19 AM
Input json -
{
"data": {
"Testresults": [
{
"mydata": {
"id": "111",
"uri": "url",
"type": "demo"
},
"name": "",
"address": "",
in side Parse Json
schema added as below -
{
"properties": {
"data": {
"properties": {
"Testresults": {
"items": {
"properties": {
"name": {
"type": "string"
},
"address": {
"type": "string"
}
I have removed mydata
from Parse Json
schema still in the output getting same input json.
I want to remove mydata
element from input json and pass it further , what should be done for that in parseJson?
expected output after Parse Json
{
"data": {
"Testresults": [
{
"name": "",
"address": "",
I do not want to use any integration account please share you comment.
SE
All replies (2)
Tuesday, November 12, 2019 1:15 PM
The Parse JSON
action essentially tokenifies your JSON object for easier usage of its properties in subsequent actions. It doesn't alter the object in any way.
Without an integration account, removeProperty
is the function that you are looking for.
Note that this function works on objects, so for your case, you will need to use a foreach action to loop over Testresults
.
Tuesday, December 10, 2019 8:19 AM
Hi ashuthinks32 - Hope my answer helps.