Skip to main content
Skip table of contents

Domo - Upload File as Dataset from Workflows

Overview

Create a Domo dataset by uploading a csv to Domo. If the `Domo Dataset Name` already exists in Domo (and there are not multiple datasets with the same name), the CSV file will replace the existing dataset; otherwise a new one will be created. This will create a static dataset that can be updated by reusing this blueprint.

Variables

NameReferenceTypeRequiredDefaultOptionsDescription
Client IDDOMO_CLIENT_IDPasswordNone-Client ID is generated in the Domo Developer Portal. The ID should have the following scope: data, workflow, user, account, dashboard
Secret KeyDOMO_SECRET_KEYPasswordNone-The secret attached to the generated Client ID
Workflows Folder NameDOMO_FOLDER_NAMEAlphanumericNone-The Workflows folder name where the file is contained
Workflows File to LoadDOMO_FILEAlphanumericNone-The name of the csv file that you would like to load into Domo
Domo Dataset NameDOMO_DATASET_NAMEAlphanumericNone-The name of that the dataset will be given in Domo
Domo Dataset DescriptionDOMO_DATASET_DESCRIPTIONAlphanumericNone-Optional description of the dataset
Schema in DomoDOMO_SCHEMAAlphanumericNone-The Domo data types of the dataset that is to be loaded. This is an optional argument, and is only recommended if the number of columns and types is known beforehand. If left blank, the data types will be inferred by sampling the entire dataset.
Insert MethodDOMO_INSERT_METHODSelectREPLACEReplace: REPLACE

Append: APPEND
The option to replace the entire data set with new data, or add to the existing rows
Dataset IdDOMO_DATASET_IDAlphanumericNone-The ID associated with the desired dataset. This is only necessary if modifying an existing dataset, not creating a new one.
File Name Match TypeFILE_NAME_MATCH_TYPESelectexact_matchExact Match: exact_match

Regex Match: regex_match

YAML

Below is the YAML template

YAML

source:
  template: Domo - Upload File as Dataset from Workflows
  inputs:
    DOMO_CLIENT_ID:
    DOMO_SECRET_KEY:
    DOMO_FOLDER_NAME:
    DOMO_FILE:
    DOMO_DATASET_NAME:
    DOMO_DATASET_DESCRIPTION:
    DOMO_SCHEMA:
    DOMO_INSERT_METHOD: REPLACE
    DOMO_DATASET_ID:
    FILE_NAME_MATCH_TYPE: exact_match
  type: TEMPLATE
guardrails:
  retry_count: 1
  retry_wait: 0h0m0s
  runtime_cutoff: 1h0m0s
  exclude_exit_code_ranges:
    - 101
    - 107
    - 108
    - 109
    - 114
    - 115
    - 116

      
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.