Skip to main content
waffle.svg
Domo Knowledge Base

No-Code JSON Connector

Version 2

 

Intro

Use the No-Code JSON Connector to pull your custom data into Domo just by following the steps in a simple wizard interface. The wizard will help you connect to your data as a JSON file and pull it into Domo. This connector is perfect for anyone who wants to create a connection for custom data without going through a Domo engagement but doesn't have the coding experience to build connectors using Domo's API or Connector IDE. 

You connect to your custom JSON data in the Data Center. This topic discusses the fields and menus that are specific to the No-Code JSON 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.

Prerequisites

To connect to your custom JSON data and create a DataSet, you must have the following:

  • A client ID and client secret from developer.domo.com

  • An authorization URL and access token URL from your data provider

  • The URL to access the JSON file

To obtain your Domo client ID and client secret, do the following:

  1. Log into your Domo developer account at https://developer.domo.com/login

  2. Create a new client

  3. Select the desired data and user application scope.

  4. Click Create.

Connecting to your custom data

This section enumerates the options in the CredentialsData Selection, and Parsing panes in the No-Code JSON Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.

Credentials Pane

This pane contains fields for entering credentials to connect to your custom data. The following table describes what is needed for each field:  

Field

Description

Account Name (Optional)

Enter a name for your account.

Client ID

Enter your Domo client ID. For information about obtaining this ID, see "Prerequisites," above.

Client Secret

Enter your Domo client secret. For information about obtaining this ID, see "Prerequisites," above.

Authorization URL

Enter the authorization URL from your data provider.

Access Token URL

Enter the access token URL from your data provider.

Scopes (Optional)

Enter the scopes required for this connection. Separate multiple scopes with spaces.

State Type

Select the state type required by your OAuth.

State Location

Select whether to send the state as a query parameter or as part of the path.

Response Type

Select whether to use code or a token with the authorization URL.

Once you have entered valid credentials, you can use the same account any time you go to create a new No-Code JSON DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors.

Data Selection pane

In this pane, you specify the HTTP method to use to connect, the URL of the JSON file, and other configuration settings.

Menu Description
Choose the HTTP Method to use If HTTP Request is selected as the Connection Type, choose from either GET or POST as the HTTP method.
Enter the URL to your JSON file Enter the URL of your JSON file.
How will you provide the certificate

If HTTP Request is selected as the  Connection Type, choose the method in which the certificate will be provided:

  • No certificate

  • URL Path to the Certificate

  • Certificate Content

Advanced Settings

Menu Description
HTTPS Headers Enter the Key and Value of the HTTPS Headers. This option is only available for the HTTP Request Connection Type.
Query Parameters Enter the Key and Value of the Query Parameters. This option is only available for the HTTP Request Connection Type.
Date Query Parameters Select No Date Filter, Single Date, or Date Range as the Date Query Parameter. This option is only available for the HTTP Request Connection Type.
JSON Settings Specify whether your JSON text requires a line reader and if the backslash character should be escaped.

Parsing

Pagination

Select how to paginate the data:

  • No Paging

  • Get next URL from results

  • Get next page token from results

  • Offset by records

  • Offset by pages

Parsing

Using the data preview, you can click on a column to format the data for parsing.

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.

FAQ

How often can the data be updated?

DataSets can run as often as every 15 minutes.

Does this connector support paging?

Yes. In order to activate paging, select the paging type supported by your API and fill out the requested details.

How do I parse my data?

Select the column containing the data you want to expand or modify in the Parsing tab of the Parsing Pane. Hover over the suggested actions to see the effect and select the desired action by clicking on it. Repeat until the data looks the way you want it to look. Use the history section on the right to undo actions if desired.