Skip to main content
Domo Knowledge Base

Sharepoint Online Writeback Connector

Version 3



Microsoft SharePoint Online enables organizations to create and manage custom team-focused and project-focused sites for collaboration. Use Domo's SharePoint Online Writeback connector to push data from a Domo DataSet to Sharepoint. To learn more about the SharePoint API, visit their page (

You configure your Domo-Sharepoint connection in the Data Center. This topic discusses the fields and menus that are specific to the Sharepoint Online Writeback connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Data Connector.


To configure this connector, you must have a Domo Client ID and Client Secret.

To obtain the Domo Client ID and Client Secret:
  1. Log into the Domo developer account.
  2. In the top right corner under My Account click New Client.
  3. Enter the application name and description.
  4. Provide the application scope by selecting the checkboxes for Data and User.
  5. Click Create.
  6. Once you have created a client, you can manage the client by clicking on Manage Client.
  7. Your Client Secret will appear in the Manage Client section.

You must also have your Sharepoint Client ID and Client Secret.

To obtain the Sharepoint Client ID:

1. Go to

2. Select Azure Active Directory > App registrations.

3. Find and click on your web app.

4. The "application" ID is your Client ID.

To obtain the Sharepoint Client secret:
  1. Go to

  2. Select Azure Active Directory > App registrations.

  3. Find and click on your web app.

  4. Open Certificates and secrets.

  5. Click +New client secret.

  6. Provide the client secret description and the expiry period for your secret. Click Add.

  7. Your new client secret will appear. Copy it and paste in your Domo connector Client Secret field.

Creating an Azure App for Enterprise OAuth

To create a Microsoft Azure app, do the following:

1. Log into

2. Click on App registrations.


3. Click New registration.

4. Enter the application name and select the supported account type as below. Enter the Redirect URI for Web as

App URI.png

5. Click Register.

6. Now, click API Permissions.

API permission.png

11. Click +Add Permissions button.


12. Select the permissions as required.


12. After adding the permissions, the configured permissions will be listed.


Configuring the Connection

This section enumerates the options in the Credentials and Details panes in the Sharepoint Online Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.

Credentials Pane

This pane contains fields for entering credentials to connect to your Sharepoint Online account. The following table describes what is needed for each field:  



Sharepoint Client ID

Enter your Sharepoint client ID.

Sharepoint Client Secret

Enter your Sharepoint client secret.

Domo Client ID

Enter your Domo client ID.

Domo Client Secret

Enter your Domo client secret.

Once you have entered valid credentials, you can use the same account any time you go to create a new Sharepoint Online Writeback DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors.

Details Pane

This pane contains options for configuring your connection.



Input DataSet ID

Enter the DataSet ID (GUID) for the DataSet you want to copy to Sharepoint Online. You can find the ID by opening the details view for the DataSet in the Data Center and looking at the portion of the URL following datasources/. For example, in the URL, the DataSet ID is 845305d8-da3d-4107-a9d6-13ef3f86d4a4

Select Filename

Select how you want to choose the file where data will be copied. 

  • Use Input DataSet GUID. The filename will be the number you entered for Input DataSet ID.

  • Use Input DataSet Name. The filename will be the same as that of the input DataSet.

  • Enter File Name. You will give the file a custom name in the File Name field.


Entered the desired output filename.

Site and Group Site ID

Select the Sharepoint site in which you want to send your data.

Where to Store the File?

Select the Sharepoint folder in which you want to store the DataSet data. Select Root if you want the file to be stored at the root level of the selected site.

Select Mode

Select what should happen when a file with the same name is discovered, either Rename or Replace. If you choose Rename, if the filename already exists, it will be renamed by appending a number, e.g. filename 1, filename 2, etc.

Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Data Connector.