and more in a single search tool across platforms. Read the announcement here. |
04/12/2023 10:09 PM
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"
}
}
}
}
}
}
Solved! Go to Solution.
04/12/2023 10:41 PM
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.