Import Azure AD Account's Employee ID

[JPMac]

Hi Team,

I need to retrieve my EmployeeID in Azure AD, but I have not been able to retrieve it by editing Connection.　The JSON is set as follows:

<ACCOUNT_ATTRIBUTES>

{
"acctLabels": {
"customproperty1": "FirstName",
"customproperty2": "LastName",
"customproperty3": "OfficePhone",
"customproperty4": "Email",
"customproperty5": "MobilePhone",
"customproperty6": "OfficeLocation",
"customproperty7": "PreferredLanguage",
"customproperty8": "UserType",
"customproperty9": "JobTitle",
"customproperty10": "AccountStatus",
"customproperty11": "OnPremisesSyncEnabled",
"customproperty12": "OnPremisesImmutableId",
"customproperty13": "HireDate",
"customproperty14": "OnPremisesLastSyncDateTime",
"customproperty15": "OnPremisesSecurityIdentifier",
"customproperty31": "STORE#ACC#ENT#MAPPINGINFO",
"customproperty16": "City",
"customproperty17": "Country",
"customproperty18": "Department",
"customproperty19": "UsageLocation",
"customproperty20": "ExternalUserState",
"customproperty21": "StreetAddress",
"customproperty22": "State",
"customproperty23": "Office",
"customproperty24": "PostalCode",
"customproperty25": "OfficePhone"
"customproperty26": "EmployeeID"
},
"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",
"customproperty31": "STORE#ACC#ENT#MAPPINGINFO~#~char",
"customproperty16": "city~#~char",
"customproperty17": "country~#~char",
"customproperty18": "department~#~char",
"customproperty19": "usageLocation~#~char",
"customproperty20": "externalUserState~#~char",
"customproperty21": "streetAddress~#~char",
"customproperty22": "state~#~char",
"customproperty23": "physicalDeliveryOfficeName~#~char",
"customproperty24": "postalCode~#~char",
"customproperty25": "telephoneNumber~#~char",
"customproperty26": "employeeId~#~char",
}
}

<ACCOUNT_IMPORT_FIELDS>

accountEnabled,city,country,department,onPremisesSyncEnabled,displayName,onPremisesLastSyncDateTime,mobilePhone,id,businessPhones,usagelocation,userPrincipalName,userType,givenName,surname,mail,officeLocation,preferredLanguage,onPremisesImmutableId,onPremisesSecurityIdentifier,externalUserState,streetAddress,state,physicalDeliveryOfficeName,postalCode,telephoneNumber,employeeId

Can someone give me some advice?

Regards,

[prashantChauhan]

Hi @JPMac 

There is a syntax error in your ACCOUNT_ATTRIBUTES json.

Please try the below JSON-

{
"acctLabels": {
"customproperty1": "FirstName",
"customproperty2": "LastName",
"customproperty3": "OfficePhone",
"customproperty4": "Email",
"customproperty5": "MobilePhone",
"customproperty6": "OfficeLocation",
"customproperty7": "PreferredLanguage",
"customproperty8": "UserType",
"customproperty9": "JobTitle",
"customproperty10": "AccountStatus",
"customproperty11": "OnPremisesSyncEnabled",
"customproperty12": "OnPremisesImmutableId",
"customproperty13": "HireDate",
"customproperty14": "OnPremisesLastSyncDateTime",
"customproperty15": "OnPremisesSecurityIdentifier",
"customproperty31": "STORE#ACC#ENT#MAPPINGINFO",
"customproperty16": "City",
"customproperty17": "Country",
"customproperty18": "Department",
"customproperty19": "UsageLocation",
"customproperty20": "ExternalUserState",
"customproperty21": "StreetAddress",
"customproperty22": "State",
"customproperty23": "Office",
"customproperty24": "PostalCode",
"customproperty25": "OfficePhone",
"customproperty26": "EmployeeID"
},
"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",
"customproperty31": "STORE#ACC#ENT#MAPPINGINFO~#~char",
"customproperty16": "city~#~char",
"customproperty17": "country~#~char",
"customproperty18": "department~#~char",
"customproperty19": "usageLocation~#~char",
"customproperty20": "externalUserState~#~char",
"customproperty21": "streetAddress~#~char",
"customproperty22": "state~#~char",
"customproperty23": "physicalDeliveryOfficeName~#~char",
"customproperty24": "postalCode~#~char",
"customproperty25": "telephoneNumber~#~char",
"customproperty26": "employeeId~#~char"
}
}

[JPMac]

Thanks for your advices. I can import accounts with employee ID.

[Manu269]

in acctLabels

"customproperty26": "EmployeeID"

 in colsToPropsMap

"customproperty26": "employeeId~#~char"

 Also, please validate the json before putting in connection.

I see synatx issue

[prashantChauhan]

Thanks, @JPMac for the confirmation. Can you please mark my comment as the solution so that this can be closed?