Skip to main content
waffle.svg
Domo Knowledge Base

Sharepoint Online Writeback Connector

Version 1

 

Intro

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 (https://msdn.microsoft.com/en-us/lib.../jj860569.aspx).

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.

Prerequisites

To configure this connector, you must have a Domo Client ID and Client Secret. To obtain these credentials, do the following:

  1. Log into your Domo developer account at https://developer.domo.com/login

  2. Create a new client

  3. Select the desired data and user application scope.

  4. Click Create.

You must also have the following:

  • A Sharepoint Client ID

  • A Sharepoint Client Secret

To obtain a client ID,

  1. Go to portal.azure.com.

  2. Select Azure Active Directory > App registrations.

  3. Find and click on your web app.

The "application" ID is the client ID.

To obtain a client secret,

  1. Go to portal.azure.com.

  2. Select Azure Active Directory > App registrations.

  3. Find and click on your web app.

  4. Go to Settings > Keys.

  5. Create the client secret.

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:  

Field

Description

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.

Menu

Description

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 https://mycompany.domo.com/datasourc...tails/overview, 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.

Filename

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.