Skip to main content

​
Intro

SharePoint Online Writeback Connector 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 Connector.

​
Prerequisites

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

​
To obtain your 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. Once you have created a client, you can manage the client by clicking Manage Client.
  6. Your Value will appear in the Manage Client section.

​
To obtain your SharePoint Secret ID:

  1. Go to https://portal.azure.com.
  2. Select Azure Active Directory > App registrations.
  3. Find and click your web app.
  4. The “application ID” is your Secret ID.

​
To obtain your SharePoint Value:

  1. Go to https://portal.azure.com.
  2. Select Azure Active Directory > App registrations.
  3. Find and click your web app.
  4. Open Certificates and secrets.
  5. Click +New secret.
  6. Provide the value description and the expiry period for your secret.
  7. Click Add.

     Your new value will appear. Copy and paste in your Domo connector SharePoint client secret field.

​
Configuring the Connection

This section enumerates the options in the Credentials and Details panes on the SharePoint Online Connector page. The components of the other panes on this page, Scheduling, and Name & Describe Your DataSet, are universal across most connector types and are discussed in great detail in Adding a DataSet Using a 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

Domo Client ID
  1. Login into Developer account .
  2. Create new client.
  3. Select data and the user application scope.
  4. Hit create.
Domo Client Secret
  1. Login into Developer account.
  2. Create new client.
  3. Select data & user application scope.
  4. Hit create.
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 Manage Connector Accounts.

​
Details Pane

This pane contains options for configuring your connection.

Menu

Description

Input DataSet Id Enter your Domo dataset ID(GUID) located in the dataset url. For example: https://customer.domo.com/datasources/ aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee/details/settings .
Select filename Select the filename.
FileName Enter the output file name.
How would you like to select the site? Select how would you like to select the site.
Sites Discovery Select the site that you would like to use.
Site Search Query Enter the search query to obtain the sites.
Site Search Query Discovery Select the site that you would like to use.
Select How would you like to choose the folder to store the file? Select how you want to choose the folder to store the file.
Folder Path Enter the folder path separated by the delimeter / where you want to store the file.
Example: testFolder/TestNestedFolder
NOTE: The Folder path is Case-Sensitive. Provide accordingly.
Where to Store the File? Select the name of the folder in which the file should be saved. Select ‘Root’ if the file needs to be stored at the root level of selected site.
Select Mode Select the required option. In the Rename mode, if the filename already exists, then it will be renamed by appending filename 1, filename 2, and so on.

​
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 Connector.