Proper datetime format for setting enddate and termdate in Sav via API?

[jralexander137]

Hi, I am trying to use update user api call to set end date and term date for a given user. When passing 

{

"username":"TestUser1",

"statuskey":"1",

"enddate":"2023-11-29T00:00:00Z"

}

I get a datetime value populated as Jul 10, 0197. I have tried every variation I can think of formatting wise but am unable to get it to parse properly. The format in the payload does not work at all when passing to termdate.

API response is

{

    "errorCode": "0",

    "message": "SUCCESS User Updated Successfully"

}

when setting enddate and termdate even though termdate doesnt even get updated. I havent been able to find this clarification in any docs yet. Any insight would be greatly appreciated!

tried using the format here: https://docs.saviyntcloud.com/bundle/TPAG-Guide-v23x/page/Content/Offboard-Users-using-Request-API.h... but still fails

Field error in object 'com.saviynt.ecm.identitywarehouse.domain.Users' on field 'enddate': rejected value [10-11-2019]; codes [com.saviynt.ecm.identitywarehouse.domain.Users.enddate.typeMismatch.error,com.saviynt.ecm.identitywarehouse.domain.Users.enddate.typeMismatch,users.enddate.typeMismatch.error,users.enddate.typeMismatch,typeMismatch.com.saviynt.ecm.identitywarehouse.domain.Users.enddate,typeMismatch.enddate,typeMismatch.java.util.Date,typeMismatch]; arguments [End Date]; default message [Unparseable date: "10-11-2019"]

[pmahalle]

Hi @jralexander137 ,

Can you try below date format and check once:

{
"username":"TestUser1",
"statuskey":"1",
"enddate":"08-13-2017"
}

It's working for us.

[jralexander137]

Tried that and got the same error I got for other formats:

ield error in object 'com.saviynt.ecm.identitywarehouse.domain.Users' on field 'enddate': rejected value [08-13-2017]; codes [com.saviynt.ecm.identitywarehouse.domain.Users.enddate.typeMismatch.error,com.saviynt.ecm.identitywarehouse.domain.Users.enddate.typeMismatch,users.enddate.typeMismatch.error,users.enddate.typeMismatch,typeMismatch.com.saviynt.ecm.identitywarehouse.domain.Users.enddate,typeMismatch.enddate,typeMismatch.java.util.Date,typeMismatch]; arguments [End Date]; default message [Unparseable date: "08-13-2017"]

Payload sent: 

{

"username":"TestUser1",

"statuskey":"1",

"enddate":"08-13-2017"

}

[rushikeshvartak]

try future date its working in v23.6

[jralexander137]

Tried future date, still getting same error. 

[pmahalle]

Hi @jralexander137 ,

What's date format you have set in Global Configuration --> Preferences? Can you set it to MM-DD-YYYY and try with below payload.

{

"username":"TestUser1",

"statuskey":"1",

"enddate":"08-13-2017"

}

[rushikeshvartak]

Under Global configuration - Preference Set date format

Date Format

Select the format for dates to be displayed