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

Azure rest connection giving error [error:Error Illegal character in path at index 41

venkat
New Contributor III
New Contributor III

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')}"
}
}
}
}
}
}
}
}

4 REPLIES 4

rushikeshvartak
All-Star
All-Star

Please share logs


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

attached logs

Raghu
Valued Contributor III
Valued Contributor III

in first call using in URL direct entId, can replace below and try it

URL :

https://graph.microsoft.com/v1.0/groups/${entitlementID}/members/microsoft.graph.user?$count=true&$filter=endsWith(userPrincipalName,'CS@xxxxxx.com')&ConsistencyLevel=eventual]"

above try replace value and check it    : ${entitlementValue.entitlementID}

[This post has been edited by a Moderator to remove sensitive information.]


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

venkat
New Contributor III
New Contributor III

same error message 

2024-04-05T12:58:23-04:00-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-5-DEBUG-Got null response statusCode with erroMsg - [error:Error Illegal character in path at index 41: https://graph.microsoft.com/v1.0/groups/${entitlementValue.entitlementID}/members/microsoft.graph.us...]
2024-04-05T12:58:23-04:00-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-5-DEBUG-Error while getting acctEntParams response for entType- AADGroup, url- https://graph.microsoft.com/v1.0/groups/${entitlementValue.entitlementID}/members/microsoft.graph.us... is: null
20