Data Format Issue while updating the account

[bhuvanesh]

Hi Saviynt Team,

Could you please suggest, what json format should i use to pass the date format to end system via the disablement JSON. We want to update enddate or current date with below format.

end system accept this date format : 2024-01-20T00:00:00.00Z

i tried with all way but its giving an error that date format is not correct.

we tried below data format

A. ${user.enddate..format('yyyyMMddHHmmss')'Z',TimeZone.getTimeZone('Etc/UTC')}",

B. ${Calendar.getInstance().getTime().format('yyyyMMddHHmmss')}Z

C. ${user.enddate.format('yyyy-MM-dd'T'HH:mm:ss'Z'')}
D. ${user.enddate}

here is json request body

"httpParams": "{\"schemas\":[\"urn:ietf:params:scim:api:messages:2.0:PatchOp\"],\"Operations\":[{\"op\":\"add\",\"path\":\"urn:ietf:params:scim:schemas:extension:enterprise:2.0:User:terminationDate\",\"value\":\"${user.enddate.format('yyyy-MM-dd'T'HH:mm:ss'Z'')}\"}]}"

ERROR MESSAGE

"message": "Date-time string must have the format YYYY-MM-DD'T'hh:mm:ss'Z'"

Thanks

[adarshk]

What is the target system here?

[bhuvanesh]

SAP Concur V4 API Version

[Vedanth-BK]

Hi @bhuvanesh 

Please try with the below 

{\"schemas\":[\"urn:ietf:params:scim:api:messages:2.0:PatchOp\"],\"Operations\":[{\"op\":\"add\",\"path\":\"urn:ietf:params:scim:schemas:extension:enterprise:2.0:User:terminationDate\",\"value\":\"${user.enddate.format('yyyy-MM-ddTHH:mm:ssZ')}\"}]}

Thank you 

Vedanth

[bhuvanesh]

Hello @Vedanth-BK @adarshk 

We tried but still getting same error message.

{"call1":{"headers":null,"message":{"status":400,"schemas":["urn:ietf:params:scim:api:messages:2.0:Error","urn:ietf:params:scim:api:messages:concur:2.0:Error"],"urn:ietf:params:scim:api:messages:concur:2.0:Error":{"messages":[{"code":"BAD_INPUT","type":"error","schemaPath":"/urn:ietf:params:scim:schemas:extension:enterprise:2.0:User/terminationDate","message":"Date-time string must have the format YYYY-MM-DD'T'hh:mm:ss'Z'"}]},"scimType":"invalidSyntax","detail":"Invalid schema","meta":null},"statusCode":400,"description":null,"status":"Failed"}}

Thanks

[Manu269]

@bhuvanesh can you try this :

yyyy-MM-dd'T'HH:mm:ss.ssZ

[bhuvanesh]

Hello @Manu269 

Still Getting Same error message

{"call1":{"headers":null,"message":{"status":400,"schemas":["urn:ietf:params:scim:api:messages:2.0:Error","urn:ietf:params:scim:api:messages:concur:2.0:Error"],"urn:ietf:params:scim:api:messages:concur:2.0:Error":{"messages":[{"code":"BAD_INPUT","type":"error","schemaPath":"/urn:ietf:params:scim:schemas:extension:enterprise:2.0:User/terminationDate","message":"Date-time string must have the format YYYY-MM-DD'T'hh:mm:ss'Z'"}]},"scimType":"invalidSyntax","detail":"Invalid schema","meta":null},"statusCode":400,"description":null,"status":"Failed"}}

Here is the Response body

"httpParams": "{\"schemas\":[\"urn:ietf:params:scim:api:messages:2.0:PatchOp\"],\"Operations\":[{\"op\":\"replace\",\"path\":\"active\",\"value\":false},{\"op\":\"add\",\"path\":\"urn:ietf:params:scim:schemas:extension:enterprise:2.0:User:terminationDate\",\"value\":\"${user.enddate.format('yyyy-MM-dd'T'HH:mm:ss.ssZ')}\"},{\"op\":\"remove\",\"path\":\"entitlements\",\"values\":[\"Travel\"]}]}"
 

Thanks

[rushikeshvartak]

{
"schemas": ["urn:ietf:params:scim:api:messages:2.0:PatchOp"],
"Operations": [
{
"op": "replace",
"path": "active",
"value": false
},
{
"op": "add",
"path": "urn:ietf:params:scim:schemas:extension:enterprise:2.0:User:terminationDate",
"value": "${user.enddate.format('yyyy-MM-dd'T'HH:mm:ss.SSZ')}"
},
{
"op": "remove",
"path": "entitlements",
"values": ["Travel"]
}
]
}

[bhuvanesh]

Hello @rushikeshvartak 

Still same error

Thanks

[navneetv · Accepted solution]

Hi @bhuvanesh  try with below 

\"${Calendar.getInstance().getTime().format(\"yyyy-MM-dd'T'HH:mm:ss'Z'\")}\"

[bhuvanesh]

Hi @navneetv 

it works, Thank you for working on it.