Output Specific data of JSON Object

Help Studio
, ,
1

I have a custom activity which returns data from database and then I’ve converted it to json which have multiple level and multiple collections. I want to log only some data of json object.
For example, I have following JSON

{
  "abc": [
    {
      "Id": "TEST-06",
      "No": 1,
      "Code": " ",
      "Description": ".....",
      "Percentage": null,
      "Details": []
    }
  ],
  "xyz": {
    "Id": "TEST-06",
    "No.": 1,
    "Date": "2018/07/06",
    "Enable": 0,
    "Reason": "....."
  }
}

I want to log only “abc”. Can anyone help with this?

2

@Maryum_Siddique

Check below

image

Using For each

image
image755×391 16 KB

Mark as solution if this helps

Thanks

3

Thank you so much it cleared some things. :slight_smile: I have two more scenarios.
Scenario 1: If we have JSON like this

{
  "Id": "TEST-06",
  "No": 1,
  "Code": " ",
  "Description": ".....",
  "Percentage": null,
  "Details": [],
  "xyz": [ {
      "Id": "TEST-06",
      "No.": 1,
      "Date": "2018/07/06",
      "Enable": 0,
      "Reason": "....."
    }
  ]
}

and we want all data except “xyz”.

Scenario 2:
If we have JSON like this:

{
  "abc": {
    "Id": "TEST-06",
    "Code": " ",
    "Description": ".....",
    "Percentage": null,
    "Details": [],
    "xyz": [
      {
        "Id": "TEST-06",
        "No.": 1,
        "Date": "2018/07/06",
        "Enable": 0,
        "Reason": "....."
      }
    ]
  }

and I only want abc and not xyz.
Really appreciate the help :slight_smile: