We are using a Azure rest connection to get certain accounts and certain groups. the acctEntParams is throwing an error
2024-04-04T18:50:05-04:00-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-3-DEBUG-Got null response statusCode with erroMsg - [error:Error Illegal character in path at index 41: https://graph.microsoft.com/v1.0/groups/${id}/members/microsoft.graph.user?$count=true&$filter=endsW...
we are using the below for ImportAccountEntJSON json. it looks like entitlementid is not getting passed
{
"accountParams": {
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://graph.microsoft.com/beta/users?$count=true&$filter=endsWith(userPrincipalName,'CS@xxxx.com')...",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "value",
"keyField": "accountID",
"acctLabels": {
"customproperty1": "Given Name",
"customproperty2": "Surname",
"customproperty3": "BusinessPhones",
"customproperty4": "Mail",
"customproperty5": "mobilePhone",
"customproperty6": "OfficeLocation",
"customproperty7": "preferredLanguage",
"customproperty8": "User Type",
"customproperty9": "jobtitle",
"customproperty10": "AccountStatus",
"customproperty11": "onPremisesSyncEnabled",
"customproperty12": "onPremisesImmutableId",
"customproperty13": "hireDate",
"customproperty14": "onPremisesLastSyncDateTime",
"customproperty15": "onPremisesSecurityIdentifier",
"customproperty33": "manager",
"customproperty18": "signInActivity",
"customproperty19": "usageLocation",
"customproperty28": "employeeId",
"customproperty29": "createdDateTime",
"customproperty31": "ForceChangePasswordNextSignInWithMfa",
"customproperty32": "signInActivity",
"customproperty33":"mailNickname"
},
"colsToPropsMap": {
"accountID": "id~#~char",
"name": "userPrincipalName~#~char",
"displayName": "displayName~#~char",
"customproperty1": "givenName~#~char",
"customproperty2": "surname~#~char",
"customproperty3": "businessPhones~#~char",
"customproperty4": "mail~#~char",
"customproperty5": "mobilePhone~#~char",
"customproperty6": "officeLocation~#~char",
"customproperty7": "preferredLanguage~#~char",
"customproperty8": "userType~#~char",
"customproperty9": "jobtitle~#~char",
"customproperty10": "accountEnabled~#~char",
"customproperty11": "onPremisesSyncEnabled~#~char",
"customproperty12": "onPremisesImmutableId~#~char",
"customproperty13": "hireDate~#~char",
"customproperty14": "onPremisesLastSyncDateTime~#~char",
"customproperty15": "onPremisesSecurityIdentifier~#~char",
"customproperty33": "manager.userPrincipalName~#~char",
"customproperty28": "employeeId~#~char",
"customproperty19": "usageLocation~#~char",
"customproperty29": "createdDateTime~#~char",
"customproperty31": "ForceChangePasswordNextSignInWithMfa~#~char",
"customproperty32": "signInActivity.lastSignInDateTime~#~char",
"customproperty33": "mailNickname~#~char"
},
"pagination": {
"nextUrl": {
"nextUrlPath": "${(response?.completeResponseMap?.get('@odata.nextLink')==null)? null : response?.completeResponseMap?.get('@odata.nextLink').replace('%2c',',')}"
}
}
}
}
},
"entitlementParams": {
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"entTypes": {
"AADGroup": {
"call": {
"call1": {
"callOrder": 0,
"http": {
"httpHeaders": {
"Authorization": "${access_token}"
},
"url": "https://graph.microsoft.com/v1.0/groups?$filter=startswith(displayName,'xx-xx-x-xxx-xx-users')&$orde...",
"httpMethod": "GET",
"httpContentType": "application/json"
},
"listField": "value",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "id~#~char",
"entitlement_value": "displayName~#~char",
"description": "description~#~char",
"customproperty1": "deletedDateTime~#~char",
"customproperty2": "description~#~char",
"customproperty3": "membershipRule~#~char",
"customproperty5": "onPremisesSyncEnabled~#~char",
"customproperty6": "onPremisesLastSyncDateTime~#~char",
"customproperty7": "mail~#~char",
"customproperty8": "mailEnabled~#~char",
"customproperty9": "onPremisesSecurityIdentifier~#~char",
"customproperty10": "securityEnabled~#~char",
"customproperty11": "groupTypes~#~listAsString",
"customproperty13": "membershipRuleProcessingState~#~char",
"customproperty16": "resourceProvisioningOptions~#~char",
"customproperty17": "onPremisesSyncEnabled~#~char",
"customproperty18": "createdDateTime~#~char"
},
"makeProcessingStatus": false,
"disableDeletedEntitlements": true,
"pagination": {
"nextUrl": {
"nextUrlPath": "${(response?.completeResponseMap?.get('@odata.nextLink')==null)? null : response?.completeResponseMap?.get('@odata.nextLink')}"
}
}
}
}
}
}
},
"acctEntParams": {
"processingType": "httpEntToAcct",
"entTypes": {
"AADGroup": {
"call": {
"call1": {
"connection": "userAuth",
"callOrder": 0,
"stageNumber": 0,
"http": {
"httpHeaders": {
"Authorization": "${access_token}"
},
"url":"https://graph.microsoft.com/v1.0/groups/${id}/members/microsoft.graph.user?$count=true&$filter=endsW...",
"httpContentType": "application/x-www-form-urlencoded",
"httpMethod": "GET"
},
"listField": "value",
"entKeyField": "entitlementID",
"acctIdPath": "id",
"acctKeyField": "accountID",
"pagination": {
"nextUrl": {
"nextUrlPath": "${(response?.completeResponseMap?.get('@odata.nextLink')==null)? null : response?.completeResponseMap?.get('@odata.nextLink')}"
}
}
}
}
}
}
}
}
