date format in JSON

[Rajatlm10]

Hi, 

i am currently using the GETDATE() to get. its giving me in format. (
2024-06-12 12:24:06.157)

I need to get the date in format  " 2035-12-11T19:28:00Z "

the error i am getting is.

Has anyone worked on same scenario before? 

[rushikeshvartak]

Which connector?

[Rajatlm10]

@rushikeshvartak 

REST

[rushikeshvartak]

Please confirm full use case. Is this import or provisioning json

[Rajatlm10]

@rushikeshvartak 

this is removeAccount JSON. we need to send date in " 2035-12-11T19:28:00Z " format in TermindationDate attribute. 

[rushikeshvartak]

${Date.parse("yyyy-MM-dd'T'HH:mm:ss'Z'", user.customproperty1)}

[Rajatlm10]

will it store the value in CP1 and then i need to use CP1 in terminationDate: "user.cp1" ?

Can you please help me with the explanation of this/

[rushikeshvartak]

Change format / cp as per your needs

[Rajatlm10]

Error in processWebservicecom.fasterxml.jackson.core.JsonParseException: Unexpected character ('G' (code 71)): was expecting comma to separate Object entries at [Source: {schemas":["urn:ietf:params:scim:api:messages:2.0:PatchOp"]

[rushikeshvartak]

Getdate() is mysql method and it will not work.

where is date is stored ? User attributes or you want to use todays date

[Rajatlm10]

ok, 

I want to pass the current date basically. 

Its not stored anywhere. 

[rushikeshvartak]

${Date.parse("yyyy-MM-dd'T'HH:mm:ss'Z'", new Date())}