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

Rest API - Account to Entitlement mapping - ServiceNow Groups

JEllis
New Contributor III
New Contributor III

I am able to pull in Accounts and Entitlements with no issues. 
I need to map Accounts to Entitlements. The call that I am using provides all of the Entitlement to Account information in a list. There is no need to make calls for each entitlement as they are all listed out in the call I am using. 
Looking though the Developers handbook, I do not see this as an example and I am unable to get the association to work. 

What am I missing?

Response for acctEntParams call attached


Full ImportAccountEntJSON:

{
"accountParams": {
"connection": "SNOWAuth",
"processingType": "SequentialAndIterative",
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://xxxxxxxx.service-now.com/api/now/table/sys_user",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "result",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "sys_id~#~char",
"name": "user_name~#~char",
"displayName": "name~#~char",
"customProperty1": "first_name~#~char",
"customProperty2": "last_name~#~char",
"customProperty3": "active~#~char",
"customProperty2": "email~#~char"
}}}
},
"entitlementParams": {
"connection": "SNOWAuth",
"processingType": "SequentialAndIterative",
"entTypes": {
"Group": {
"entTypeOrder": 0,
"call": {
"ENTcall1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://xxxxxx.service-now.com/api/now/table/sys_user_group",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "text/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "result",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "sys_id~#~char",
"entitlement_value": "name~#~char",
"customproperty1": "description~#~char"
}
}
}
}
}
},
"acctEntParams": {
"connection": "SNOWAuth",
"entTypes": {
"Group": {
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"processingType": "httpEntToAcct",
"http": {
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "text/json"
},
"url": "https://xxxxxxx.service-now.com/api/now/table/sys_user_grmember",
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "result",
"acctIdPath": "user.value",
"entIdPath": "group.value"
}
}
}
}

}
}

 

1 REPLY 1

sudeshjaiswal
Saviynt Employee
Saviynt Employee

Hello @JEllis ,

Could you kindly inform us, why the value of customProperty2 has been duplicated? Could you also provide the correct CustomProperty for "email~#~char" to avoid conflicts?
I have attached a sample JSON, You may find it helpful.

Thanks.

If you find the above response useful, Kindly Mark it as "Accept As Solution".