JSON Connector

Intro

The Domo JSON Connector allows you to access JSON files that have been uploaded to an SFTP server. You can import files using HTTP and HTTPS calls. Domo supports the integration of JSON data with other datasets to provide comprehensive, real-time business insights. The platform enables users to merge diverse data sources, ensuring a single version of the truth for all business analysis. This real-time data integration expedites reporting, allowing for immediate report generation and improving team collaboration on actionable insights.

You can connect to your JSON account in the Data Center. This topic discusses the fields and menus that are specific to the JSON connector user interface. To add DataSets, set update schedules, and edit DataSet information, see Adding a DataSet Using a Connector.

Prerequisites

To connect to your JSON account and create a DataSet, you need the following:

• Connection Scheme
• Host/ Domain name

Connecting to Your JSON Account

This section enumerates the options in the Credentials and Details panes on the JSON Connector page. The components of the other panes on this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in great detail in Adding a DataSet Using a Connector.

Credentials Pane

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

Field	Description
Connection Scheme	Select the connection method of the JSON file you want to fetch. - HTTP (HTTP Request) - HTTPS (Secure HTTP Request) - SFTP (Secure File Transfer)
Host/Domain	Enter the host/domain name where your JSON files are located. Example: files.myhost.com or an IP address, such as 121.123.123.123
Port	Enter the port number for the SFTP or HTTP connection. If you leave it blank, the default port will be used. - Port 80: HTTP - **Port 443:**HTTPS - Port 22: SFTP
Username	Enter the username for the server where the JSON file is located.
Password	Enter the password for the server where the JSON file is located.

Once you have entered valid JSON credentials, you can use the same account at any time to create a new JSON DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Manage Connector Accounts.

Details Pane

Menu	Description
PATH to JSON file	Enter the complete URL of the JSON file from where you want to fetch the JSON data. Example home/test/file.json.
Specify header and data tag	Select Yes if you want to specify a header tag and a data tag.
Header tag	Enter the tag for the header in your JSON text. This tag should be an array of column names.
Data tag	Enter the tag that contains the data you want to import. If the tag is a header, the data should be in an array of arrays.

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