JOLT Specification to Transform JSON field value to field name

Question

I am trying to convert the below JSON payload into a JSON which has the field name as the value of the field: The jolt file that I have is working if field values are different. But if field values are the same then it is giving an array in the response.

Can you please help to provide jolt specifications for this?

Input JSON Payload :

{
  "action": {
    "allowPartialSuccess": true,
    "records": [
      {
        "ZuoraSubscriptionExtId": "962041ad-e673-492a-a071-5e0ab74ea001",
        "CPQSubscriptionID__c": "5640029343"
      },
      {
        "ZuoraSubscriptionExtId": "962041ad-e673-492a-a071-5e0ab74ea001",
        "CPQSubscriptionID__c": "5640029343"
      }
    ],
    "type": "update"
  }
}

`

Expected output JSON Payload :

{
  "action" : {
    "allowPartialSuccess" : true,
    "records" :  {
      "962041ad-e673-492a-a071-5e0ab74ea001" : {
        "CPQSubscriptionID__c" : "5640029343"
      }
    }, {
      "962041ad-e673-492a-a071-5e0ab74ea001" : {
        "CPQSubscriptionID__c" : "5640029343"
      }
    } ,
    "type" : "update"
  }
}

JOLT specification that I am using :

[
  {
    "operation": "shift",
    "spec": {
      "action": {
        "allowPartialSuccess": "action.allowPartialSuccess",
        "records": {
          "*": {
            "CPQSubscriptionID__c": "action.records.@(1,ZuoraSubscriptionExtId).CPQSubscriptionID__c"
          }
        },
        "type": "action.type"
      }
    }
  }
]

Your expected output is wrong. you cant have 2 same object in your record that is not array — Mohammadreza Khedri
– Mohammadreza Khedri, Commented Dec 20, 2022 at 11:23

Mohammadreza Khedri · Accepted Answer · 2022-12-20 11:20:00Z

2

You can use this shift transformation spec

[
  {
    "operation": "shift",
    "spec": {
      "*": {
        "*": "&1.&", // &1 replicates the literal "action"
        "records": {
          "*": {
            "C*": "&3.&2.@(1,ZuoraSubscriptionExtId).&" // &3 replicates the literal "action" (by going three level up the tree), &2 for "records", & replicates the current level attribute
          }
        }
      }
    }
  }
]

the demo on the site http://jolt-demo.appspot.com/ is

edited Dec 20, 2022 at 11:20

Mohammadreza Khedri

2,7392 gold badges13 silver badges28 bronze badges

answered Dec 20, 2022 at 11:11

Barbaros Özhan

65.9k11 gold badges36 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Mohammadreza Khedri Over a year ago

But, This answer has the same result!

Barbaros Özhan Over a year ago

No, not the same, but I think that you wanted to notify for the extra object wrapper comes after "records", but that would make it an array rather than an object, eg. the desired output should presumably be two consecutive objects with different labels. Otherwise that is already a wrong JSON value. @MohammadReza

Mohammadreza Khedri Over a year ago

If assume desired output is an object we have the same ids for that. so to prevent the same values that create an array in output, we need a cardinality spec.

Mohammadreza Khedri · Accepted Answer · 2022-12-20 11:37:16Z

Your expected output is wrong in the question.

If you want an object in your record, You can use this spec:

[
  {
    "operation": "shift",
    "spec": {
      "*": {
        "&": "&1.&",
        "records": {
          "*": {
            "CPQSubscriptionID__c": "&3.&2.@(1,ZuoraSubscriptionExtId).CPQSubscriptionID__c"
          }
        }
      }
    }
  },
  {
    "operation": "cardinality",
    "spec": {
      "*": {
        "records": {
          "*": {
            "*": "ONE"
          }
        }
      }
    }
  }
]

And if you want an array in your output. You can use this spec:

[
  {
    "operation": "shift",
    "spec": {
      "*": {
        "*": "&1.&",
        "records": {
          "*": {
            "CPQSubscriptionID__c": "&3.&2[].@(1,ZuoraSubscriptionExtId).CPQSubscriptionID__c"
          }
        }
      }
    }
  }
]

Collectives™ on Stack Overflow

JOLT Specification to Transform JSON field value to field name

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related