Domo Connector
The Domo platform includes a world class data warehouse, robust data pipeline functionality, and visualization engine.
Connections
Domo OAuth Connection
OAuth Connectivity for Domo
Generating Client ID and Client Secret
To generate a client ID and client secret for your Domo instance, follow these steps:
-
Obtain your Domo Instance Name:
- Your Domo Instance Name is the part of the URL preceding "domo.com." For instance, if your Domo URL is
acmecompany.domo.com
, your instance name would beacmecompany
.
- Your Domo Instance Name is the part of the URL preceding "domo.com." For instance, if your Domo URL is
-
Log in to the Developer Portal:
- Click on the "Dev Portal Login" link to access the Developer Portal or follow this link https://developer.domo.com/login.
-
Enter Instance Name and User Credentials:
- Provide your Domo Instance Name and user credentials when prompted to log in.
-
Access "Manage Clients" Page:
- After logging in successfully, you will be redirected to the Developer Portal's homepage.
- Click on the "My Account" dropdown, and you will find options to manage clients, create a new one, or logout.
-
Create a New Client:
- Choose the option to create a new client from the "Manage Clients" page.
-
Submit and Obtain Client ID and Secret:
- After submitting the required information, a newly provisioned client ID and client secret will be generated and displayed on the "Manage Clients" page.
Now you have successfully generated a client ID and client secret for your Domo instance. These credentials will be used in the component's OAuth connection.
Input | Comments | Default |
---|---|---|
Client ID | Client Identifier of your Domo app for the API | |
Client Secret | Client Secret of your Domo app for the API | |
Scopes | Space separated OAuth permission scopes for the API |
Actions
Abort Stream Execution
If needed during an execution, aborts an entire Stream execution.
Input | Comments | Default |
---|---|---|
Connection | ||
Stream ID | The ID of the Stream of data being imported into a DataSet. | |
Execution ID | The ID of the Stream execution within the Stream, if no Stream execution ID is provided, the current Stream execution will be aborted. |
Add Attachment
Add a multipart form file to a task item as an attachment.
Input | Comments | Default |
---|---|---|
Connection | ||
Project ID | The ID of the project. | |
List ID | The ID of the list. | |
Task ID | The ID of the task. |
Add User To Group
Add user to a group in your Domo instance.
Input | Comments | Default |
---|---|---|
Connection | ||
Group ID | The ID of the group. | |
User ID | The ID of the user. |
Commit Stream Execution
Commits stream execution to import combined set of data parts that have been successfully uploaded.
Input | Comments | Default |
---|---|---|
Connection | ||
Stream ID | The ID of the Stream of data being imported into a DataSet. | |
Execution ID | The ID of the Stream execution within the Stream |
Create Account
When creating an Account, you must specify the Account Type properties. The Account Type properties are different, depending on the type of Account you are trying to create.
Input | Comments | Default |
---|---|---|
Connection | ||
Name | ||
ID | ||
Password | ||
Authenticate By | ||
URL | ||
Username |
Create Data Set
Creates a new DataSet in your Domo instance. Once the DataSet has been created, data can then be imported into the DataSet.
Input | Comments | Default |
---|---|---|
Connection | ||
Name | Name of the DataSet to create | |
Description | Description of the DataSet to create | |
Rows | ||
Columns | Array of columns in the DataSet |
Create Group
Creates a new group in your Domo instance.
Input | Comments | Default |
---|---|---|
Connection | ||
Name | The name of the group. |
Create List
Creates a new list within the given project id.
Input | Comments | Default |
---|---|---|
Connection | ||
Name | The name of the list. | |
Type | The type of the list. | |
Index | The ordered index of the list within the project. Setting this property will re-order other lists in the project to maintain sequential order. Leaving this property blank will default the index to 1 and shift the index of all other lists. | |
Project ID | The ID of the project. |
Create Page
Creates a new page in your Domo instance.
Input | Comments | Default |
---|---|---|
Connection | ||
Name | The name of the page. | |
Parent ID | If provided, the page will be created as a subpage to the page provided | |
Locked | will restrict other users the ability to make edits to page or its content - the default value is false | |
Card ID | The ID of the card to add to the page | |
User ID | The ID of the user that will be given access to view the page | |
Group ID | The ID of the group that will be given access to view the page |
Create Project
Create a new project in your Domo instance
Input | Comments | Default |
---|---|---|
Connection | ||
Members | Array of user ID's that will be assigned as members of the project | |
Name | The name of the project. | |
Public | Whether or not the project should be publicly available to other Domo users | true |
Description | The description of the project. | |
Due Date | The due date of the project | |
Member ID | Body member | |
Public Body | ||
Name | Body name |
Create Stream
When creating a Stream, specify the DataSet properties (name and description) and as a convenience, the create Stream API will create a DataSet for you.
Input | Comments | Default |
---|---|---|
Connection | ||
DataSet object | The DataSet object associated with this Stream. | |
Update Method | The data import behavior. | |
Name | ||
Description | ||
Columns | ||
Update Method | Update method for body. |
Create Stream Execution
When you’re ready to upload data to your DataSet via a Stream, you first tell Domo that you’re ready to start sending data by creating an Execution.
Input | Comments | Default |
---|---|---|
Connection | ||
Stream ID | The ID of the Stream. |
Create Task
Add a task to a project list.
Input | Comments | Default |
---|---|---|
Connection | ||
Project ID | The ID of the project that the task belongs to. | |
List ID | The ID of the list within a project that the task belongs to. | |
Task Name | The name of the task. | |
Contributors | An array of user IDs that are assigned as contributors to the task. | |
Description | An optional description of the task. | |
Due Date | The date the task is expected to be completed. | |
Owned By | The ID of the Domo user that owns the task. | |
Priority | Priority of task within a list. Setting this property will impact the index of other tasks in the list to maintain sequential order. If not provided the priority will default to 1 and the index of all the other tasks in the list will shift. | |
Tags | An array of tags that have been assigned to the task. | |
Task Object | The request body accepts a task object. |
Create User
Creates a new user in your Domo instance.
Input | Comments | Default |
---|---|---|
Connection | ||
User's primary email used in profile. | ||
Name | ||
Role | The role of the user created. | Admin |
Alternate Email | User's secondary email in profile. | |
Employee Number | Employee number within company. | |
Locale | Locale used to display to user the system settings throughout Domo application. | |
Location | Free text that can be used to define office location. | |
Phone | Primary phone number of user. | |
Send Invite | Send an email invite to created user. | |
Timezone | Time zone used to display to user the system times throughout Domo application. | |
Title | User's job title. | |
User Body |
Delete Account
Deletes an Account from your Domo instance.
Input | Comments | Default |
---|---|---|
Connection | ||
Account ID | The ID of the account to delete. |
Delete Attachment
Permanently deletes an attachment from your task.
Input | Comments | Default |
---|---|---|
Connection | ||
Project ID | The ID of the project that the attachment belongs to. | |
Task ID | The ID of the task that the attachment belongs to. | |
Attachment ID | The ID of the attachment. |
Delete Data Set
Permanently deletes a DataSet from your Domo instance. This can be done for all DataSets, not just those created through the API.
Input | Comments | Default |
---|---|---|
Connection | ||
DataSet ID | The ID of the DataSet. |
Delete Group
Permanently deletes a group from your Domo instance.
Input | Comments | Default |
---|---|---|
Connection | ||
Group ID | The ID of the group to delete. |
Delete List
Permanently deletes a list from your Domo instance.
Input | Comments | Default |
---|---|---|
Connection | ||
Project ID | The ID of the project. | |
List ID | The ID of the list. |
Delete Page
Permanently deletes a page from your Domo instance.
Input | Comments | Default |
---|---|---|
Connection | ||
Page ID | The ID of the page. |
Delete Project
Permanently deletes a project from your Domo instance.
Input | Comments | Default |
---|---|---|
Connection | ||
Project ID | The ID of the project. |
Delete Stream
Deletes a Stream from your Domo instance. This does not a delete the associated DataSet.
Input | Comments | Default |
---|---|---|
Connection | ||
Stream ID | The ID of the Stream to delete. |
Delete User
Permanently deletes a user from your Domo instance.
Input | Comments | Default |
---|---|---|
Connection | ||
User ID | The ID of the user. |
Download Attachment
Downloads an individual attachment given an attachment id.
Input | Comments | Default |
---|---|---|
Connection | ||
List ID | The ID of the list. | |
Project ID | The ID of the project. | |
Task ID | The ID of the task. | |
Attachment ID | The ID of the attachment. |
Export Data From DataSet
Export data from a DataSet in your Domo instance.
Input | Comments | Default |
---|---|---|
Connection | ||
File Name | The filename of the exported csv. | |
Include Header | Include table header. |
Get Accounts
Retrieve the details of an account type. This includes information on the properties required to create an Account of this type.
Input | Comments | Default |
---|---|---|
Connection | ||
Account Type ID | The ID of the account type. |
Get Activity Log Entries
Retrieves activity log entries
Input | Comments | Default |
---|---|---|
Connection | ||
Start | The start time(milliseconds) of when you want to receive log events. | |
End | The end time(milliseconds) of when you want to receive log events. | |
Limit | The maximum number of events you want to retrieve(default is 50, maximum of 1000). | |
Offset | The offset location of events you retrieve(default is 0). | |
User | The Id of the user. |
Get Data Set
Retrieves the details of an existing DataSet.
Input | Comments | Default |
---|---|---|
Connection | ||
DataSet ID | The ID of the DataSet. |
Get Group
Retrieves the details of an existing group.
Input | Comments | Default |
---|---|---|
Connection | ||
Group ID | The ID of the group. |
Get List
Retrieves the details of an individual list given a project id and a list id.
Input | Comments | Default |
---|---|---|
Connection | ||
Project ID | The ID of the project. | |
List ID | The ID of the list. |
Get List Of Attachments
Retrieve details about all of the attachments belonging to a particular task.
Input | Comments | Default |
---|---|---|
Connection | ||
Project ID | The ID of the project. | |
List ID | The ID of the list. | |
Task ID | The ID of the task. |
Get Page
Retrieves the details of an existing page.
Input | Comments | Default |
---|---|---|
Connection | ||
Page ID | The ID of the page. |
Get Project
Retrieves the details of an individual existing project given a project id. Use the special project ID me to return your personal project.
Input | Comments | Default |
---|---|---|
Connection | ||
Project ID | The ID of the project. |
Get Project Members
Retrieves a list of ids of the users that are members of the given project id.
Input | Comments | Default |
---|---|---|
Connection | ||
Project ID | The ID of the project. |
Get Stream
Retrieves the details of an existing stream.
Input | Comments | Default |
---|---|---|
Connection | ||
Stream ID | The id of the stream. | |
Fields | Return desired fields: {all} or {id, dataset, updateMethod, createdAt, or modifiedAt} |
Get Stream Execution
Import data into a DataSet in your Domo instance. This request will replace the data currently in the DataSet.
Input | Comments | Default |
---|---|---|
Connection | ||
Stream ID | The ID of the Stream of data being imported into a DataSet. | |
Execution ID | The ID of the Stream execution within the Stream. |
Get Task
Retrieves an individual task from a given project id and list id.
Input | Comments | Default |
---|---|---|
Connection | ||
List ID | The ID of the list. | |
Project ID | The ID of the project. | |
Task ID | The ID of the task. |
Get User
Retrieves the details of an existing user.
Input | Comments | Default |
---|---|---|
Connection | ||
User ID | The ID of the user. |
Import Data Into DataSet
Import data into a DataSet in your Domo instance. This request will replace the data currently in the DataSet.
Input | Comments | Default |
---|---|---|
Connection | ||
DataSet ID | The ID of the DataSet. | |
CSV Body |
List Accounts
Get a list of all Accounts for which the user has permissions.
Input | Comments | Default |
---|---|---|
Connection | ||
Limit | The number of Accounts to return in the list. The default is 50 and the maximum is 500. | |
Offset | The offset of Accounts to begin the list of Accounts within the response. |
List DataSets
Get a list of all DataSets in your Domo instance.
Input | Comments | Default |
---|---|---|
Connection | ||
Limit | The amount of DataSets to return in the list. The default is 50 and the maximum is 50. | |
Name Like | If included, will limit the list of DataSets to those with names that contain the string passed in. nameLike is case insensitive. | |
Offset | The offset of the DataSet ID to begin list of users within the response. | |
Sort | The DataSet field to sort by. Fields prefixed with a negative sign reverses the sort (i.e. '-name' does a reverse sort by the name of the DataSets). |
List Groups
Get a list of all groups in your Domo instance.
Input | Comments | Default |
---|---|---|
Connection | ||
Limit | The amount of groups to return in the list. The default is 50 and the maximum is 500. | |
Offset | The offset of the group ID to begin list of groups within the response. |
List Pages
Get a list of all pages in your Domo instance.
Input | Comments | Default |
---|---|---|
Connection | ||
Limit | The amount of pages to return in the list. The default is 50 and the maximum is 500. | |
Offset | The offset of the page ID to begin list of pages within the response. |
List Project Lists
Retrieves all lists available within a given project id.
Input | Comments | Default |
---|---|---|
Connection | ||
Project ID | The ID of the project. |
List Project List Tasks
Retrieves all tasks from a given project id and list id.
Input | Comments | Default |
---|---|---|
Connection | ||
Project ID | The ID of the project. | |
List ID | The ID of the list. | |
Limit | The number of records to offset from the beginning of the result list (defaults to 0) | |
Offset | The maximum amount of results to return (defaults to 10 with a maximum of 50) |
List Projects
Retrieves a list of all projects that the client scope has access to.
Input | Comments | Default |
---|---|---|
Connection |
List Stream Execution
Returns all Stream Execution objects that meet argument criteria from original request.
Input | Comments | Default |
---|---|---|
Connection | ||
Stream ID | The ID of the Stream | |
Limit | The amount of Stream to return in the list. The default is 50 and the maximum is 500. | |
Offset | The offset of the Stream ID to begin list of users within the response. |
List Streams
Get a list of all Streams for which the user has view permissions.
Input | Comments | Default |
---|---|---|
Connection | ||
Limit | The amount of Stream to return in the list. The default is 50 and the maximum is 500. | |
Offset | The offset of the Stream ID to begin list of users within the response. |
List Users
Get a list of all users in your Domo instance.
Input | Comments | Default |
---|---|---|
Connection | ||
Limit | The amount of users to return in the list. The default is 50 and the maximum is 500. | |
Offset | The offset of the user ID to begin list of users within the response. |
List Users In Group
List the users in a group in your Domo instance.
Input | Comments | Default |
---|---|---|
Connection | ||
Group ID | The ID of the group. | |
Limit | The amount of groups to return in the list. The default is 50 and the maximum is 500. | |
Offset | The offset of the group ID to begin list of groups within the response. |
Query Data Set
Queries the data in an existing Domo DataSet
Input | Comments | Default |
---|---|---|
Connection | ||
DataSet ID | The ID of the DataSet. | |
SQL | The SQL query to execute. |
Raw Request
Send raw HTTP request to Domo.
Input | Comments | Default |
---|---|---|
Connection | ||
URL | This is the URL to call. | |
Method | The HTTP method to use. | |
Data | The HTTP body payload to send to the URL. | |
Form Data | The Form Data to be sent as a multipart form upload. | |
File Data | File Data to be sent as a multipart form upload. | |
File Data File Names | File names to apply to the file data inputs. Keys must match the file data keys above. | |
Query Parameter | A list of query parameters to send with the request. This is the portion at the end of the URL similar to ?key1=value1&key2=value2. | |
Header | A list of headers to send with the request. | |
Response Type | The type of data you expect in the response. You can request json, text, or binary data. | json |
Timeout | The maximum time that a client will await a response to its request | |
Debug Request | Enabling this flag will log out the current request. | false |
Retry Delay (ms) | The delay in milliseconds between retries. | 0 |
Retry On All Errors | If true, retries on all erroneous responses regardless of type. | false |
Max Retry Count | The maximum number of retries to attempt. | 0 |
Use Exponential Backoff | Specifies whether to use a pre-defined exponential backoff strategy for retries. | false |
Remove User From Group
Remove a user from a group in your Domo instance.
Input | Comments | Default |
---|---|---|
Connection | ||
Group ID | The ID of the group. | |
User ID | The ID of the user. |
Search Stream
Returns all Stream objects that meet argument criteria from original request.
Input | Comments | Default |
---|---|---|
Connection | ||
Qualifiers | The search qualifiers to search by available qualifiers: dataSource.id or dataSource.owner.id | |
Fields | Return desired fields: {all} or {id, dataset, updateMethod, createdAt, or modifiedAt} |
Share Account
Share an Account with a User.
Input | Comments | Default |
---|---|---|
Connection | ||
User | The User to share the Account with. | |
Account ID | The ID of the Account. |
Update Account
Updates the specified Account’s metadata as well as the Account’s Type properties.
Input | Comments | Default |
---|---|---|
Connection | ||
Account ID | The ID of the account to update. | |
Update Account Body |
Update Data Set
Updates the specified DataSet’s metadata by providing values to parameters passed.
Input | Comments | Default |
---|---|---|
Connection | ||
DataSet ID | The ID of the DataSet. | |
Update DataSet Body |
Update Group
Updates the specified group by providing values to parameters passed. Any parameter left out of the request will cause the specific group’s attribute to remain unchanged.
Input | Comments | Default |
---|---|---|
Connection | ||
Group ID | The ID of the group. | |
Update Group Body |
Update List
Update the details of a list given an existing project id and list id.
Input | Comments | Default |
---|---|---|
Connection | ||
List ID | The ID of the list. | |
Project ID | The ID of the project. | |
Index | The updated index of the list within the project. Updating the index of a list may also change the order of the other lists in the project to remain sequential. | |
Name | The updated name of the list. | |
Type | The type of the list. | |
Update List Body |
Update Page
Updates the specified page by providing values to parameters passed. Any parameter left out of the request will cause the specific page’s attribute to remain unchanged.
Input | Comments | Default |
---|---|---|
Connection | ||
Page ID | The ID of the page. | |
Update Page Body |
Update Project
Updates attributes of an existing project in your Domo instance. The following properties are read-only and cannot be updated with this request:id members createdBy createdDate
Input | Comments | Default |
---|---|---|
Connection | ||
Project ID | The ID of the project. | |
Update Project Body | ||
Description | Updates the description of the project. | |
Due Date | Updates the due date of the project. | |
Name | Updates the name of the project. | |
Public | Updates whether or not the project is publicly available to Domo users. |
Update Project Members
Update the members of a given project id.
Input | Comments | Default |
---|---|---|
Connection | ||
Project ID | The ID of the project. | |
Update Project Members Body |
Update Stream
Updates the specified Stream’s metadata by providing values to parameters passed.
Input | Comments | Default |
---|---|---|
Connection | ||
Stream ID | The ID of the stream to update. | |
Update Method | The data import behavior. | |
Update Method Body |
Update Task
Update the details of a task given an existing project id, list id, and task id.
Input | Comments | Default |
---|---|---|
Connection | ||
Task ID | The ID of the task. | |
List ID | The ID of the list. | |
Project ID | The ID of the project. | |
Contributors | An array of user IDs that are assigned as contributors to the task. | |
Description | Description of the DataSet to create | |
Due Date | The due date of the project | |
Owned By | The ID of the Domo user that owns the task. | |
Priority | Priority of task within a list. Setting this property will impact the index of other tasks in the list to maintain sequential order. If not provided the priority will default to 1 and the index of all the other tasks in the list will shift. | |
Tags | An array of tags that have been assigned to the task. | |
Task Name | The name of the task. | |
Update Task Body |
Update User
Updates the specified user by providing values to parameters passed. Any parameter left out of the request will cause the specific user’s attribute to remain unchanged.
Input | Comments | Default |
---|---|---|
Connection | ||
User ID | The ID of the user. | |
User's primary email used in profile. | ||
Name | User's full name | |
Role | The system role of the user | Admin |
Alternate Email | User's secondary email in profile. | |
Employee Number | Employee number within company. | |
Locale | Locale used to display to user the system settings throughout Domo application. | |
Location | Free text that can be used to define office location. | |
Phone | Primary phone number of user. | |
Roled | The ID of the custom or system role of the user. | |
Timezone | Time zone used to display to user the system times throughout Domo application. | |
Title | User's job title. | |
Update User Body |
Upload Data Part
Creates a data part within the Stream execution to upload chunks of rows to the DataSet. The calling client should keep track of parts and order them accordingly in an increasing sequence. If a part upload fails, retry the upload as all parts must be present before committing the stream execution.
Input | Comments | Default |
---|---|---|
Connection | ||
Stream ID | The ID of the Stream of data being imported into a DataSet. | |
Execution ID | The ID of the Stream execution within the Stream. | |
Part ID | The ID of the data part being used to upload a subset of data within the Stream execution. |