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

Dateformat in CreateAccountJSON

JPMac
Regular Contributor
Regular Contributor

In CreateAccountJSON, I set to:
"description": "${user.updatedate}"


This creates yyyy-mm-dd hh: mm: ss.0 as shown in the image below.

JPMac_0-1701916411843.png
Here we want to change it to yyyy/mm/dd.
<Example>
Now: 2023-12-07 01:57:13. 0
Expectation: 2023-12-07

How do I rewrite createaccountjson?
Here's what I tested with dataanalyzer:

JPMac_1-1701916574942.png
The whole createaccountjson is:

===

{
    "userPrincipalName":"${user.username+'@<damain>'}",
    "accountExpires": "0",
    "co": "${user.country}",
    "company": "${user.companyname}",
    "department": "${user.departmentname}",
    "displayname": "${user.displayname}",
    "employeeID": "${user.employeeid}",
    "employeetype": "${user.employeeType}",
    "givenName": "${user.firstname}",
    "l": "${user.city}",
    "mail": "${user.email}",
    "name": "${user.displayname}",
    "objectClass": [
        "top",
        "person",
        "organizationalPerson",
        "user"
    ],
    "physicaldeliveryofficename": "${user.location}",
    "pwdLastSet": "0",
    "sAMAccountName": "${task.accountName}",
    "sn": "${user.lastname}",
    "st": "${user.state}",
    "streetAddress": "${user.street}",
    "telephoneNumber": "${user.phonenumber}",
    "mobile": "${user.secondaryPhone}",
    "title": "${user.jobDescription}",
    "manager": "${managerAccount==null?'':managerAccount.accountID}",
    "userAccountControl": "544",
    "description": "${user.updatedate}"
}

===

 

 

 

 

 

1 REPLY 1

rushikeshvartak
All-Star
All-Star

${user.updatedate.format('yyyy-MM-dd HH:mm:ss.S')}

 

Refer : https://forums.saviynt.com/t5/community-knowledge-base/new-date-function-not-working-in-json/ta-p/20... 

https://forums.saviynt.com/t5/identity-governance/ad-connector-set-account-expires-and-logon-denied-... 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.