Markus Marbach (MARBM)
Principal System Architect
Pegasystems Inc.
MARBM Member since 2003 7 posts
Posted: May 7, 2021
Last activity: May 7, 2021
Posted: 7 May 2021 0:59 EDT
Last activity: 7 May 2021 1:36 EDT

JSON ISO Date not converted to Pega Date in JSON Data Transform

We have a JSON payload we receiving via a REST Service. We dump the entire payload to a clipboard property and then use a JSON Data Transform to deserialize the JSON to the Clipboard in the Service Activity.

The JSON ISO date is in format "YYYY-MM-DD"

The receiving Pega property is of Date format "YYYYMMDD"

My expectation would be that the JSON Data Transform converts the ISO format to the Pega internal date format. However, after executing the Data Transform the Pega date property contains a value of "YYYY-MM-DD" which is invalid and I'm surprised this doesn't generate an exception. When serializing the date format using a JSON Data Transform the date behaviour can be selected in the Settings tab. I'm not sure why this doesn't work for deserializing ISO dates.

Has anyone experienced the same behaviout and if so how did you resolve it?

Some screenshots to illustrate this issue:

JSON payload (abbreviated):


JSON Data Transform (see postingDate):

JSON Data Transform for deserialization

Clipboard after deserialization (see value in postingDate property):

Clipboard after deserialization

Property rule:

Date Property

Property Advanced tab:

Property Advanced tab.

Pega Platform Data Integration Java and Activities Government Lead System Architect