Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

Finding strange issue with dateformat in rest connector

trivi
New Contributor III
New Contributor III

{"auditDetails":{"call1":[{"headers":null,"message":{"responseMessage":"An instance of type class java.sql.Date cannot be created from string ${user.termdate}. The string value must be in format YYYY-MM-DD."},"statusCode":400,"description":null,"status":"Failed"},{"headers":null,"message":{"responseMessage":"An instance of type class java.sql.Date cannot be created from string ${user.termdate.format('YYYY-MM-DD')}. The string value must be in format YYYY-MM-DD."},"statusCode":400,"description":null,"status":"Failed"},{"headers":null,"message":{"responseMessage":"An instance of type class java.sql.Date cannot be created from string ${user.termdate.format('yyyy-MM-dd')}. The string value must be in format YYYY-MM-DD."},"statusCode":400,"description":null,"status":"Failed"},{"headers":null,"message":{"responseMessage":"An instance of type class java.sql.Date cannot be created from string ${Date.parse('MMM dd, yyyy HH:mm:ss', user.termdate).format('yyyy-MM-dd')}. The string value must be in format YYYY-MM-DD."},"statusCode":400,"description":null,"status":"Failed"},{"headers":null,"message":{"responseMessage":"An instance of type class java.sql.Date cannot be created from string ${Calender.getInstance().setTime(user.termdate).add(Calendar.DATE, 30).format('yyyy-MM-dd')}. The string value must be in format YYYY-MM-DD."},"statusCode":400,"description":null,"status":"Failed"},{"headers":null,"message":{"responseMessage":"An instance of type class java.sql.Date cannot be created from string ${Calender.getInstance().setTime(user.termdate).add(Calendar.DATE, 30).time.format('yyyy-MM-dd')}. The string value must be in format YYYY-MM-DD."},"statusCode":400,"description":null,"status":"Failed"},{"headers":null,"message":{"responseMessage":"An instance of type class java.sql.Date cannot be created from string ${Calendar.getInstance().setTime(user.termdate).add(Calendar.DATE, 30).time.format('yyyy-MM-dd')}. The string value must be in format YYYY-MM-DD."},"statusCode":400,"description":null,"status":"Failed"},{"headers":null,"message":{"responseMessage":"An instance of type class java.sql.Date cannot be created from string ${new java.text.SimpleDateFormat('yyyy-MM-DD').parse(new java.text.SimpleDateFormat('MMM dd, yyyy HH:mm:ss').format(user.termdate)).getTime()}. The string value must be in format YYYY-MM-DD."},"statusCode":400,"description":null,"status":"Failed"},{"headers":null,"message":{"responseMessage":"An instance of type class java.sql.Date cannot be created from string ${user?.termdate.format('YYYY-MM-DD')}. The string value must be in format YYYY-MM-DD."},"statusCode":400,"description":null,"status":"Failed"},{"headers":null,"message":{"responseMessage":"An instance of type class java.sql.Date cannot be created from string ${new java.text.SimpleDateFormat('yyyy-MM-DD').parse(new java.text.SimpleDateFormat('MMM dd, yyyy HH:mm:ss').format(user.termdate))}. The string value must be in format YYYY-MM-DD."},"statusCode":400,"description":null,"status":"Failed"},{"headers":null,"message":{"responseMessage":"An instance of type class java.sql.Date cannot be created from string ${new java.text.SimpleDateFormat('yyyy-MM-dd').parse(new java.text.SimpleDateFormat('MMM dd, yyyy HH:mm:ss').format(user.termdate))}. The string value must be in format YYYY-MM-DD."},"statusCode":400,"description":null,"status":"Failed"},{"headers":null,"message":{"responseMessage":"An instance of type class java.sql.Date cannot be created from string ${new java.sql.Date((Calendar.getInstance().setTime(new java.text.SimpleDateFormat('MMM dd, yyyy HH:mm:ss').parse(user.termdate)).add(Calendar.DATE, 30).getTime()).getTime()).toString()}. The string value must be in format YYYY-MM-DD."},"statusCode":400,"description":null,"status":"Failed"}]},"call1":{"headers":null,"message":{"responseMessage":"An instance of type class java.sql.Date cannot be created from string ${new java.sql.Date((Calendar.getInstance().setTime(user.termdate).add(Calendar.DATE, 30).getTime()).getTime()).toString()}. The string value must be in format YYYY-MM-DD."},"statusCode":400,"description":null,"status":"Failed"}}

 

All the options tried in provisioning comments

1 REPLY 1

rushikeshvartak
All-Star
All-Star

${new java.text.SimpleDateFormat('yyyy-MM-dd').format(new java.text.SimpleDateFormat('MMM dd, yyyy HH:mm:ss').parse(user.termdate))}


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.