> ## Documentation Index
> Fetch the complete documentation index at: https://domoinc-openapi-sync-dataflows.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# 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](https://domo-support.domo.com/s/article/360042926274?language=en_US "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](https://domo-support.domo.com/s/article/360042926274?language=en_US "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:

<table border="1" cellpadding="1" cellspacing="1" data-aura-rendered-by="33:195;a"><thead><tr><th colspan="1" rowspan="1"><p><span class="s1"> Field </span></p></th><th colspan="1" rowspan="1"><p><span class="s1"> Description </span></p></th></tr></thead><tbody><tr><td colspan="1" rowspan="1"> Connection Scheme </td><td colspan="1" rowspan="1"><p> Select the connection method of the JSON file you want to fetch. </p><ul><li> HTTP (HTTP Request) </li><li> HTTPS (Secure HTTP Request) </li><li> SFTP (Secure File Transfer) </li></ul></td></tr><tr><td colspan="1" rowspan="1"> Host/Domain </td><td colspan="1" rowspan="1"><p> Enter the host/domain name where your JSON files are located. </p><p> Example: <a href="http://files.myhost.com" rel="noopener" target="_blank"> files.myhost.com </a> or an IP address, such as 121.123.123.123 </p></td></tr><tr><td colspan="1" rowspan="1"> Port </td><td colspan="1" rowspan="1"><p> Enter the port number for the SFTP or HTTP connection. If you leave it blank, the default port will be used. </p><ul><li><b> Port 80: </b> HTTP </li><li><b> Port 443: </b> HTTPS </li><li><b> Port 22: </b> SFTP </li></ul></td></tr><tr><td colspan="1" rowspan="1"> Username </td><td colspan="1" rowspan="1"><p> Enter the username for the server where the JSON file is located. </p></td></tr><tr><td colspan="1" rowspan="1"> Password </td><td colspan="1" rowspan="1"><p> Enter the password for the server where the JSON file is located. </p></td></tr></tbody></table>

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](https://domo-support.domo.com/s/article/360042926054?language=en_US "Manage Connector Accounts").

## Details Pane

<table border="1" cellpadding="1" cellspacing="1" data-aura-rendered-by="33:195;a"><thead><tr><th colspan="1" rowspan="1"><p> Menu </p></th><th colspan="1" rowspan="1"><p> Description </p></th></tr></thead><tbody><tr><td colspan="1" rowspan="1"><p> PATH to JSON file </p></td><td colspan="1" rowspan="1"><p> Enter the complete URL of the JSON file from where you want to fetch the JSON data. <b> Example </b> home/test/file.json. </p></td></tr><tr><td colspan="1" rowspan="1"> Specify header and data tag </td><td colspan="1" rowspan="1"> Select <b> Yes </b> if you want to specify a header tag and a data tag. </td></tr><tr><td colspan="1" rowspan="1"> Header tag </td><td colspan="1" rowspan="1"> Enter the tag for the header in your JSON text. This tag should be an array of column names. </td></tr><tr><td colspan="1" rowspan="1"> Data tag </td><td colspan="1" rowspan="1"> 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. </td></tr></tbody></table>

## 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](https://domo-support.domo.com/s/article/360042926274?language=en_US "Adding a DataSet Using a Connector").
