Payload Format :: { [ { "key1" : "value1", "key2" : "value2" }, { "key3" : "value3", "key4" : "value4" }, { "key5" : "value5", "key6" : "value6" } ] , template:{template.jslt} }

Hello, I have the following JSLT file:

{
  "formId": "Company",
  "fieldValues":
    [
        {
            "name": "CompanyName",
            "value": {
                "en_US": string(.data.companyName)
            }
        },
        if (contains("Android", array(.data.platforms)))
        {
            "name": "PlatformAndroid",
            "value": {
                "en_US": true
            }
        },
        if (contains("IOS", array(.data.platforms)))
        {
            "name": "PlatformIOS",
            "value": {
                "en_US": true
            }
        },
        if (contains("MicrosoftStore", array(.data.platforms)))
        {
            "name": "PlatformMicrosoftStore",
            "value": {
                "en_US": true
            }
        },
        {
            "name": "Pack",
            "value": {
                "en_US": string(.data.pack)
            }
        }
    ]
}

But the fieldValues array contains nulls if there are no platforms checked because of the behavior of if statement.

Before this solution, I tried to iterate over .data.platforms but I couldn't because in this case the result will be a separated array. After that I tried to define a new function for that, but I couldn't.

Do you have any idea? Thank you.

@larsga and others,

I have following am struggling to flatten it, need help to understand what I am doing wrong.

Input [ { "movies": [ { "movie": "The Equalizer II", "properties": { "name": "action", "creationDate": "2018-07-20T03:37:18.190909+00:00" } }, { "movie": "Mamma mia", "properties": { "name": "drama", "creationDate": "2018-07-20T03:37:18.190909+00:00" } } ], "knownas": [ { "movies": "release this week", "properties": { "name": "premierlist", "creationDate": "2018-07-20T03:37:18.190909+00:00" } } ], "top": { "properties": { "name": "new movies", "creationDate": "2018-07-20T03:37:18.190909+00:00" } } }, { "movies": [ { "movie": "Jurassic World: Fallen Kingdom", "properties": { "name": "SiFi", "creationDate": "2018-07-20T03:37:18.190909+00:00" } }, { "movie": "incredibles 2", "properties": { "name": "family", "creationDate": "2018-07-20T03:37:18.190909+00:00" } } ], "knownas": [null], "top": { "properties": { "name": "monthly topper", "creationDate": "2018-07-20T03:37:18.190909+00:00" } } } ]

output:

[ { "type": "monthly topper" }, { "type" : "new movies"
}, { "type" : "premierlist" }, { "name": "The Equalizer II" "type" : "action", "parents" : [{ "type": "new movies" },{ "type": "premierlist" }] }, { "name": "Mamma mia" "type" : "drama", "parents" : [{ "type": "new movies" },{ "type": "premierlist" }]
}, { "name": "Jurassic World: Fallen Kingdom" "type" : "drama", "parents" : { "type": "monthly topper" }
}, { "name": "incredibles 2" "type" : "drama", "parents" : { "type": "monthly topper" }
} ]

currently, I have the following transformation

[for (.[0:]) {"type": .top.properties.name}, [for (.movies){ "name": .movie, "type": .properties.name }] ]

Hello,

We are using JSLT to achieve dynamic mapping configurations. But couldn't find a quick way to do string functions like trim, padding, replace etc.

Would you have any pointers for the same?

Hi there,

Just getting started with JSLT so may have misunderstood something, but I would have expected this JSLT program to be self-producing: {"foo": {}}

Instead the playground outputs an empty object: { }

The behavior seems to be that if a dictionary value is the empty object anywhere in the JSON document, then the key is omitted from the output. Is this expected?

source ==>

"info":[ {"age":"18","name":"bob"}, {"age":"50","name":"jack"} ]

target ==>

info2: [for(.info)

// todo : i want to get item where name > 20 , what shoud i do , Can someone help me ? { "age2" : .age, "name2" : .name }

]

Desired outcome

"info2":[ {"age":"50","name":"jack"} ]

Consider adding a function parse_url() so that it decomposes the url in it's component as a JSON object.

To illustrate:

The following JSTL expression

parse_url('https://www.aftonbladet.se/nyheter/a/opyK1R/snosmocka-pa-ingang--kan-bli-20-centimeter?utm_source=aaaa&utm_campaign=bbbb&utm_medium=cccc&utm_content=dddd&utm_term=eeee')

would evaluate to

{
  "fragment": null,
  "host": "www.aftonbladet.se",
  "parameters": {
    "utm_campaign": "bbbb",
    "utm_content": "dddd",
    "utm_medium": "cccc",
    "utm_source": "aaaa",
    "utm_term": "eeee"
  },
  "path": "nyheter/a/opyK1R/snosmocka-pa-ingang--kan-bli-20-centimeter",
  "port": null,
  "query": "utm_source=aaaa&utm_campaign=bbbb&utm_medium=cccc&utm_content=dddd&utm_term=eeee",
  "scheme": "https"
}

Use case: This function would allow to write transformations that extract UTM tags from the URL.

Hi, I was wondering if it is possible to get the index of the current item when doing some transformation inside a "for" expression?

For example for the input:

{ "rows" : [
{"name":"test"},
{"name":"test 2"}
]}

I would like to add row number entries like:

{ "rows" : [
{"name" : "test", "rowNo" : 1},
{"name" : "test 2", "rowNo" : 2}
]}

I was able to achieve this using functions like this (functions are borrowed from issue #122):

let rows = .rows

def index-of(array, value)
  find-index-of($array, $value, 0)

def find-index-of(array, value, index)
  if ($index >= size($array))
    -1
  else if ($array[$index] == $value)
    $index
  else
    find-index-of($array, $value, $index + 1)

{ "rows" : [ for (.rows) {
let rn = index-of($rows, .) + 1
"name":.name,
"rowNo": $rn
}]}

However, I wonder if there is a better way or if some variable (automatically set to proper value) could be added to for expression automatically to achieve same goal with simpler JSTL code, for example:

{ "rows" : [ for (.rows) {
"name":.name,
"rowNo": $forIdx + 1
}]}

Thanks :)

Hi, I did not find mention of a "indexOf" function. Given an array the function would act like

let array = array(["toto", "tutu", "tata"])  
$array.indexOf("toto") // return 0
$array.indexOf("tata") // return 2

Is there such function? Thank you!

Input

{
  "a": {
    "b": 1,
    "c": 2, 
    "d": 3
  } 
}

I want to simplify [ .a.b, .a.c, a.d ] to .a | [.b, .c, .d]. The idea is that the context node . inside [.b, .c, .d] no longer points to the input node but to .a instead.

Hello ! I have

let array1 = [
  {...},
  {...}
]

let array2 = [
  {...},
  {...}
]

I need to have access at array1[0] when i'm treating array2[0], as well, as array1[1] when i'm treating array2[1] and so on, I need to iterate in both of them as the same rythm, supposing then that they have the same size.

I don't see how I can progress in both of them at the same time with JSLT, is there something that I am missing ?

Thank you for reading !

Best regards

Example input json { "abc":"abc" }

output { "abc": this value should come from a java method call }

Then how do we write the jslt rule.

I'm passing in a variable prior to calling the template. The primary file (root.jslt) can access the variable.

let identifier = $headers.Identifier

{ "id": $identifier, ... }

Now I have a second jslt file which I import within root

import "client.jslt" as client

When declaring the following within client.jslt

let identifier = $headers.Identifier

I get the exception "No such variable $headers"

if I remove the let statement from the root.jslt (i.e., don't use it in that file) then client.jslt works! It appears that once you use the variable in any file it is no longer available? Creating a common.jslt and including that in both also doesn't work.

Ron

Can a jslt filter achieve the following?

Given the Json

{
  "clientNames": [
    {
      "type": "Name",
      "clientNameTypeCode": 634,
      "startDate": "2022-09-06",
      "inModeCode": "U"
    }
  ],
  "client": {
    "clientIdentifiers": [
      {
        "identifierTypeCode": 25,
        "identifierStatus": "REGD",
        "identifierStartDate": "2022-09-06"
      },
      {
        "identifierTypeCode": 525,
        "identifierTypeCodeDecode": "Entity",
        "identifierLatestIndicator": "Y",
        "identifierStartDate": "2022-09-06",
        "inModeCode": "I"
      }
    ],
    "clientInternalId": "<<unknown>>",
    "Id": "1d21044e7cd4a593c2046503a09dc653"
  },
  "domain": "clients"
}

I need the tree structure to only include nodes that contain inModeCode and produce the following

{
  "clientNames": [
    {
      "type": "Name",
      "clientNameTypeCode": 634,
      "startDate": "2022-09-06",
      "inModeCode": "U"
    }
  ],
  "client": {
    "clientIdentifiers": [
      {
        "identifierTypeCode": 525,
        "identifierTypeCodeDecode": "Entity",
        "identifierLatestIndicator": "Y",
        "identifierStartDate": "2022-09-06",
        "inModeCode": "I"
      }
    ]
  }
}

Any help in how to achieve this would be greatly appreciated. Ron.

JSLT needs better support for processing nested JSON structures. We'll work on ideas and possible designs later. For now, this issue exists to capture examples of use cases that we need to support.

• Simple two-level nesting: #267 and #268.

Feel free to suggest more use cases in the comments.

I want to retrieve the nested array "contacts" values. But when I tried with .contacts, I am not able to get the values of the contact array fields from the input json. Please help me on this. Below is the Input structure and the JSLT transformation being used:

+++++++++++++++++++++++++++input+++++++++++++++ [ { "a" :"12", "b" :"13", "contacts": [ { "Id": "1", "Contact_Id": "1234"

      },
      {
          "Id": "2",
          "Contact_Id": "877656554"
          
      },

{ "Id": "3", "Contact_Id": "333333"

      }
  ]      

}, {

"a" :"12", "b" :"13",
"Watercraft_AdditionalInterests": [ { "Id": "4", "Contact_Id": "77777" }, { "Id": "5", "Contact_Id": "888888"

      },
      {
          "Id": "6",
          "Contact_Id": "9999999"
          
      }
  ]      

} ]

++++++++++++++++JSLT+++++++++++

def range(length, list) if (size($list) < $length) range($length, $list + [size($list)]) else $list

def zip(arr1, arr2)[ for (range(size($arr1), []))[$arr1[.], $arr2[.]]]

{

"requests": flatten(zip([

for (.) {

"body": {
      "data": {
          "attributes": {
            "a" : .a,
            "b" : .b
          }
		} 

    }
   }

],

[ for(..contacts){

"body": { "data": { "attributes": { "contact": { "code": "contact" }, "contacts": { "id": ..Id, "contact id" : ..Contact_Id

                    }
                }
            }
        }
    }]

)) }