Microsoft SharePoint Online Connector (Deprecated)
Intro
Microsoft SharePoint Online enables organizations to create and manage custom team-focused and project-focused sites for collaboration. Use Domo's SharePoint Online connector to retrieve data about SharePoint Online entities such as member and visitor groups, folders and documents, templates, recycle bin items, and so on. To learn more about the SharePoint API, visit their page (https://msdn.microsoft.com/en-us/lib.../jj860569.aspx).
You connect to your SharePoint Online account in the Data Center. This topic discusses the fields and menus that are specific to the SharePoint Online 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.
Connecting to Your SharePoint Online Account
The Microsoft SharePoint Online Connector has been deprecated and cannot be used to power up new DataSets.
Details Pane
This pane contains a primary Reports menu, along with various other menus which may or may not appear depending on the report type you select.
Menu |
Description |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Report |
Select the SharePoint Online report you want to run. The following reports are available:
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Server Relative URL |
Enter the server relative URL for the file or folder. File example: /sites/MySite/Shared Documents/MyFolder/File.xlsx. Folder example: /sites/MySite/MyFolder. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
File Type |
Select the file type for the document you want to retrieve. If you select Other, file content will be shown as a binary column. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Select the Delimiting Character |
Select the character used to separate your CSV columns. If your delimiter is not listed, select Other. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Enter Your Data Tag |
Enter the data tag for your JSON or XML file. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Do You Want to Change the Default Parsing Output? |
Select True if the required values in your JSON or XML file should be flattened. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Values to Flatten |
Enter a comma-separated list of values to be flattened. For example: value1,value2...,valueN |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
List Title |
Enter the title of the list you want to retrieve information for. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
List Item ID |
Enter the ID of the list item you want to retrieve information for. |
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.