01/16/2023 10:19 PM
Hi Expert,
We are using sav4sav rest based connection where we are using ImpotUserJson as per below. But it's importing all existing "External Contractor" from the users table, but we are looking to extract only newly created users in system. Could you suggest what filter we should use to make it more specific?
ImportUserJson:
{
"connection": "userAuth",
"url": "https://********.saviyntcloud.com/ECM/api/v5/getUser",
"httpMethod": "POST",
"httpHeaders": {
"Authorization": "${access_token}",
"contentType": "application/json"
},
"httpParams": "{\"userQuery\":\"employeeclass like 'External Contractor' \"}",
"httpContentType": "application/json",
"colsToPropsMap": {
"username": "username~#~char",
"locationdesc": "locationdesc~#~char",
"street": "street~#~char",
"city": "city~#~char",
"state": "state~#~char",
"country": "country~#~char"
},
"userResponsePath": "userdetails",
"pagination": {
"offset": {
"offsetParam": "offset",
"batchParam": "max",
"batchSize": 10000,
"totalCountPath": "completeResponseMap.total"
}
}
}
Solved! Go to Solution.
01/17/2023 10:17 AM
You can try to include createdate column in your userquery and define a logic to figure out new users
01/17/2023 08:39 PM
Hi SK,
Thanks for your reply.
I used "user.createdate >= '2023-01-17'" along with user query and it worked. But I want to use current system date in place of hard code date.
Thanks
01/17/2023 08:45 PM
${(new Date()).format('yyyy-MM-dd')
01/18/2023 06:51 AM
You can use like this user.createdate>=sysdate()
01/17/2023 08:49 PM
Thank you, Rushikesh.
I'll check with your reply.
Thanks