Genesys Cloud - Developer Community!

Hello all,

I face a problem using $esc.jsonDecode(). I am trying to get a field that is filled with JSON in string form and transform it to JSON object, in order to get some specific fields from it. To be more specific, I save the JSON in string form in the field $.entities[X].customFields.example_field and I retrieve it in translation map to a variable. Then, in successTemplate I try to transform it to JSON to save it to a variable that is declared as object in Contracts. Example response configuration:

The jsonDecode as I understand only remove escape characters of a string.

I don't think you can return an object, you can return it as a string, and then parse it into JSON in for example Architect if that's where you're using it.

For objects with nested arrays I often just return the rawResult as a string and then JSON.parse that in Architect.

Hello all,

I face a problem using $esc.jsonDecode(). I am trying to get a field that is filled with JSON in string form and transform it to JSON object, in order to get some specific fields from it. To be more specific, I save the JSON in string form in the field $.entities[X].customFields.example_field and I retrieve it in translation map to a variable. Then, in successTemplate I try to transform it to JSON to save it to a variable that is declared as object in Contracts. Example response configuration:

According to this article: https://help.mypurecloud.com/articles/velocity-macros-data-actions/ 

esc.jsonDecode

When you have a JSON encoded string and want to have JSON form of it, you can use the esc.jsonDecode() macro. This macro unescapes quotes and other characters based on JSON encoding rules.

Template example

$esc.jsonDecode(${input.escapedjson})

Decoding example

I see your approach, however the data action in going to be used in script, so the output cannot be manipulated as in Architect.

The jsonDecode as I understand only remove escape characters of a string.

I don't think you can return an object, you can return it as a string, and then parse it into JSON in for example Architect if that's where you're using it.

For objects with nested arrays I often just return the rawResult as a string and then JSON.parse that in Architect.

Hello all,

I face a problem using $esc.jsonDecode(). I am trying to get a field that is filled with JSON in string form and transform it to JSON object, in order to get some specific fields from it. To be more specific, I save the JSON in string form in the field $.entities[X].customFields.example_field and I retrieve it in translation map to a variable. Then, in successTemplate I try to transform it to JSON to save it to a variable that is declared as object in Contracts. Example response configuration:

So what will you do with the object in Script?

There's no JSON type variable so it might not matter if the object is returned as a string.

According to this article: https://help.mypurecloud.com/articles/velocity-macros-data-actions/ 

esc.jsonDecode

When you have a JSON encoded string and want to have JSON form of it, you can use the esc.jsonDecode() macro. This macro unescapes quotes and other characters based on JSON encoding rules.

Template example

$esc.jsonDecode(${input.escapedjson})

Decoding example

I see your approach, however the data action in going to be used in script, so the output cannot be manipulated as in Architect.

The jsonDecode as I understand only remove escape characters of a string.

I don't think you can return an object, you can return it as a string, and then parse it into JSON in for example Architect if that's where you're using it.

For objects with nested arrays I often just return the rawResult as a string and then JSON.parse that in Architect.

Hello all,

I face a problem using $esc.jsonDecode(). I am trying to get a field that is filled with JSON in string form and transform it to JSON object, in order to get some specific fields from it. To be more specific, I save the JSON in string form in the field $.entities[X].customFields.example_field and I retrieve it in translation map to a variable. Then, in successTemplate I try to transform it to JSON to save it to a variable that is declared as object in Contracts. Example response configuration:

I need to save the transformed string to JSON to an object variable declared in Contracts and then save the values of the fields of the output to string variables in the script.

Let's say i have this string: "{\"id\":\"XXXX\",\"kunnr\":\"1111111\",\"cid\":\"111YYY\",\"groupId\":\"001\"}".

I need to transform it into JSON through the response config:

{

     "id":"XXXX",

     "kunnr":"1111111",

      "cid":"111YYY",

      "groupId":"001"

}

Which is going to be saved in an object variable named contactInfo.

In this way, I can retrieve every field to the script in this way: kunnr = contactInfo.kunnr etc.

So what will you do with the object in Script?

There's no JSON type variable so it might not matter if the object is returned as a string.

According to this article: https://help.mypurecloud.com/articles/velocity-macros-data-actions/ 

esc.jsonDecode

When you have a JSON encoded string and want to have JSON form of it, you can use the esc.jsonDecode() macro. This macro unescapes quotes and other characters based on JSON encoding rules.

Template example

$esc.jsonDecode(${input.escapedjson})

Decoding example

I see your approach, however the data action in going to be used in script, so the output cannot be manipulated as in Architect.

The jsonDecode as I understand only remove escape characters of a string.

I don't think you can return an object, you can return it as a string, and then parse it into JSON in for example Architect if that's where you're using it.

For objects with nested arrays I often just return the rawResult as a string and then JSON.parse that in Architect.

Hello all,

I face a problem using $esc.jsonDecode(). I am trying to get a field that is filled with JSON in string form and transform it to JSON object, in order to get some specific fields from it. To be more specific, I save the JSON in string form in the field $.entities[X].customFields.example_field and I retrieve it in translation map to a variable. Then, in successTemplate I try to transform it to JSON to save it to a variable that is declared as object in Contracts. Example response configuration:

Is the issue that you are ending up with an extra set of quotes around the JSON object?  If so, you should be able to remove the first and last character from $contactInfo, so something like 

$contactInfo.substring(1, $contactInfo.length() -1)

I need to save the transformed string to JSON to an object variable declared in Contracts and then save the values of the fields of the output to string variables in the script.

Let's say i have this string: "{\"id\":\"XXXX\",\"kunnr\":\"1111111\",\"cid\":\"111YYY\",\"groupId\":\"001\"}".

I need to transform it into JSON through the response config:

{

     "id":"XXXX",

     "kunnr":"1111111",

      "cid":"111YYY",

      "groupId":"001"

}

Which is going to be saved in an object variable named contactInfo.

In this way, I can retrieve every field to the script in this way: kunnr = contactInfo.kunnr etc.

So what will you do with the object in Script?

There's no JSON type variable so it might not matter if the object is returned as a string.

According to this article: https://help.mypurecloud.com/articles/velocity-macros-data-actions/ 

esc.jsonDecode

When you have a JSON encoded string and want to have JSON form of it, you can use the esc.jsonDecode() macro. This macro unescapes quotes and other characters based on JSON encoding rules.

Template example

$esc.jsonDecode(${input.escapedjson})

Decoding example

I see your approach, however the data action in going to be used in script, so the output cannot be manipulated as in Architect.

The jsonDecode as I understand only remove escape characters of a string.

I don't think you can return an object, you can return it as a string, and then parse it into JSON in for example Architect if that's where you're using it.

For objects with nested arrays I often just return the rawResult as a string and then JSON.parse that in Architect.

Hello all,

I face a problem using $esc.jsonDecode(). I am trying to get a field that is filled with JSON in string form and transform it to JSON object, in order to get some specific fields from it. To be more specific, I save the JSON in string form in the field $.entities[X].customFields.example_field and I retrieve it in translation map to a variable. Then, in successTemplate I try to transform it to JSON to save it to a variable that is declared as object in Contracts. Example response configuration:

Hello Jason,

It seems that there is no substring or similar function to use in the response configuration.

The issue is the additional backslashes that are inserted during the resolve translation map and make the $esc.jsonDecode() inva;id.

Is the issue that you are ending up with an extra set of quotes around the JSON object?  If so, you should be able to remove the first and last character from $contactInfo, so something like 

$contactInfo.substring(1, $contactInfo.length() -1)

I need to save the transformed string to JSON to an object variable declared in Contracts and then save the values of the fields of the output to string variables in the script.

Let's say i have this string: "{\"id\":\"XXXX\",\"kunnr\":\"1111111\",\"cid\":\"111YYY\",\"groupId\":\"001\"}".

I need to transform it into JSON through the response config:

{

     "id":"XXXX",

     "kunnr":"1111111",

      "cid":"111YYY",

      "groupId":"001"

}

Which is going to be saved in an object variable named contactInfo.

In this way, I can retrieve every field to the script in this way: kunnr = contactInfo.kunnr etc.

So what will you do with the object in Script?

There's no JSON type variable so it might not matter if the object is returned as a string.

According to this article: https://help.mypurecloud.com/articles/velocity-macros-data-actions/ 

esc.jsonDecode

When you have a JSON encoded string and want to have JSON form of it, you can use the esc.jsonDecode() macro. This macro unescapes quotes and other characters based on JSON encoding rules.

Template example

$esc.jsonDecode(${input.escapedjson})

Decoding example

I see your approach, however the data action in going to be used in script, so the output cannot be manipulated as in Architect.

The jsonDecode as I understand only remove escape characters of a string.

I don't think you can return an object, you can return it as a string, and then parse it into JSON in for example Architect if that's where you're using it.

For objects with nested arrays I often just return the rawResult as a string and then JSON.parse that in Architect.

Hello all,

I face a problem using $esc.jsonDecode(). I am trying to get a field that is filled with JSON in string form and transform it to JSON object, in order to get some specific fields from it. To be more specific, I save the JSON in string form in the field $.entities[X].customFields.example_field and I retrieve it in translation map to a variable. Then, in successTemplate I try to transform it to JSON to save it to a variable that is declared as object in Contracts. Example response configuration: