We're mapping SharePoint Group entitlements to accounts, and it works fine when we use a hardcoded value in the URL of "SharePoint Group" entitlementtype in acctEntParams.
"url": "https://company.sharepoint.com/sites/testsite/_api/Web/SiteGroups/GetById(${id})/Users"
In entitlementParams we are using inputParams to use other entitlementtype "SharePoint Site Collection" to build the Sharepoint Group url(${entitlementID}/_api/web/sitegroups) and same we need to use in acctEntParams.
How can we achieve this.
ImportAccountEntJSON
{
"accountParams": {
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://graph.microsoft.com/v1.0/users?$filter=mail+ne+null+and+(endsWith(mail%2c%27%40company.com%27)+OR+endsWith(mail%2c%27%40company.ie%27))&ConsistencyLevel=eventual&$count=true ",
"httpHeaders": {
"Authorization": "${access_token}"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "value",
"keyField": "name",
"colsToPropsMap": {
"accountID": "id~#~char",
"name": "mail~#~char",
"status": "accountEnabled~#~char",
"displayName": "displayName~#~char",
"customproperty1": "givenName~#~char",
"customproperty2": "surname~#~char",
"customproperty3": "businessPhones~#~char",
"customproperty4": "city~#~char",
"customproperty5": "country~#~char",
"customproperty6": "department~#~char",
"customproperty7": "onPremisesSyncEnabled~#~char",
"customproperty8": "onPremisesLastSyncDateTime~#~char",
"customproperty9": "mobilePhone~#~char",
"customproperty10": "accountEnabled~#~char",
"customproperty11": "usageLocation~#~char",
"customproperty12": "userPrincipalName~#~char",
"customproperty13": "userType~#~char",
"customproperty14": "assignedLicenses~#~char"
},
"pagination": {
"nextUrl": {
"nextUrlPath": "${(response?.completeResponseMap?.get('@odata.nextLink')==null)? null : response?.completeResponseMap?.get('@odata.nextLink')}"
}
}
}
}
},
"entitlementParams": {
"processingType": "SequentialAndIterative",
"entTypes": {
"SharePoint Site Collection": {
"entTypeOrder": 2,
"call": {
"call1": {
"connection": "userAuth",
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://graph.microsoft.com/v1.0/sites?search=%22%2ftest%20site%20test%2f%22",
"httpHeaders": {
"Authorization": "${access_token}"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "value",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "webUrl~#~char",
"entitlement_value": "webUrl~#~char",
"customproperty1": "id~#~char",
"customproperty2": "name~#~char"
},
"pagination": {
"nextUrl": {
"nextUrlPath": "${(response?.completeResponseMap?.get('@odata.nextLink')==null)? null : response?.completeResponseMap?.get('@odata.nextLink')}"
}
}
}
}
},
"SharePoint Group": {
"entTypeOrder": 4,
"call": {
"call1": {
"connection": "SPAuth",
"callOrder": 1,
"stageNumber": 3,
"http": {
"url": "${entitlementID}/_api/web/sitegroups",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json;odata=verbose"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"inputParams": {
"entitlementname": "SharePoint Site Collection"
},
"listField": "d.results",
"nextApiKeyField": "entitlementID",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "Id~#~char",
"entitlement_value": "#CONST#${String site = response.'__metadata'.'uri';String name = response.'LoginName'; result = name +' | '+ site.substring(0, site.indexOf('/_api/Web/SiteGroups')); return result}~#~char",
"displayName": "Title~#~char",
"description": "Description~#~char",
"customproperty1": "PrincipalType~#~char"
}
}
}
}
}
},
"acctEntParams": {
"processingType": "httpEntToAcct",
"entTypes": {
"SharePoint Group": {
"call": {
"call1": {
"connection": "SPAuth",
"callOrder": 0,
"stageNumber": 0,
"http": {
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json;odata=verbose"
},
"url": "${entitlementID}/_api/Web/SiteGroups/GetById(${id})/Users", //how can we get ${entitlementID} from SharePoint Site Collection entitlementtype.
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "d.results",
"entKeyField": "entitlementID",
"acctIdPath": "Email",
"acctKeyField": "name"
}
}
}
}
}
}
