Jolt Transform Issue

Question

I'm facing an issue with implementing my Jolt Spec to transform this input.

input:

[
  {
    "organizationName": "TOTOLAND",
    "organizationUid": "123456789",
    "usageByLicenseAndProduct": [
      {
        "productType": "VSPC",
        "licenseEdition": "Enterprise Plus",
        "workloadUsage": [
          {
            "workloadType": "VAC_Workstation_Agent"
          },
          {
            "workloadType": "VAC_Server_Agent"
          }
        ]
      }
    ]
  },
  {
    "organizationName": "TOTOLAND2",
    "organizationUid": "456789",
    "usageByLicenseAndProduct": [
      {
        "productType": "VSPC",
        "licenseEdition": "Enterprise Plus",
        "workloadUsage": [
          {
            "workloadType": "VAC_Workstation_Agent"
          }
        ]
      },
      {
        "productType": "BackupAndReplication",
        "licenseEdition": "Enterprise Plus",
        "workloadUsage": [
          {
            "workloadType": "VAC_Workstation_Agent"
          }
        ]
      }
    ]
  }
]

Output:

[
  {
    "organizationName": "TOTOLAND",
    "organizationUid": "123456789",
    "productType": "VSPC",
    "licenseEdition": "Enterprise Plus",
    "workloadType": "VAC_Workstation_Agent"
  },
  {
    "organizationName": "TOTOLAND",
    "organizationUid": "123456789",
    "productType": "VSPC",
    "licenseEdition": "Enterprise Plus",
    "workloadType": "VAC_Server_Agent"
  },
  {
    "organizationName": "TOTOLAND2",
    "organizationUid": "456789",
    "productType": "VSPC",
    "licenseEdition": "Enterprise Plus",
    "workloadType": "VAC_Workstation_Agent"
  }
]

I tried multiple Jolt Specs via jolt-demo.appspot.com, but I failed to have a satisfying transformation...

Could you help me? Thanks a lot! Gatien

My answer updated and work properly with your new input. – Mohammadreza Khedri Mar 01 '23 at 11:11 — Mohammadreza Khedri, Mar 01 '23 at 11:11

Mohammadreza Khedri · Accepted Answer · 2023-03-01T11:10:11.150

You can use this spec:

[
  {
    "operation": "shift",
    "spec": {
      "*": {
        "usageByLicenseAndProduct": {
          "*": {
            "workloadUsage": {
              "*": {
                "*": "@(5,organizationUid).@(3,productType).@(1,workloadType).&",
                "@(4,organizationName)": "@(5,organizationUid).@(3,productType).@(1,workloadType).organizationName",
                "@(4,organizationUid)": "@(5,organizationUid).@(3,productType).@(1,workloadType).organizationUid",
                "@(2,productType)": "@(5,organizationUid).@(3,productType).@(1,workloadType).productType",
                "@(2,licenseEdition)": "@(5,organizationUid).@(3,productType).@(1,workloadType).licenseEdition"
              }
            }
          }
        }
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "*": {
        "*": {
          "@": "[]"
        }
      }
    }
  }
]

Thank you soooo much, Mohammad !!!! It's perfect for my case, and it helps me a lot to understand Jolt usage :) — Gatien FERRAND, Mar 01 '23 at 13:16
@GatienFERRAND You're welcome. Just this answer is not compatible with the current question. I edited your question. — Mohammadreza Khedri, Mar 01 '23 at 13:22

Jolt Transform Issue

1 Answers1