a!toJson excluding null values.

Certified Associate Developer

I have CDT with following fields

  • While using a!toJson , it is EXCLUDING fields which are having NULL values except fields with TEXT datatype.

Expresion: -  a!localVariables(
local!data: 'type!{urn:com:appian:types:RS}RS_dummyCDT'(id: 1, name: "abc"),
a!toJson(local!data)
)

Result:

 

Note: If I use parameter removeNullOrEmptyFields as true, it also excluding text fields which are null

a!localVariables(
local!data: 'type!{urn:com:appian:types:RS}RS_dummyCDT'(id: 1, name: "abc"),
a!toJson(
value: local!data,
removeNullOrEmptyFields: true
)
)

Result:

  • While using a!toJson_17r1, it is returning all the fields of the CDT irrespective of NULL values.

Expression: a!localVariables(
local!data: 'type!{urn:com:appian:types:RS}RS_dummyCDT'(id: 1, name: "abc"),
a!toJson_17r1(local!data )
)

Result:

I want to get the data the way we are getting result while using a!toJson_17r1. i.e. I want to get all the fields of CDT irrespective of NULL value.

Is there any way to achieve this using a!toJson?

  Discussion posts and replies are publicly visible

Parents Reply Children