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.
