How to get users username prepopulate using user's email address when we use userimport JSON

[srinath]

We are PeopleHR as source for users creation on Saviynt, from PeopleHR they can only pass manager's email but we would like to populate manager username to manager field. Can we prepopulate these values any example or reference link

[rushikeshvartak]

Which connector is used ?

use preprocessor query

[srinath]

Hi @arushi2403 

We are using REST connector. 

Is it possible in import user Json

Do there any example how we can achieve it as i find in sv documentation where we can run preprocessor in import user JSON

[rushikeshvartak]

Share current JSON

[srinath]

Hi @rushikeshvartak ,

Here is the sample JSON, for manager field we want to pull manager users name

{
"connection": "peopleHRTestAuth",
"successResponses": {
"statusCode": [
200,
201,
202,
203,
204,
205
]
},
"url": "xxxxx",
"httpMethod": "GET",

"httpParams": {
"APIKey": "xxxxxxx",
"Action": "GetQueryResultByQueryName",
"QueryName": "xxxxx"
},
"userResponsePath": "Result",
"colsToPropsMap": {
"username": "Employee Id~#~char",
"firstname": "First Name~#~char",
"lastname": "Last Name~#~char"
"manager": ??
"customproperty6": "manager email"
}
}

[rushikeshvartak]

Does your api return manager username 

[srinath]

No, it just send the manager email as below

"Result": [

        {

            "Employee Id": "xxxx",

            "First Name": "xxx",

            "Last Name": "xxxx",

            "Other Name": "xxxx",

            "Work Email": "xxxxx@abc.com",

            "Company": "xxx",

            "Location": "xxxx",

            "Employment Type": "xxxx",

            "Job Role": "xxx",

            "Job Role Change Date": "xxx",

            "Start Date": "xxxxx",

            "Continuous Service Date": null,

            "Manager Email": "xxxx@abc.com",

            "Additional Manager": null,

            "Employee Status": "Active",

            "Employee Created Date": "xxxx",

            "Probation End Date": "xxxx",

            "Fixed Term End Date": null,

            "Work Phone Number": "xxxx",

            "Final Day of Employment": null,

            "Final Day in Office": null,

            "Leaver Marked Date": null

        },

[rushikeshvartak]

You will need unique attributes of manager if its available then use preprocessor to populate manager for user

[Manu269]

@srinath postman screenshot to fetch above details please.

[srinath]

Hi @Manu269 

I shared response already.

Moreover i have other question as well can saviynt will allow date format DD/MM/yyyy when creating user in saviynt - this is other question.

[rushikeshvartak]

Use const variable to populate 

[srinath]

Hi @rushikeshvartak ,

can you help with more information, as i am not sure on Preprocessor.

[rushikeshvartak]

Refer https://forums.saviynt.com/t5/community-knowledge-base/attribute-precedence-for-user-imports/ta-p/10...