JSON to JSON using JOLT Transformation

Question

I am new to JOLT and got stuck up this requirement, i saw some examples online but in my requirement i needed to add element in a new structure. I hope anyone will be able to understand what i am trying to say

Input JSON

[
    {
        "ROWSET": {
            "ROW": {
                "CLTCORP": "1000",          //This is CorpId
                "CTLITEM": "5000",          //This is CorpItemCd
                "WHID":  "17",              //This is WarehouseId
                "CTLFAC":  "AAHC",          //This is FacilityName
                "CORP":    "001"            //This is CorpItem
            }
        }
    }
]

This is expected JSON

{
    "SupplyItemData": {
                        "CorpId": 1000,
                        "CorpItemCd": 5000
                            "Warehouse": [{
                                    "WarehouseId": 17,
                                    "FacilityName": "AAHC"
                                        }]
                            "CorpItem": 001
                        }
}

Any help or suggestion is appreciated.

I followed few links Transform JSON-JSON JOLT but could not relate exaclty to my use case

Udith Gunaratna · Accepted Answer · 2019-09-16 08:46:09Z

2

You can use the shift operator to do this. First use the * operator to interate through the root level array. Then inside that, simply map the fields to new field names as follows.

[
{
    "operation": "shift",
    "spec": {
        "*": {
            "ROWSET": {
                "ROW": {
                    "CLTCORP": "SupplyItemData.CorpId",
                    "CTLITEM": "SupplyItemData.CorpItemCd",
                    "WHID": "SupplyItemData.Warehouse.[0].WarehouseId",
                    "CTLFAC": "SupplyItemData.Warehouse.[0].FacilityName",
                    "CORP": "SupplyItemData.CorpItem"
                }
            }
        }
    }
}
]

answered Sep 16, 2019 at 8:46

Udith Gunaratna

2,1211 gold badge13 silver badges17 bronze badges

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

1 Comment

Udith Gunaratna Over a year ago

There is no such formal tutorial that I know of. But if you go through the questions and answers on Jolt issue tracker (github.com/bazaarvoice/jolt/issues), it covers various use cases.

Collectives™ on Stack Overflow

JSON to JSON using JOLT Transformation

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related