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 | The Domo connection to use. | |
| 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 | The Domo connection to use. | |
| 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 | The Domo connection to use. | |
| 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 | The Domo connection to use. | |
| 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 | The Domo connection to use. | |
| 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 | The Domo connection to use. | |
| Name | Name of the DataSet to create | |
| Description | Description of the DataSet to create. | |
| Rows | Number of rows in the DataSet. | |
| Columns | Array of columns in the DataSet. |
Create Group
Creates a new group in your Domo instance.
| Input | Comments | Default |
|---|---|---|
| Connection | The Domo connection to use. | |
| Name | The name of the group. |
Create List
Creates a new list within the given project id.
| Input | Comments | Default |
|---|---|---|
| Connection | The Domo connection to use. | |
| 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 | The Domo connection to use. | |
| Name | The name of the page. | |
| Parent ID | If provided, the page will be created as a subpage to the page provided | |
| Locked | When true, restricts other users the ability to make edits to page or its content. | |
| 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 | The Domo connection to use. | |
| Members | Array of user IDs that will be assigned as members of the project. | |
| Name | The name of the project. | |
| Public | When true, the project will be publicly available to other Domo users. | true |
| Description | The description of the project. | |
| Due Date | The due date of the project in ISO 8601 format. | |
| Member ID | User IDs of members to include in the project. | |
| 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 | The Domo connection to use. | |
| 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 | The Domo connection to use. | |
| Stream ID | The ID of the Stream. |
Create Task
Add a task to a project list.
| Input | Comments | Default |
|---|---|---|
| Connection | The Domo connection to use. | |
| 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 task object to create or update. |
Create User
Creates a new user in your Domo instance.
| Input | Comments | Default |
|---|---|---|
| Connection | The Domo connection to use. | |
| User's primary email used in profile. | ||
| Name | ||
| Role | The 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. | |
| Send Invite | When true, sends 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 | The user object to create. |
Delete Account
Deletes an Account from your Domo instance.
| Input | Comments | Default |
|---|---|---|
| Connection | The Domo connection to use. | |
| Account ID | The ID of the account. |
Delete Attachment
Permanently deletes an attachment from your task.
| Input | Comments | Default |
|---|---|---|
| Connection | The Domo connection to use. | |
| 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 | The Domo connection to use. | |
| DataSet ID | The ID of the DataSet. |
Delete Group
Permanently deletes a group from your Domo instance.
| Input | Comments | Default |
|---|---|---|
| Connection | The Domo connection to use. | |
| Group ID | The ID of the group to delete. |
Delete List
Permanently deletes a list from your Domo instance.
| Input | Comments | Default |
|---|---|---|
| Connection | The Domo connection to use. | |
| 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 | The Domo connection to use. | |
| Page ID | The ID of the page. |
Delete Project
Permanently deletes a project from your Domo instance.
| Input | Comments | Default |
|---|---|---|
| Connection | The Domo connection to use. | |
| 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 | The Domo connection to use. | |
| Stream ID | The ID of the Stream to delete. |
Delete User
Permanently deletes a user from your Domo instance.
| Input | Comments | Default |
|---|---|---|
| Connection | The Domo connection to use. | |
| User ID | The ID of the user. |
Download Attachment
Downloads an individual attachment given an attachment id.
| Input | Comments | Default |
|---|---|---|
| Connection | The Domo connection to use. | |
| 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 | The Domo connection to use. | |
| File Name | The filename of the exported CSV. | |
| Include Header | When true, includes table header in export. |
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 | The Domo connection to use. | |
| Account Type ID | The ID of the account type. |
Get Activity Log Entries
Retrieves activity log entries
| Input | Comments | Default |
|---|---|---|
| Connection | The Domo connection to use. | |
| Start | The start time in milliseconds of when you want to receive log events. | |
| End | The end time in milliseconds of when you want to receive log events. | |
| Limit | The maximum number of events to retrieve (default is 50, maximum of 1000). | |
| Offset | The offset location of events to retrieve (default is 0). | |
| User | The ID of the user. |
Get Data Set
Retrieves the details of an existing DataSet.
| Input | Comments | Default |
|---|---|---|
| Connection | The Domo connection to use. | |
| DataSet ID | The ID of the DataSet. |
Get Group
Retrieves the details of an existing group.
| Input | Comments | Default |
|---|---|---|
| Connection | The Domo connection to use. | |
| 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 | The Domo connection to use. | |
| 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 | The Domo connection to use. | |
| 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 | The Domo connection to use. | |
| 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 | The Domo connection to use. | |
| 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 | The Domo connection to use. | |
| Project ID | The ID of the project. |
Get Stream
Retrieves the details of an existing stream.
| Input | Comments | Default |
|---|---|---|
| Connection | The Domo connection to use. | |
| Stream ID | The id of the stream. | |
| Fields | Return desired fields: all, 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 | The Domo connection to use. | |
| 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 | The Domo connection to use. | |
| 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 | The Domo connection to use. | |
| 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 | The Domo connection to use. | |
| DataSet ID | The ID of the DataSet. | |
| CSV Body | The CSV data to import. |
List Accounts
Get a list of all Accounts for which the user has permissions.
| Input | Comments | Default |
|---|---|---|
| Connection | The Domo connection to use. | |
| 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 | The Domo connection to use. | |
| 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 (e.g., '-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 | The Domo connection to use. | |
| 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 | The Domo connection to use. | |
| 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 | The Domo connection to use. | |
| 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 | The Domo connection to use. | |
| 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 | The Domo connection to use. |
List Stream Execution
Returns all Stream Execution objects that meet argument criteria from original request.
| Input | Comments | Default |
|---|---|---|
| Connection | The Domo connection to use. | |
| 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 | The Domo connection to use. | |
| 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 | The Domo connection to use. | |
| 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 | The Domo connection to use. | |
| 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 | The Domo connection to use. | |
| 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 | The Domo connection to use. | |
| 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. This is used when 'Use Exponential Backoff' is disabled. | 0 |
| Retry On All Errors | If true, retries on all erroneous responses regardless of type. This is helpful when retrying after HTTP 429 or other 3xx or 4xx errors. Otherwise, only retries on HTTP 5xx and network errors. | false |
| Max Retry Count | The maximum number of retries to attempt. Specify 0 for no retries. | 0 |
| Use Exponential Backoff | Specifies whether to use a pre-defined exponential backoff strategy for retries. When enabled, 'Retry Delay (ms)' is ignored. | false |
Remove User From Group
Remove a user from a group in your Domo instance.
| Input | Comments | Default |
|---|---|---|
| Connection | The Domo connection to use. | |
| 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 | The Domo connection to use. | |
| Qualifiers | The search qualifiers to search by available qualifiers: dataSource.id or dataSource.owner.id. | |
| Fields | Return desired fields: all, id, dataset, updateMethod, createdAt, or modifiedAt. |
Share Account
Share an Account with a User.
| Input | Comments | Default |
|---|---|---|
| Connection | The Domo connection to use. | |
| 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 | The Domo connection to use. | |
| Account ID | The ID of the account to update. | |
| Update Account Body | The account object to update. |
Update Data Set
Updates the specified DataSet’s metadata by providing values to parameters passed.
| Input | Comments | Default |
|---|---|---|
| Connection | The Domo connection to use. | |
| DataSet ID | The ID of the DataSet. | |
| Update DataSet Body | The DataSet object to update. |
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 | The Domo connection to use. | |
| Group ID | The ID of the group. | |
| Update Group Body | The group object to update. |
Update List
Update the details of a list given an existing project id and list id.
| Input | Comments | Default |
|---|---|---|
| Connection | The Domo connection to use. | |
| 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 | The list object to update. |
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 | The Domo connection to use. | |
| Page ID | The ID of the page. | |
| Update Page Body | The page object to update. |
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 | The Domo connection to use. | |
| Project ID | The ID of the project. | |
| Update Project Body | The project object to update. | |
| 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 | The Domo connection to use. | |
| Project ID | The ID of the project. | |
| Update Project Members Body | Array of user IDs to assign as members of the project. |
Update Stream
Updates the specified Stream’s metadata by providing values to parameters passed.
| Input | Comments | Default |
|---|---|---|
| Connection | The Domo connection to use. | |
| Stream ID | The ID of the stream to update. | |
| Update Method | The data import behavior. | |
| Update Method Body | The update method configuration. |
Update Task
Update the details of a task given an existing project id, list id, and task id.
| Input | Comments | Default |
|---|---|---|
| Connection | The Domo connection to use. | |
| 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 in ISO 8601 format. | |
| 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 | The task object to update. |
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 | The Domo connection to use. | |
| 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 | The user object to update. |
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 | The Domo connection to use. | |
| 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. |