Azure Entra ID & Servicenow Query

[johnny1495]

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?

{

  "@odata.context": "https://graph.microsoft.com/beta/$metadata#servicePrincipals('c8d74505-b29a-4ab8-953d-508f9b1f0e47')...",

  "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.