JSON Replace transformation not working

[cmchaitu]

I'm trying to transform

 { "outputs": [
    { "type": "Sample" },
    {
      "type": "Sample1",
      "indexNamePrefix": "Sample2",
      "serviceUri": "Sample3",
      "eventDocumentTypeName": "Sample4"
    }
  ]
}

into something like this

{ "outputs": [
   { "type": "Sample" },
   {
     "type": "Sample1",
     "indexNamePrefix": "Sample2",
     "serviceUri": "NewValue",
     "eventDocumentTypeName": "Sample4"
   }
 ]
}

I have tried the couple of transforms based on your examples
Try 1:
I just tried to replace the serviceUri which was the only change, following the transform

{
  "outputs": {
    "@jdt.replace": {
      "@jdt.path": "@[?(@.serviceUri == Sample3)]",
      "@jdt.value": {
        "serviceUri": "NewValue"
      }
    }
  }
}

Result was something like below , which is similar to the transform and doesn't seem like transformation happened

{
 "outputs": {
    "@jdt.replace": {
      "@jdt.path": "@[?(@.serviceUri == Sample3)]",
      "@jdt.value": {
        "serviceUri": "NewValue"
      }
    }
}

Try 2:
I tried to replace the entire outputs node

{
  "outputs": {
    // Double brackets are needed to specify
    // the array as the transformation value
    "@jdt.replace": [
      [
        {
          "type": "Sample"
        },
        {
          "type": "Sample1",
          "indexNamePrefix": "Sample2",
          "serviceUri": "NewValue",
          "eventDocumentTypeName": "Sample4"
        }
      ]
    ]
  }
}

Result was the same as the transform here too , am I missing something ? because the basic remove and rename transforms are working fine.

Thanks in Advance

[pareshjoshi]

@cmchaitu
It looks like jpath for the "current element" does not work. The example given in the document does not work. For your specific case, change your transform rule to:

{
    "@jdt.replace": {
      "@jdt.path": "$.outputs[?(@.serviceUri == 'Sample3')]",
      "@jdt.value": {
        "serviceUri": "New Value"
      }
    }
}

Note: this overrides the entire object where serviceUri condition is met.

[cmchaitu]

Thanks , it works . Yes it overrides the entire object but I can do something like below :
{
"@jdt.replace": {
"@jdt.path": "$.outputs[?(@.serviceUri == 'Sample3')]",
"@jdt.value": {
"type": "Sample1",
"indexNamePrefix": "Sample2",
"serviceUri": "New Value"
"eventDocumentTypeName": "Sample4"
}
}
}

[pareshjoshi]

You may want to close the issue if it worked for you.

[cmchaitu]

Hi ,
I
I'm unable to use jdt.replace twice , it says
Warning - A member with the name "@jdt.replace" already exists.
I'm trying to change value of serviceuri of outputs and inputs

{ "outputs": [
{ "type": "Sample" },
{
"type": "Sample1",
"indexNamePrefix": "Sample2",
"serviceUri": "NewValue",
"eventDocumentTypeName": "Sample4"
}
],
{ "inputs": [
{ "type": "Sample" },
{
"type": "Sample1",
"indexNamePrefix": "Sample2",
"serviceUri": "NewValue",
"eventDocumentTypeName": "Sample4"
}
]
}
}

[pareshjoshi]

Yes, it wont allow, because you have two @jdt.replace at same level. The best solution is to understand why "@jdt.path": "@[?(@.serviceUri == Sample3)]", does not work and fix that.

I may try debug this in my free time (don't know when that would be). Can clone the repo and try and debug? Take example from the documentation.

[PepperDave]

Does this work? I am trying to replace array elements in appsettings.json and it is failing using the example syntax referred to above

[Metal-Frog]

You can use an array:
{
"@jdt.replace": [
{
"@jdt.path": "$.att1",
"@jdt.value": "some value"
},
{
"@jdt.path": "$.att2",
"@jdt.value": "also a value"
},
{
"@jdt.path": "$.att3",
"@jdt.value": "third value"
}
]
}