{"id":23804,"date":"2026-01-13T16:10:44","date_gmt":"2026-01-13T16:10:44","guid":{"rendered":"https:\/\/suresms.com\/?page_id=23804"},"modified":"2026-01-14T06:35:34","modified_gmt":"2026-01-14T06:35:34","slug":"integration-entra-id-via-csv","status":"publish","type":"page","link":"https:\/\/suresms.com\/en\/integrationer\/booking-ldap-2fa\/integration-entra-id-via-csv\/","title":{"rendered":"SMS integration to Entra ID (via CSV file)"},"content":{"rendered":"\r\n\t\t\t
\r\n\r\n\t\t\t\t\r\n\t\t\t\t
\r\n\r\n\t\t\t\t\t\r\n\t\t\t\t\t
    \r\n\t\t\t\t\t\t
  1. \r\n \r\n \r\n \r\n \r\n <\/i>Home <\/a>\r\n <\/span>\r\n \r\n <\/li>
  2. \/<\/span><\/li>
  3. SMS integration for Entra...<\/span><\/li>\t\t\t\t\t<\/ol>\r\n\t\t\t\t\t
    <\/div>\r\n\t\t\t\t<\/div>\r\n\t\t\t<\/div>\r\n\t\t\t\n\t\t

    SMS integration Entra ID via CSV file<\/h1>\t\n\t\t\t\t\"Azure\n

    \n\t\t\tWhat is Entra ID also known as Active Directory?\t<\/h2>\n\t

    Microsoft Entra ID, formerly known as Azure Active Directory (Azure AD), is a cloud-based identity and access management service from Microsoft. This service helps organizations manage and secure user access to applications and data across a modern hybrid IT infrastructure. By using Microsoft Entra ID, organizations can offer single sign-on (SSO) and multi-factor authentication to protect user identities and improve security. The integration with Microsoft Entra ID and your Active Directory (AD) makes it possible to synchronize and manage identities centrally, simplifying user management and access control. This is essential for organizations that want efficient and secure access management.<\/p>\n\t\t

    Pay attention to ....<\/h2>

    There are a few things you should be aware of before you start creating an SMS AD integration with SureSMS.<\/p>\n

    GDPR<\/h4>\n

    The first thing you need to be aware of is that SureSMS gets access to personal data from you. This means that we are now starting to process data for you and thus we must, incomply with GDPR<\/a>, have a data processing agreement.<\/p>\n

    Phone numbers<\/h4>\n

    The phone numbers we need to send to must be in your AD. In order for us to send SMS to a person, we need to know their phone number. Therefore, if you don't have phone numbers in your AD, either get it or don't do an integration.<\/p>\n

    Deleting contacts<\/h4>\n

    The integration is a \u201cone-way\u201d integration. This means that we only read from information from AD. The integration takes all people from your AD, so to speak. So, for example, if you delete a person in SureSMS, they will only come back if they are still in AD. It's always AD that has the correct data.<\/p>\n

    \n\t\t\tHow to set up your Entra ID integration\t<\/h2>\n\t

    We have several options when it comes to EntraID integration. This article describes how the integration is done via a CSV file.<\/p>\n

    In general, the solution is based on a small script that runs on your premises (i.e. within the security mechanisms your company has established). The script creates a comma-separated file with content about people, phone numbers and groups, and this file is sent securely via sFTP to SureSMS. SureSMS then automatically loads the file into the account associated with the integrations.<\/p>\n

    So, let's get started.<\/p>\n

    \n\t\t\tHow it works\t<\/h2>\nThe process is built around a PowerShell script that performs the following tasks:\n\n1.Securely connects to Microsoft Entra ID using the Microsoft Graph API.\n2. retrieves members from one or more specified user groups.\n3. extracts relevant data (Name, Country code, Phone number) and the name of the group they belong to.\n4. formats data in a CSV file compatible with the SureSMS platform.\n5. automatically uploads the CSV file to the SureSMS sFTP server (sftp.suresms.com).\n
    \nOnce the file is uploaded, it is automatically imported to the contacts of your address book in SureSMS.\n

    \n\t\t\tCSV file format\t<\/h2>\nThe script generates a CSV file with a semicolon as separator, which is standard in Denmark. The file contains the following columns:\n\n\n\n\n\n\n\n
    \nColumn\n<\/td>\n\nDescription\n<\/td>\n\nExample of an example\n<\/td>\n<\/tr>\n
    \nName\n<\/td>\n\nUser's full name from Entra ID\n<\/td>\n\nAnders Jensen\n<\/td>\n<\/tr>\n
    \nCountry code\n<\/td>\nDialing code with + prefix<\/td>\n\n+45\n<\/td>\n<\/tr>\n
    \nPhone number\n<\/td>\n\nMobile number or work phone\n<\/td>\n\n12345678\n<\/td>\n<\/tr>\n
    \nGroup of products\n<\/td>\n\nThe name of the Entra ID group the user belongs to\n<\/td>\n\nIT department\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\nAn example of the file content could look like this:\nPlain Text\n\u201cAnders Jensen\u201d;\u201d+45\u2033;\u201d12345678\u2033;\u201dIT Department\u201d\n\u201cMaria Nielsen\u201d;\u201d+45\u2033;\u201d87654321\u2033;\u201dIT Department\u201d\n\u201cPeter Hansen\u201d;\u201d+45\u2033;\u201d11223344\u2033;\u201dSalg\u201d\n\u201cJohan Svensson\u201d;\u201d+46\u2033;\u201d701234567\u2033;\u201dSalg\u201d\n\nNote that the script automatically converts ISO country codes (e.g. DK, SE, NO) to the correct dialing format (+45, +46, +47) and removes any country code prefixes from the phone numbers.\n

    \n\t\t\tPrerequisites\t<\/h2>\n

    Before you can use the script, make sure your system meets the following requirements:<\/p>\n