Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

what value should be enter in listField

navneetv
Regular Contributor II
Regular Contributor II

Hi 

Since Saviynt is new for me. I started learning and I have lots of doubts and questions. this is one of them, can someone help me here to understand, what value should be mentioned in "listField". As there is no path of account objects while running a GET API call from Postman,

Here is below Response result 

[
{
"name": "xyz1@",
"status": "CONFIRMED",
"lastUpdated": "2021-05-07T23:49:55.596Z",
"created": "2021-05-07T23:45:57.708Z",
"memberOf": [
"Admin"
]
},
{
"name": "abc@",
"status": "FORCE_CHANGE_PASSWORD",
"lastUpdated": "2022-08-12T09:06:23.444Z",
"created": "2022-08-12T09:06:23.444Z",
"memberOf": [
"Admin"
]
},
{
"name": "zyx@",
"status": "FORCE_CHANGE_PASSWORD",
"lastUpdated": "2022-09-30T13:19:34.157Z",
"created": "2022-09-30T13:19:34.157Z",
"memberOf": [
"Admin"
]
},

Here is Account Import JSON, which we are using to import the data but not getting user details

{
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"accountThresholdValue": 300,
"inactivateAccountsNotInFile": false,
"correlateInactiveAccounts": true,
"statusColumn": "customproperty2",
"activeStatus": [
"true"
]
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "URL",
"httpParams": {},
"httpContentType": "application/json",
"httpMethod": "GET",
"httpHeaders": {
"x-api-key": "${access_token}",
"Accept": "application/json",
"Content-Type": "application/json"
}
},
"listField": "",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "email~#~char",
"name": "email~#~char",
"status": "status~#~char",
"customproperty1": "email~#~char",
"customproperty2": "status~#~char"
}
}
}
},
"entitlementParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"entTypes": {
"Roles": {
"entTypeOrder": 0,
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "<URL>",
"httpHeaders": {
"x-api-key": "${access_token}",
"Accept": "application/json",
"Content-Type": "application/json"
},
"httpParams": {},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "name~#~char",
"entitlement_value": "name~#~char",
"customproperty1": "name_at~#~char",
"customproperty3": "description~#~char"
},
"makeProcessingStatus": false,
"disableDeletedEntitlements": "true"
}
}
}
}
}
}
6 REPLIES 6

nimitdave
Saviynt Employee
Saviynt Employee

rushikeshvartak
All-Star
All-Star

listfield will be blank


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

navneetv
Regular Contributor II
Regular Contributor II

Hi Rishik, 

thankyou for confirming, it working by making it blank. I have one more question related to entitlement mapping. i am able to extract the account and Entitlement, however,Entitlement is not mapped with the account 

could you please confirm, how I can map the entitlement with an account? here is Postman's response. Also if you can let me know what is "idPath": in Role Call?

[
{
"name""xyz1@",
"status""CONFIRMED",
"lastUpdated""2021-05-07T23:49:55.596Z",
"created""2021-05-07T23:45:57.708Z",
"memberOf": [
"Admin"
]
},
{
"name""abc@",
"status""FORCE_CHANGE_PASSWORD",
"lastUpdated""2022-08-12T09:06:23.444Z",
"created""2022-08-12T09:06:23.444Z",
"memberOf": [
"Admin"
]
},
{
"name""zyx@",
"status""FORCE_CHANGE_PASSWORD",
"lastUpdated""2022-09-30T13:19:34.157Z",
"created""2022-09-30T13:19:34.157Z",
"memberOf": [
"Admin"
]
},

 

Here is AccountImportJSON 

{
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"inactivateAccountsNotInFile": false,
"accountThresholdValue": 20
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "<endpoint_url>config/authorization/users",
"httpHeaders": {
"x-api-key": "<API_key>",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpParams": {},
"httpMethod": "GET"
},
"listField": "",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "email~#~char",
"name": "email~#~char",
"status": "status~#~char",
"customproperty1": "email~#~char",
"customproperty2": "status~#~char",
"customproperty3": "memberOf~#~char",
"customproperty31": "STORE#ACC#ENT#MAPPINGINFO~#~char"
}
}
},
"acctEntMappings": {
"Role": {
"listPath": "",
"idPath": "role",
"keyField": "entitlementID"
}
}
},
"entitlementParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"entTypes": {
"Role": {
"entTypeOrder": 0,
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "<endpoint_url>config/authorization/roles",
"httpHeaders": {
"x-api-key": "<api_key>",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpParams": {},
"httpMethod": "GET"
},
"listField": "",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "name~#~char",
"entitlement_value": "name~#~char",
"customproperty1": "name~#~char",
"customproperty2": "description~#~char"
},
"makeProcessingStatus": false,
"disableDeletedEntitlements": "true"
}
}
}
}
},
"acctEntParams": {
"entTypes": {
"Role": {
"call": {
"call1": {
"processingType": "acctToEntMapping"
}
}
}
}
}
}

navneetv
Regular Contributor II
Regular Contributor II

HI Everyone ,

can someone advise? if I am doing wrong while importing accounts and access. i am getting an error in the job however all users' accounts have been extracted. Also please advise how to map the entitlement with the account. Here is accountImportJSON 

Postman response 

[
{
"name""xyz1@",
"status""CONFIRMED",
"lastUpdated""2021-05-07T23:49:55.596Z",
"created""2021-05-07T23:45:57.708Z",
"memberOf": [
"Admin"
]
},
{
"name""abc@",
"status""FORCE_CHANGE_PASSWORD",
"lastUpdated""2022-08-12T09:06:23.444Z",
"created""2022-08-12T09:06:23.444Z",
"memberOf": [
"Admin"
]
},
{
"name""zyx@",
"status""FORCE_CHANGE_PASSWORD",
"lastUpdated""2022-09-30T13:19:34.157Z",
"created""2022-09-30T13:19:34.157Z",
"memberOf": [
"Admin"
]
},

 

Here is AccountImportJSON 

{
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"inactivateAccountsNotInFile": false,
"accountThresholdValue": 20
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "<endpoint_url>config/authorization/users",
"httpHeaders": {
"x-api-key": "<API_key>",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpParams": {},
"httpMethod": "GET"
},
"listField": "",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "email~#~char",
"name": "email~#~char",
"status": "status~#~char",
"customproperty1": "email~#~char",
"customproperty2": "status~#~char",
"customproperty3": "memberOf~#~char",
"customproperty31": "STORE#ACC#ENT#MAPPINGINFO~#~char"
}
}
},
"acctEntMappings": {
"Role": {
"listPath": "",
"idPath": "role",
"keyField": "entitlementID"
}
}
},
"entitlementParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"entTypes": {
"Role": {
"entTypeOrder": 0,
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "<endpoint_url>config/authorization/roles",
"httpHeaders": {
"x-api-key": "<api_key>",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpParams": {},
"httpMethod": "GET"
},
"listField": "",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "name~#~char",
"entitlement_value": "name~#~char",
"customproperty1": "name~#~char",
"customproperty2": "description~#~char"
},
"makeProcessingStatus": false,
"disableDeletedEntitlements": "true"
}
}
}
}
},
"acctEntParams": {
"entTypes": {
"Role": {
"call": {
"call1": {
"processingType": "acctToEntMapping"
}
}
}
}
}
}

 

Error message 

navneetv_0-1685973730054.png

 

navneetv
Regular Contributor II
Regular Contributor II

Hi Everyone,

could you please advise, what thing needs to be changed in the Account import JSON so that account can be mapped with entitlement? I am able to extract the account and entitlement however the account is not mapped with the entitlement ( above is account IMPORT JSON and also postman response from end system

nimitdave
Saviynt Employee
Saviynt Employee

Try with below:

"acctEntMappings": {
"Role": {
"listPath": "memberOf",
"idPath": "",
"keyField": "entitlementID"
}
}