restconnector: how to pass date in request

[saurabhpad]

Hi,

We have requirement where we want pass date to API in yyyy-MM-ss HH:mm:ss format. when we are sending date hardcoded we are getting success response. same date we have stored in cp37 we are getting 400 response. below are some solution we have tried.

\"departure_date_time\":\"${new java.text.SimpleDateFormat('yyyy-MM-dd hh:mm:ss').format(user.customproperty37.toString())}\"

,\"departure_date_time\":\"${new java.text.SimpleDateFormat('yyyy-MM-dd hh:mm:ss').parse(user.customproperty37.toString())}\"

,\"departure_date_time\":\"${new java.text.SimpleDateFormat('yyyy-MM-dd hh:mm:ss').format(user.customproperty37)}\"

\"departure_date_time\":\"${new SimpleDateFormat('yyyy-MM-dd hh:mm:ss').format(user.customproperty37)}\"

${Date.parse(\"yyyy-MM-dd hh:mm:ss\", user.customproperty37)}

,\"departure_date_time\":\"${user.customproperty37}\"

\"departure_date_time\":\"${user.customproperty37.toString()}\"

kindly let us know if anything is missing

[smitg]

Hi @saurabhpad ,

Try using
Calendar.getInstance(); today.setTime(user.customproperty37);today.getTime().format(\"yyyy-MM-dd'T'HH:mm:ss.SSS'Z'\")
Ref : https://forums.saviynt.com/t5/identity-governance/need-help-to-set-time-in-mulesoft-target/m-p/36429

New keyword is not supported in Saviynt EIC. 
Ref : https://forums.saviynt.com/t5/community-knowledge-base/new-date-function-not-working-in-json/ta-p/20...

Thanks,
Smitha

[saurabhpad]

These are two solution we have tried and still facing below error

\"${Calendar today=Calendar.getInstance();today.setTime(user.customproperty37);today.getTime().format(\"yyyy-MM-dd'T'HH:mm:ss\")}\",
\"Calendar.getInstance(); today.setTime(user.customproperty37);today.getTime().format(\"yyyy-MM-dd'T'HH:mm:ss.SSS'Z'\")\"

{"auditDetails":{"call1":[{"message":"Unexpected character ('y' (code 121)): was expecting comma to separate Object entries\n at [Source: {\"variables\" :{\"catalogid\":\"1f5888f287187d505a2f53973cbb35d8\",\"iehp_id\":\"${user.username}\",\"departure_date_time\":\"${Calendar today=Calendar.getInstance();today.setTime(user.customproperty37);today.getTime().format(\"yyyy-MM-dd'T'HH:mm:ss\")}\",\"employee_type\":\"${user.employeetype}\",\"saviynt_task_id\":\"${task.taskid}\",\"departure_type\":\"${if(user.enddate==null){'Immediate'}else{'Scheduled'}}\"} }; line: 1, column: 217]","status":"Failed"}]},"call1":{"message":"Unexpected character ('y' (code 121)): was expecting comma to separate Object entries\n at [Source: {\"variables\" :{\"catalogid\":\"1f5888f287187d505a2f53973cbb35d8\",\"iehp_id\":\"${user.username}\",\"departure_date_time\":\"${Calendar.getInstance(); today.setTime(user.customproperty37);today.getTime().format(\"yyyy-MM-dd HH:mm:ss\")}\",\"employee_type\":\"${user.employeetype}\",\"saviynt_task_id\":\"${task.taskid}\",\"departure_type\":\"${if(user.enddate==null){'Immediate'}else{'Scheduled'}}\"} }; line: 1, column: 203]","status":"Failed"}}

at [Source: {\"variables\" :{\"catalogid\":\"1f5888f287187d505a2f53973cbb35d8\",\"iehp_id\":\"${user.username}\",\"departure_date_time\":\"${Calendar today=Calendar.getInstance();today.setTime(user.customproperty37);today.getTime().format(\"yyyy-MM-dd'T'HH:mm:ss\")}\",\"employee_type\":\"${user.employeetype}\",\"saviynt_task_id\":\"${task.taskid}\",\"departure_type\":\"${if(user.enddate==null){'Immediate'}else{'Scheduled'}}\"} }; line: 1, column: 217]","status":"Failed"},{"message":"Unexpected character ('y' (code 121)): was expecting comma to separate Object entries\n at [Source: {\"variables\" :{\"catalogid\":\"1f5888f287187d505a2f53973cbb35d8\",\"iehp_id\":\"${user.username}\",\"departure_date_time\":\"${Calendar.getInstance(); today.setTime(user.customproperty37);today.getTime().format(\"yyyy-MM-dd HH:mm:ss\")}\",\"employee_type\":\"${user.employeetype}\",\"saviynt_task_id\":\"${task.taskid}\",\"departure_type\":\"${if(user.enddate==null){'Immediate'}else{'Scheduled'}}\"} }; line: 1, column: 203]","status":"Failed"}]},"call1":{"message":"Unexpected character ('y' (code 121)): was expecting comma to separate Object entries\n at [Source: {\"variables\" :{\"catalogid\":\"1f5888f287187d505a2f53973cbb35d8\",\"iehp_id\":\"${user.username}\",\"departure_date_time\":\"${Calendar.getInstance(); today.setTime(user.customproperty37);today.getTime().format(\"yyyy-MM-dd'T'HH:mm:ss.SSS'Z'\")}\",\"employee_type\":\"${user.employeetype}\",\"saviynt_task_id\":\"${task.taskid}\",\"departure_type\":\"${if(user.enddate==null){'Immediate'}else{'Scheduled'}}\"} }; line: 1, column: 203]","status":"Failed"}}

We have value is cp37 :- 2023-08-16 10:45:00

below is JSON we have in disable account:-

{
"call": [
{
"name": "call1",
"connection": "userAuth",
"url": "https://url.com/api/mpinl/iehp_service_request_integration/iehpoffboarding",
"httpMethod": "POST",
"httpParams": "{\"variables\" :{\"catalogid\":\"1f5888f287187d505a2f53973cbb35d8\",\"iehp_id\":\"${user.username}\",\"departure_date_time\":\"${Calendar.getInstance(); today.setTime(user.customproperty37);today.getTime().format(\"yyyy-MM-dd'T'HH:mm:ss.SSS'Z'\")}\",\"employee_type\":\"${user.employeetype}\",\"saviynt_task_id\":\"${task.taskid}\",\"departure_type\":\"${if(user.enddate==null){'Immediate'}else{'Scheduled'}}\"} }",
"httpHeaders": {
"Authorization": "${access_token}"
},
"httpContentType": "application/json",
"ticketidPath": "result.message",
"successResponses": {
"statusCode": [
200
]
}
}
]
}

[This message has been edited by moderator to mask url]

[saurabhpad]

We have saved date in cp37 as 2023-08-16 10:45:00. We are trying to pass this cp37 in request but facing below error.

{"call1":{"headers":{"Transfer-Encoding":"chunked","Server":"snow_adc","Server-Timing":"sem_wait;dur=0, sesh_wait;dur=0","X-Transaction-ID":"00eb67f987b8","Connection":"keep-alive","X-Is-Logged-In":"true","Pragma":"no-store,no-cache","Date":"Tue, 22 Aug 2023 18:43:32 GMT","Strict-Transport-Security":"max-age=63072000; includeSubDomains","Cache-Control":"no-cache,no-store,must-revalidate,max-age=-1","Expires":"0","Content-Type":"application/json;charset=UTF-8"},"message":{"result":{"status":400,"message":"Departure date time is not valid"}},"statusCode":200,"description":null,"status":"Success"}}

we have tried below JSON:

\"departure_date_time\":\"${user.customproperty37}\"
\"departure_date_time\":\"${user.customproperty37.toString()}\"

is there any other way to pass this date or cp value