Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners Click HERE | EMEA/APJ Click HERE |
08/02/2023 08:27 AM
We are trying to change from importing using the Azure AD OOTB connector to REST connector so that we can import the signInActivity for the accounts. We have some AAD groups with emojis in the display name, so I tried to use data type emchar to strip out the emojis but after making that change, I am receiving this error message:
Field 'ENTITLEMENT_VALUE' doesn't have a default value
Here is the entitlementParams section of our ImportAccountEntJSON:
"entitlementParams": {
"processingType": "SequentialAndIterative",
"entTypes": {
"AADGroup": {
"entTypeOrder": 0,
"call": {
"call1": {
"callOrder": 0,
"connection": "userAuth",
"listField": "value",
"keyField": "entitlementID",
"http": {
"url": "https://graph.microsoft.com/v1.0/groups?$filter=onPremisesSyncEnabled+eq+null&$count=true",
"httpMethod": "GET",
"httpContentType": "application/json",
"httpHeaders": {
"Authorization": "${access_token}",
"ConsistencyLevel": "eventual"
}
},
"colsToPropsMap": {
"entitlementID": "id~#~char",
"entitlement_value": "displayName~#~emchar",
"displayname": "displayName~#~emchar",
"description": "description~#~emchar",
"acctEntMappingInfoColumnFromEnt": "STORE#ACC#ENT#MAPPINGINFO~#~char",
"customproperty1": "deletionTimestamp~#~char",
"customproperty7": "mail~#~char",
"customproperty8": "mailEnabled~#~char",
"customproperty9": "onPremisesSecurityIdentifier~#~char",
"customproperty10": "securityEnabled~#~char",
"customproperty11": "groupTypes~#~char",
"customproperty13": "membershipRuleProcessingState~#~char",
"customproperty14": "ownerId~#~char",
"customproperty18": "creationDate~#~char"
},
"pagination": {
"nextUrl": {
"nextUrlPath": "${(response?.completeResponseMap?.get('@odata.nextLink')==null)? null : response?.completeResponseMap?.get('@odata.nextLink')}"
Does anyone know what this 'doesn't have a default value' error mean? Thanks.
08/02/2023 08:41 AM
Hi @adecastro1 ,
The emchar datatype seems to be limited only to the OOTB Azure AD connector.
Search Results (saviyntcloud.com)
Better to raise an enhancement request idea for the same. (https://ideas.saviynt.com/ideas/)
Thanks,
Armaan
08/07/2023 02:16 AM
Hi @adecastro1
Please try URL encoding the special characters in the JSON URL.
example:
+ needs to be replaced with %2B
space with %20
Attaching an online URL encoding reference Link.
Thank you
Vedanth B.K