Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

CreateAccount-Data Format (ISO 8601 format)

PuspanjaliM
New Contributor II
New Contributor II

Hi Team,

We are storing start date at user.customproperty7

I'm trying to pass the customproperty7  but receiving below.

Screenshot 2023-11-02 213132.png

This is the JSON, I'm using.

"httpParams": "{\"jobAssignmentId\":\"${user.employeeid}\",\"jobAssignmentName\": \"${user.customproperty31}\",\"startDate\": \"user.customproperty7.toISOString()\",\"endDate\": \"${user.enddate==null? '': user.enddate}\",

 

2 REPLIES 2

Ishan
Saviynt Employee
Saviynt Employee

What is the format of the date stored in customproperty7 column? The format should be YYYY-MM-DDThh:mm:ssTZD

Please check what value is being passed for startdate in the JSON in your logs. 

Ishan Kamat
Technical Architect, Professional Services
SaviyntLogo.png

PuspanjaliM
New Contributor II
New Contributor II

Hi Ishan,

We are storing the value in customerproperty7 = 20/03/2017

PuspanjaliM_2-1699004880163.png

 

from the logs, there is no much details

Screenshot 2023-11-03 151353.png

 

These are the queries I tried prior.

${new java.text.SimpleDateFormat('yyyy-MM-dd').format(user.customproperty7)}

new java.text.SimpleDateFormat('yyyy-MM-DD').parse(new java.text.SimpleDateFormat('yyyy-MM-DD HH:mm:ss').format(user.customproperty7)).getTime()