Authentication Application Credentials

Instructions

Follow these simple steps below to create Microsoft Entra ID application with application access permissions. Using following steps, you can grant very granular app permissions to access Full site(s), List(s), List Item(s) and File(s). Choose permission based on your need.

Create OAuth app

1. Navigate to the Azure Portal and log in using your credentials.
2. Access Microsoft Entra ID.
3. Register a new application by going to App registrations and clicking on New registration button:
   INFO: Find more information on how to register an application in Graph API reference.
4. When configuration window opens, configure these fields:
   • Supported account type
     • e.g. select Accounts in this organizational directory only if you need access to data in your organization only.
   • Redirect URI:
     • Set the type to Public client/native (mobile & desktop).
     • Leave the URL field empty.
   
5. After registering the app, copy the Application (client) ID for later:
6. Then copy OAuth authorization endpoint (v2) & OAuth token endpoint (v2) URLs:
7. Continue and create Client secret:
8. Then copy the Client secret for later steps:
9. Continue by adding permissions for the app by going to the API permissions section, and clicking on Add a permission:
10. Select Microsoft Graph:
11. Then choose Application permissions option:
12. Continue by adding these Files (OneDrive) permissions (Just search for "Site" and then select desired permissions):
13. Move on by addding these Sites (SharePoint) permissions (You can search for "Site" and then select desired permissions):
14. Finish by clicking Add permissions button:
15. Now it's time to Grant admin consent for your application:
16. Confirm all the permissions are granted:
17. Now go to SSIS package or ODBC data source and use the copied values in Application Credentials authentication configuration:
    • In the Token URL field paste the OAuth token endpoint (v2) URL value you copied in the previous step.
    • In the Client ID field paste the Application (client) ID value you copied in the previous step.
    • In the Client Secret field paste the Client secret value you copied in the previous step.
    • Optional step. Choose Default Site Id from the drop down menu.
18. Click Test Connection to confirm the connection is working.
19. Done! Let's move on to the next step.

Step-2 (Method#1 - New Approach): Grant permission to app using permission API (UI is not available yet)

In year 2024 microsoft launched

*.Selected

1. Open PowerShell (Run as Admin user)
2. Install Graph API module by running this command

   Import-Module Microsoft.Graph.Sites

3. Now you can call following PowerShell code to set "read" and "write" permission for the app we created earlier (assuming app id is 89ea5c94-7736-4e25-95ad-3fa95f62b66e).

   
   #More info https://learn.microsoft.com/en-us/graph/permissions-selected-overview?tabs=powershell
   
   #Step-1: Install module if not found
   #Install-Module Microsoft.Graph.Sites
   
   #Step-2: set permission for app 89xxx6e and site zappysys.xx.efcdd21xxxxe2
   Import-Module Microsoft.Graph.Sites
   
   #Step-3: Login
   Connect-MgGraph
   
   #Step-4: Set Parameters for API Call (set Permissions, SiteId and AppId - Replace under #TODO)
   
   You can find SiteId by visiting this URL in browser (assuming you visted SharePoint site and already logged in) https://{your-company}.sharepoint.com/_api/site --OR-- for sub-site use https://{your-company}.sharepoint.com/sites/{your-site}/_api/site. Find  Id from the response (e.g. <Id m:type="Edm.Guid">)
   $siteId="yourcompany.sharepoint.com,efcddxxxxxxx104d8b5e3,8c9c6xxxxxxxx84e2"
   #--OR-- simple id
   #$siteId="efcddxxxxxxx104d8b5e3"
   
   
   $params = @{
   	roles = @(
           #possible options are read, write, fullcontrol, owner (write includes read too)
   		#TODO: Change here
   		"write"
   	)
   	grantedTo = @{
   		application = @{
               #find this Client Id (Application Id) from the Azure Portal - Application page (https://portal.azure.com/#view/Microsoft_AAD_RegisteredApps/ApplicationsListBlade)
   			#TODO: Change here
   			id = "c3e9xxxxxx-xxxxx-xxxxx-xxxx-xxxxxb30c1"
   		}
   	}
   }
   
   #Step-5: Grant Permission
   New-MgSitePermission -SiteId $siteId -BodyParameter $params
   
   

Parameters