Forum Discussion
johnny1495
Nov 16, 2023Copper Contributor
Azure Entra ID & Servicenow Query
Hi Team,
I have done the integration between Azure Entra ID and ServiceNow in my personal instance. This is for pushing all the user & group data from Azure to SN, the issue however is with reference fields in ServiceNow. I'm trying to find a way to push the Department, location, cost center details to the ServiceNow's respective base tables.
The user details from Azure goes into the ServiceNow sys_user table, which has department, location fields. But if the department which is pushed from Azure is not available in the department base table (cmn_department) of servicenow, then ServiceNow (SN) fails to update that field in the sys_user table.
Is there a way in Azure to populate other tables apart from sys_user table?
In researching I got this schema editor from attribute mapping, can we include the reference table details in this?
{
"id": "ServiceNowOutDelta.8c025656593a4ea49020015cb859a383.5837e491-47c9-4b29-83c2-3ca88dea3ee7",
"version": "Date:2023-11-15T05:43:41.1944015Z, ActivityId:ae247ddb-2e81-4ecc-b0fc-b7552137e09d",
"synchronizationRules": [
{
"containerFilter": null,
"editable": true,
"groupFilter": null,
"id": "cb0576d6-13e6-4491-8cb1-cc237314b164",
"name": "USER_OUTBOUND_USER",
"priority": 1,
"sourceDirectoryName": "Azure Active Directory",
"targetDirectoryName": "ServiceNow",
"metadata": [
{
"key": "defaultSourceObjectMappings",
"value": "[{\"AttributeMappings\":[{\"DefaultValue\":null,\"ExportMissingReferences\":false,\"FlowBehavior\":0,\"FlowType\":0,\"MatchingPriority\":1,\"Source\":null,\"TargetAttributeName\":\"displayName\"},{\"DefaultValue\":\"False\",\"ExportMissingReferences\":false,\"FlowBehavior\":0,\"FlowType\":0,\"MatchingPriority\":0,\"Source\":null,\"TargetAttributeName\":\"mailEnabled\"},{\"DefaultValue\":\"True\",\"ExportMissingReferences\":false,\"FlowBehavior\":0,\"FlowType\":0,\"MatchingPriority\":0,\"Source\":null,\"TargetAttributeName\":\"securityEnabled\"},{\"DefaultValue\":\"False\",\"ExportMissingReferences\":false,\"FlowBehavior\":0,\"FlowType\":0,\"MatchingPriority\":0,\"Source\":null,\"TargetAttributeName\":\"IsSoftDeleted\"}],\"DisableMonitoringForChanges\":false,\"Disposition\":0,\"Enabled\":false,\"EscrowBehavior\":1,\"FlowTypes\":7,\"Internal\":false,\"IsCustomerDefined\":false,\"Name\":null,\"OriginalJoiningProperty\":\"displayName\",\"Scope\":null,\"SourceObjectName\":\"\",\"Synchronized\":false,\"TargetObjectName\":\"Group\",\"Unsynchronized\":false},{\"AttributeMappings\":[{\"DefaultValue\":\"False\",\"ExportMissingReferences\":false,\"FlowBehavior\":0,\"FlowType\":0,\"MatchingPriority\":0,\"Source\":null,\"TargetAttributeName\":\"IsSoftDeleted\"},{\"DefaultValue\":\"True\",\"ExportMissingReferences\":false,\"FlowBehavior\":0,\"FlowType\":0,\"MatchingPriority\":0,\"Source\":null,\"TargetAttributeName\":\"accountEnabled\"},{\"DefaultValue\":\"en-US\",\"ExportMissingReferences\":false,\"FlowBehavior\":0,\"FlowType\":0,\"MatchingPriority\":0,\"Source\":null,\"TargetAttributeName\":\"preferredLanguage\"},{\"DefaultValue\":null,\"ExportMissingReferences\":false,\"FlowBehavior\":0,\"FlowType\":0,\"MatchingPriority\":1,\"Source\":null,\"TargetAttributeName\":\"userPrincipalName\"}],\"DisableMonitoringForChanges\":false,\"Disposition\":0,\"Enabled\":false,\"EscrowBehavior\":1,\"FlowTypes\":7,\"Internal\":false,\"IsCustomerDefined\":false,\"Name\":null,\"OriginalJoiningProperty\":\"userPrincipalName\",\"Scope\":null,\"SourceObjectName\":\"\",\"Synchronized\":false,\"TargetObjectName\":\"User\",\"Unsynchronized\":false},{\"AttributeMappings\":[{\"DefaultValue\":null,\"ExportMissingReferences\":false,\"FlowBehavior\":0,\"FlowType\":0,\"MatchingPriority\":1,\"Source\":null,\"TargetAttributeName\":\"appId\"}],\"DisableMonitoringForChanges\":false,\"Disposition\":0,\"Enabled\":false,\"EscrowBehavior\":1,\"FlowTypes\":7,\"Internal\":false,\"IsCustomerDefined\":false,\"Name\":null,\"OriginalJoiningProperty\":\"appId\",\"Scope\":null,\"SourceObjectName\":\"\",\"Synchronized\":false,\"TargetObjectName\":\"Application\",\"Unsynchronized\":false},{\"AttributeMappings\":[{\"DefaultValue\":\"User\",\"ExportMissingReferences\":false,\"FlowBehavior\":0,\"FlowType\":0,\"MatchingPriority\":0,\"Source\":null,\"TargetAttributeName\":\"allowedMemberTypes\"},{\"DefaultValue\":\".\",\"ExportMissingReferences\":false,\"FlowBehavior\":0,\"FlowType\":0,\"MatchingPriority\":0,\"Source\":null,\"TargetAttributeName\":\"description\"},{\"DefaultValue\":null,\"ExportMissingReferences\":false,\"FlowBehavior\":0,\"FlowType\":0,\"MatchingPriority\":1,\"Source\":null,\"TargetAttributeName\":\"displayName\"},{\"DefaultValue\":\"True\",\"ExportMissingReferences\":false,\"FlowBehavior\":0,\"FlowType\":0,\"MatchingPriority\":0,\"Source\":null,\"TargetAttributeName\":\"isEnabled\"}],\"DisableMonitoringForChanges\":false,\"Disposition\":0,\"Enabled\":false,\"EscrowBehavior\":1,\"FlowTypes\":7,\"Internal\":false,\"IsCustomerDefined\":false,\"Name\":null,\"OriginalJoiningProperty\":\"displayName\",\"Scope\":null,\"SourceObjectName\":\"\",\"Synchronized\":false,\"TargetObjectName\":\"AppRole\",\"Unsynchronized\":false},{\"AttributeMappings\":[{\"DefaultValue\":null,\"ExportMissingReferences\":false,\"FlowBehavior\":0,\"FlowType\":0,\"MatchingPriority\":1,\"Source\":null,\"TargetAttributeName\":\"id\"}],\"DisableMonitoringForChanges\":false,\"Disposition\":0,\"Enabled\":false,\"EscrowBehavior\":1,\"FlowTypes\":7,\"Internal\":false,\"IsCustomerDefined\":false,\"Name\":null,\"OriginalJoiningProperty\":\"id\",\"Scope\":null,\"SourceObjectName\":\"\",\"Synchronized\":false,\"TargetObjectName\":\"AppRoleAssignment\",\"Unsynchronized\":false},{\"AttributeMappings\":[{\"DefaultValue\":null,\"ExportMissingReferences\":false,\"FlowBehavior\":0,\"FlowType\":0,\"MatchingPriority\":1,\"Source\":null,\"TargetAttributeName\":\"displayName\"}],\"DisableMonitoringForChanges\":false,\"Disposition\":0,\"Enabled\":false,\"EscrowBehavior\":1,\"FlowTypes\":7,\"Internal\":false,\"IsCustomerDefined\":false,\"Name\":null,\"OriginalJoiningProperty\":\"displayName\",\"Scope\":null,\"SourceObjectName\":\"\",\"Synchronized\":false,\"TargetObjectName\":\"ServicePrincipal\",\"Unsynchronized\":false}]"
},
{
"key": "supportsProvisionOnDemand",
"value": "true"
}
],
"objectMappings": [
{
"enabled": true,
"flowTypes": "Add,Update",
"name": "Provision Azure Active Directory Users",
"scope": null,
"sourceObjectName": "User",
"targetObjectName": "sys_user",
"attributeMappings": [
{
"defaultValue": "1",
"exportMissingReferences": false,
"flowBehavior": "FlowWhenChanged",
"flowType": "Always",
"matchingPriority": 0,
"targetAttributeName": "active",
"source": {
"expression": "Switch([IsSoftDeleted], , \"False\", \"1\", \"True\", \"0\")",
"name": "Switch",
"type": "Function",
"parameters": [
{
"key": "source",
"value": {
"expression": "[IsSoftDeleted]",
"name": "IsSoftDeleted",
"type": "Attribute",
"parameters": []
}
},
{
"key": "switchValue",
"value": {
"expression": "\"False\"",
"name": "False",
"type": "Constant",
"parameters": []
}
},
{
"key": "switchValue",
"value": {
***************
its a huge file but I hope you guys get the point.
No RepliesBe the first to reply