Export to SharePoint

​

Register a Microsoft Entra application

1. In the Microsoft Entra admin center, go to App registrations and click New registration.
2. Enter a name such as Bytebase Export, keep Accounts in this organizational directory only, and click Register. Leave Redirect URI blank.
3. On the application’s Overview page, copy the Application (client) ID and the Directory (tenant) ID.
4. Go to API permissions, click Add a permission > Microsoft Graph > Application permissions, select Lists.SelectedOperations.Selected, and click Add permissions.
5. Click Grant admin consent for your tenant.
6. Go to Certificates & secrets > Client secrets, click New client secret, choose an expiration, and click Add. Copy the secret’s Value right away; Entra shows it only once.

​

Grant the application access to a library

1. Look up the site ID. Open the library in SharePoint and check its URL. The site path is everything before the library name. In https://contoso.sharepoint.com/sites/Finance/Shared%20Documents/Forms/AllItems.aspx, the site is /sites/Finance and the library is Shared Documents. Request the site, using /teams/ instead of /sites/ for a team site:
   GET https://graph.microsoft.com/v1.0/sites/<tenant>.sharepoint.com:/sites/<site_name>
   
   The id in the response is the site ID.
2. Look up the library’s list ID:
   GET https://graph.microsoft.com/v1.0/sites/<site_id>/lists?$select=id,displayName,webUrl
   
   Find the library by its webUrl.
3. Create the permission:
   POST https://graph.microsoft.com/v1.0/sites/<site_id>/lists/<list_id>/permissions
   Content-Type: application/json
   
   {
     "grantedToV2": {
       "application": {
         "id": "<client_id>",
         "displayName": "Bytebase Export"
       }
     },
     "roles": ["write"]
   }
   

​

Configure SharePoint in Bytebase

1. Go to Integration > Export Destinations and click Configure on the SharePoint row.
2. Enter the Tenant ID, Client ID, and Client secret, then click Save.

​

Set a project’s SharePoint folder

1. Open the project and go to Settings.
2. Under Security & Policy > Export destinations, paste the SharePoint URL of the library or folder into the SharePoint field.
3. Click Update.

​

Export query results to SharePoint

1. Run a query in SQL Editor and click Export on the result.
2. The Export Data drawer selects SharePoint by default. Switch Destination to Download if you want a local file and your workspace allows it.
3. Choose Export rows and Export format, then click Confirm.

20261102T072108Z-demo@example.com-hr_test-479c51fc/
  statement-1.sql
  statement-1.result.csv
  statement-2.sql
  statement-2.result.csv