We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Sav4sav Rest based connector

sandeepverma
Regular Contributor
Regular Contributor

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"
    }
  }
}

5 REPLIES 5

sk
All-Star
All-Star

You can try to include createdate column in your userquery and define a logic to figure out new users


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

sandeepverma
Regular Contributor
Regular Contributor

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

Refer https://forums.saviynt.com/t5/general-discussions/calculate-dates-dynamically-in-url-rest/m-p/2925#M...

${(new Date()).format('yyyy-MM-dd')


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

You can use like this user.createdate>=sysdate()


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

sandeepverma
Regular Contributor
Regular Contributor

Thank you, Rushikesh.

I'll check with your reply.

Thanks