question Help with JOLT Spec to add new json key with a value from another key in Support Questions

Help with JOLT Spec to add new json key with a value from another key

Drew33 — Sat, 20 Apr 2024 03:17:59 GMT

Hoping someone can help me with a JOLT spec.

I have the following json:

{

"schemaVersion": "3.2",

"uniqueIdentifier": "ri.nzRNR5a3ad1AzOkv_2FU9WN6Z_2FluxpEl4eXjgUnYpgkvk_3D",

"entityType": "CAR"

}

and I need to use JOLT to transform to this:

{

"_id": "ri.nzRNR5a3ad1AzOkv_2FU9WN6Z_2FluxpEl4eXjgUnYpgkvk_3D",

"schemaVersion": "3.2",

"uniqueIdentifier": "ri.nzRNR5a3ad1AzOkv_2FU9WN6Z_2FluxpEl4eXjgUnYpgkvk_3D",

"entityType": "CAR"

}

I cannot figure out the correct spec.

Thanks!

SAMSAL — Sat, 20 Apr 2024 03:30:50 GMT

Hi,

You can do this in different ways , here is one of them:

[ { "operation": "shift", "spec": { "@uniqueIdentifier": "_id", "*": "&" } } ]

Hope that helps.

Drew33 — Sat, 20 Apr 2024 12:55:22 GMT

Thank you so much - that worked perfectly. I have so much to learn about JOLT.