Share via


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.