Click HERE to see how Saviynt Intelligence is transforming the industry. |
08/22/2023 03:59 AM
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
08/22/2023 05:08 AM
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
08/22/2023 06:16 AM - last edited on 08/22/2023 07:00 AM by Sunil
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]
08/23/2023 02:13 AM
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