Unable to properly Transform nested array with JOLT

Question

I'm trying to convert json nested array's element and unable to get expected result, either I properly get name element or schemaExtensions element but can't get both together.

Here is my input:

{
  "rows": [
    {
      "content": {
        "name": {
          "content": "User"
        },
        "schemaExtensions": {
          "content": [
            {
              "content": {
                "schema": {
                  "content": "User"
                },
                "required": {
                  "content": true
                }
              }
            }
          ]
        }
      }
    }
  ]
}

And the JOlt spec definition:

  [
    {
      "operation": "shift",
      "spec": {
        "rows": {
          "*": {
            "content": {
              "name": {
                "content": "[&3].name"
              },
              "schemaExtensions": {
                "content": {
                  "*": {
                    "content": {
                      "schema": {
                        "content": "schemaExtensions.[&7].schema"
                      },
                      "required": {
                        "content": "schemaExtensions.[&7].required"
                      }
                    }
                  }
                }
              }
            }
          }
        }
      }
    }
]

The expected result:

[ {
  "name" : "User",
  "schemaExtensions": [ {
       "schema":"User",
       "required":true
    }]
}]

Here is the result I got when having both in my spec

[ {
  "name" : "User"
} ]

And if I remove name from my spec, then I get my schemaExtensions properly:

{
  "schemaExtensions" : [ {
    "schema" : "urn:ietf:params:scim:schemas:extension:enterprise:2.0:User",
    "required" : true
  } ]
}

Barbaros Özhan · Accepted Answer · 2021-06-14 18:38:02Z

1

You can start with three level nesting to roam before writing the branches(name&schemaExtensions) explicitly. No need to write other key names such as

[
  {
    "operation": "shift",
    "spec": {
      "*": {
        "*": {
          "*": {
            "name": { "*": "&1" },
            "schemaExtensions": {
              "*": {
                "*": { "*": { "*": { "*": "&5.&1" } } }
              }
            }
          }
        }
      }
    }
  }
]

answered Jun 14, 2021 at 18:38

Barbaros Özhan

65.9k11 gold badges36 silver badges64 bronze badges

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

2 Comments

Christian Demers Over a year ago

No because I'll lose array from rows. Also name should be element from bigger elment in row not a row itself. But your answer gave me good hint for another one I have to produce

Barbaros Özhan Over a year ago

I've answered depending on the current case, if you have other elements than content within the leaf elements, then just replace "*": "&5.&1" with "content": "&5.&1" @ChristianDemers

Arun Sai · Accepted Answer · 2021-06-14 15:18:36Z

0

 [
      {
        "operation": "shift",
        "spec": {
          "rows": {
            "*": {
              "content": {
                "name": {
                  "content": "[].name"
                },
                "schemaExtensions": {
                  "content": {
                    "*": {
                      "content": {
                        "schema": {
                          "content": "[&7].schemaExtensions[&7].schema"
                        },
                        "required": {
                          "content": "[&7].schemaExtensions[&7].required"
                        }
                      }
                    }
                  }
                }
              }
            }
          }
        }
        }
    ]

answered Jun 14, 2021 at 15:18

Arun Sai

2,0021 gold badge16 silver badges32 bronze badges

1 Comment

Christian Demers Over a year ago

Thks, only thing I change, I kept [&3].name and everything work perfectly as expected

Collectives™ on Stack Overflow

Unable to properly Transform nested array with JOLT

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related