String to Object

[KTsnap]

Hi All, KIndly help to get below output

"entity": [
      {
        "tenantId": "tv",
        "type": "rdm/lookupTypes/FAMILY_TYPE",
        "code": "Delivery Assurance",
        "enabled": true,
        "parents": [
          "rdm/lookupTypes/FAMILY/Consulting",
          "rdm/lookupTypes/FAMILY/Services"
        ]
      },
       {
        "tenantId": "tv",
        "type": "rdm/lookupTypes/PARENT_TYPE",
        "code": "Delivery Service",
        "enabled": true,
        "parents": [
          "rdm/lookupTypes/FAMILY/Training"
        ]
      }
    ]

Output

[
	{ 
	"code": "Delivery Assurance",
	"Parents" : "Consulting"
	},
	{
	"code": "Delivery Assurance",
	"Parents" : "Services"
	},
	{
	"code": "Delivery Service",
	"Parents" : "Training"
	}
	]

[SpiroTaleski]

@KTsnap

Please find the attached sample pipeline:

Community_2021_09_28.slp (5.2 KB)

Regards,
Spiro Taleski

[KTsnap]

THanks a lot. this is really helpful.