Skip to main content

Domo Connector

Domo 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:

  1. 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 be acmecompany.
  2. Log in to the Developer Portal:

  3. Enter Instance Name and User Credentials:

    • Provide your Domo Instance Name and user credentials when prompted to log in.
  4. 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.
  5. Create a New Client:

    • Choose the option to create a new client from the "Manage Clients" page.
  6. 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.

InputCommentsDefault
Client IDClient Identifier of your Domo app for the API
Client SecretClient Secret of your Domo app for the API
ScopesSpace separated OAuth permission scopes for the API

Actions

Abort Stream Execution

If needed during an execution, aborts an entire Stream execution.

InputCommentsDefault
Connection
Stream IDThe ID of the Stream of data being imported into a DataSet.
Execution IDThe 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.

InputCommentsDefault
Connection
Project IDThe ID of the project.
List IDThe ID of the list.
Task IDThe ID of the task.

Add User To Group

Add user to a group in your Domo instance.

InputCommentsDefault
Connection
Group IDThe ID of the group.
User IDThe ID of the user.

Commit Stream Execution

Commits stream execution to import combined set of data parts that have been successfully uploaded.

InputCommentsDefault
Connection
Stream IDThe ID of the Stream of data being imported into a DataSet.
Execution IDThe 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.

InputCommentsDefault
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.

InputCommentsDefault
Connection
NameName of the DataSet to create
DescriptionDescription of the DataSet to create
Rows
ColumnsArray of columns in the DataSet

Create Group

Creates a new group in your Domo instance.

InputCommentsDefault
Connection
NameThe name of the group.

Create List

Creates a new list within the given project id.

InputCommentsDefault
Connection
NameThe name of the list.
TypeThe type of the list.
IndexThe 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 IDThe ID of the project.

Create Page

Creates a new page in your Domo instance.

InputCommentsDefault
Connection
NameThe name of the page.
Parent IDIf provided, the page will be created as a subpage to the page provided
Lockedwill restrict other users the ability to make edits to page or its content - the default value is false
Card IDThe ID of the card to add to the page
User IDThe ID of the user that will be given access to view the page
Group IDThe ID of the group that will be given access to view the page

Create Project

Create a new project in your Domo instance

InputCommentsDefault
Connection
MembersArray of user ID's that will be assigned as members of the project
NameThe name of the project.
PublicWhether or not the project should be publicly available to other Domo userstrue
DescriptionThe description of the project.
Due DateThe due date of the project
Member IDBody member
Public Body
NameBody 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.

InputCommentsDefault
Connection
DataSet objectThe DataSet object associated with this Stream.
Update MethodThe data import behavior.
Name
Description
Columns
Update MethodUpdate 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.

InputCommentsDefault
Connection
Stream IDThe ID of the Stream.

Create Task

Add a task to a project list.

InputCommentsDefault
Connection
Project IDThe ID of the project that the task belongs to.
List IDThe ID of the list within a project that the task belongs to.
Task NameThe name of the task.
ContributorsAn array of user IDs that are assigned as contributors to the task.
DescriptionAn optional description of the task.
Due DateThe date the task is expected to be completed.
Owned ByThe ID of the Domo user that owns the task.
PriorityPriority 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.
TagsAn array of tags that have been assigned to the task.
Task ObjectThe request body accepts a task object.

Create User

Creates a new user in your Domo instance.

InputCommentsDefault
Connection
EmailUser's primary email used in profile.
Name
RoleThe role of the user created.Admin
Alternate EmailUser's secondary email in profile.
Employee NumberEmployee number within company.
LocaleLocale used to display to user the system settings throughout Domo application.
LocationFree text that can be used to define office location.
PhonePrimary phone number of user.
Send InviteSend an email invite to created user.
TimezoneTime zone used to display to user the system times throughout Domo application.
TitleUser's job title.
User Body

Delete Account

Deletes an Account from your Domo instance.

InputCommentsDefault
Connection
Account IDThe ID of the account to delete.

Delete Attachment

Permanently deletes an attachment from your task.

InputCommentsDefault
Connection
Project IDThe ID of the project that the attachment belongs to.
Task IDThe ID of the task that the attachment belongs to.
Attachment IDThe 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.

InputCommentsDefault
Connection
DataSet IDThe ID of the DataSet.

Delete Group

Permanently deletes a group from your Domo instance.

InputCommentsDefault
Connection
Group IDThe ID of the group to delete.

Delete List

Permanently deletes a list from your Domo instance.

InputCommentsDefault
Connection
Project IDThe ID of the project.
List IDThe ID of the list.

Delete Page

Permanently deletes a page from your Domo instance.

InputCommentsDefault
Connection
Page IDThe ID of the page.

Delete Project

Permanently deletes a project from your Domo instance.

InputCommentsDefault
Connection
Project IDThe ID of the project.

Delete Stream

Deletes a Stream from your Domo instance. This does not a delete the associated DataSet.

InputCommentsDefault
Connection
Stream IDThe ID of the Stream to delete.

Delete User

Permanently deletes a user from your Domo instance.

InputCommentsDefault
Connection
User IDThe ID of the user.

Download Attachment

Downloads an individual attachment given an attachment id.

InputCommentsDefault
Connection
List IDThe ID of the list.
Project IDThe ID of the project.
Task IDThe ID of the task.
Attachment IDThe ID of the attachment.

Export Data From DataSet

Export data from a DataSet in your Domo instance.

InputCommentsDefault
Connection
File NameThe filename of the exported csv.
Include HeaderInclude 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.

InputCommentsDefault
Connection
Account Type IDThe ID of the account type.

Get Activity Log Entries

Retrieves activity log entries

InputCommentsDefault
Connection
StartThe start time(milliseconds) of when you want to receive log events.
EndThe end time(milliseconds) of when you want to receive log events.
LimitThe maximum number of events you want to retrieve(default is 50, maximum of 1000).
OffsetThe offset location of events you retrieve(default is 0).
UserThe Id of the user.

Get Data Set

Retrieves the details of an existing DataSet.

InputCommentsDefault
Connection
DataSet IDThe ID of the DataSet.

Get Group

Retrieves the details of an existing group.

InputCommentsDefault
Connection
Group IDThe ID of the group.

Get List

Retrieves the details of an individual list given a project id and a list id.

InputCommentsDefault
Connection
Project IDThe ID of the project.
List IDThe ID of the list.

Get List Of Attachments

Retrieve details about all of the attachments belonging to a particular task.

InputCommentsDefault
Connection
Project IDThe ID of the project.
List IDThe ID of the list.
Task IDThe ID of the task.

Get Page

Retrieves the details of an existing page.

InputCommentsDefault
Connection
Page IDThe 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.

InputCommentsDefault
Connection
Project IDThe ID of the project.

Get Project Members

Retrieves a list of ids of the users that are members of the given project id.

InputCommentsDefault
Connection
Project IDThe ID of the project.

Get Stream

Retrieves the details of an existing stream.

InputCommentsDefault
Connection
Stream IDThe id of the stream.
FieldsReturn 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.

InputCommentsDefault
Connection
Stream IDThe ID of the Stream of data being imported into a DataSet.
Execution IDThe ID of the Stream execution within the Stream.

Get Task

Retrieves an individual task from a given project id and list id.

InputCommentsDefault
Connection
List IDThe ID of the list.
Project IDThe ID of the project.
Task IDThe ID of the task.

Get User

Retrieves the details of an existing user.

InputCommentsDefault
Connection
User IDThe 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.

InputCommentsDefault
Connection
DataSet IDThe ID of the DataSet.
CSV Body

List Accounts

Get a list of all Accounts for which the user has permissions.

InputCommentsDefault
Connection
LimitThe number of Accounts to return in the list. The default is 50 and the maximum is 500.
OffsetThe offset of Accounts to begin the list of Accounts within the response.

List DataSets

Get a list of all DataSets in your Domo instance.

InputCommentsDefault
Connection
LimitThe amount of DataSets to return in the list. The default is 50 and the maximum is 50.
Name LikeIf included, will limit the list of DataSets to those with names that contain the string passed in. nameLike is case insensitive.
OffsetThe offset of the DataSet ID to begin list of users within the response.
SortThe 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.

InputCommentsDefault
Connection
LimitThe amount of groups to return in the list. The default is 50 and the maximum is 500.
OffsetThe 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.

InputCommentsDefault
Connection
LimitThe amount of pages to return in the list. The default is 50 and the maximum is 500.
OffsetThe 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.

InputCommentsDefault
Connection
Project IDThe ID of the project.

List Project List Tasks

Retrieves all tasks from a given project id and list id.

InputCommentsDefault
Connection
Project IDThe ID of the project.
List IDThe ID of the list.
LimitThe number of records to offset from the beginning of the result list (defaults to 0)
OffsetThe 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.

InputCommentsDefault
Connection

List Stream Execution

Returns all Stream Execution objects that meet argument criteria from original request.

InputCommentsDefault
Connection
Stream IDThe ID of the Stream
LimitThe amount of Stream to return in the list. The default is 50 and the maximum is 500.
OffsetThe 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.

InputCommentsDefault
Connection
LimitThe amount of Stream to return in the list. The default is 50 and the maximum is 500.
OffsetThe 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.

InputCommentsDefault
Connection
LimitThe amount of users to return in the list. The default is 50 and the maximum is 500.
OffsetThe 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.

InputCommentsDefault
Connection
Group IDThe ID of the group.
LimitThe amount of groups to return in the list. The default is 50 and the maximum is 500.
OffsetThe offset of the group ID to begin list of groups within the response.

Query Data Set

Queries the data in an existing Domo DataSet

InputCommentsDefault
Connection
DataSet IDThe ID of the DataSet.
SQLThe SQL query to execute.

Raw Request

Send raw HTTP request to Domo.

InputCommentsDefault
Connection
URLThis is the URL to call.
MethodThe HTTP method to use.
DataThe HTTP body payload to send to the URL.
Form DataThe Form Data to be sent as a multipart form upload.
File DataFile Data to be sent as a multipart form upload.
File Data File NamesFile names to apply to the file data inputs. Keys must match the file data keys above.
Query ParameterA 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.
HeaderA list of headers to send with the request.
Response TypeThe type of data you expect in the response. You can request json, text, or binary data.json
TimeoutThe maximum time that a client will await a response to its request
Debug RequestEnabling this flag will log out the current request.false
Retry Delay (ms)The delay in milliseconds between retries.0
Retry On All ErrorsIf true, retries on all erroneous responses regardless of type.false
Max Retry CountThe maximum number of retries to attempt.0
Use Exponential BackoffSpecifies 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.

InputCommentsDefault
Connection
Group IDThe ID of the group.
User IDThe ID of the user.

Search Stream

Returns all Stream objects that meet argument criteria from original request.

InputCommentsDefault
Connection
QualifiersThe search qualifiers to search by available qualifiers: dataSource.id or dataSource.owner.id
FieldsReturn desired fields: {all} or {id, dataset, updateMethod, createdAt, or modifiedAt}

Share Account

Share an Account with a User.

InputCommentsDefault
Connection
UserThe User to share the Account with.
Account IDThe ID of the Account.

Update Account

Updates the specified Account’s metadata as well as the Account’s Type properties.

InputCommentsDefault
Connection
Account IDThe ID of the account to update.
Update Account Body

Update Data Set

Updates the specified DataSet’s metadata by providing values to parameters passed.

InputCommentsDefault
Connection
DataSet IDThe 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.

InputCommentsDefault
Connection
Group IDThe ID of the group.
Update Group Body

Update List

Update the details of a list given an existing project id and list id.

InputCommentsDefault
Connection
List IDThe ID of the list.
Project IDThe ID of the project.
IndexThe 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.
NameThe updated name of the list.
TypeThe 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.

InputCommentsDefault
Connection
Page IDThe 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

InputCommentsDefault
Connection
Project IDThe ID of the project.
Update Project Body
DescriptionUpdates the description of the project.
Due DateUpdates the due date of the project.
NameUpdates the name of the project.
PublicUpdates whether or not the project is publicly available to Domo users.

Update Project Members

Update the members of a given project id.

InputCommentsDefault
Connection
Project IDThe ID of the project.
Update Project Members Body

Update Stream

Updates the specified Stream’s metadata by providing values to parameters passed.

InputCommentsDefault
Connection
Stream IDThe ID of the stream to update.
Update MethodThe data import behavior.
Update Method Body

Update Task

Update the details of a task given an existing project id, list id, and task id.

InputCommentsDefault
Connection
Task IDThe ID of the task.
List IDThe ID of the list.
Project IDThe ID of the project.
ContributorsAn array of user IDs that are assigned as contributors to the task.
DescriptionDescription of the DataSet to create
Due DateThe due date of the project
Owned ByThe ID of the Domo user that owns the task.
PriorityPriority 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.
TagsAn array of tags that have been assigned to the task.
Task NameThe 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.

InputCommentsDefault
Connection
User IDThe ID of the user.
EmailUser's primary email used in profile.
NameUser's full name
RoleThe system role of the userAdmin
Alternate EmailUser's secondary email in profile.
Employee NumberEmployee number within company.
LocaleLocale used to display to user the system settings throughout Domo application.
LocationFree text that can be used to define office location.
PhonePrimary phone number of user.
RoledThe ID of the custom or system role of the user.
TimezoneTime zone used to display to user the system times throughout Domo application.
TitleUser'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.

InputCommentsDefault
Connection
Stream IDThe ID of the Stream of data being imported into a DataSet.
Execution IDThe ID of the Stream execution within the Stream.
Part IDThe ID of the data part being used to upload a subset of data within the Stream execution.