Intro
JavaScript Object Notation (JSON) is a lightweight data-interchange format that is easy to use. The Domo JSON Easy Connector enables you to cut and paste from your JSON file into a text box and import your JSON data as a new Domo datasource. More advanced JSON uploads can be made using the Domo JSON Advanced Connector. JSON connector is capable of parsing any text that is in valid JSON format. JSON connector only accepts JSON text as input. If more advanced functionality is desired (for example, connection to FTP/SFTP server to fetch a JSON resource or connecting to HTTP/HTTPS JSON resource), refer to JSON Advanced connector. You can connect to your JSON Easy account in the Data Center. This topic discusses the fields and menus that are specific to the JSON Easy 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
No prerequisites are required to connect to your JSON Easy account and create a DataSet.Connecting to Your JSON Easy Account
No authentication is required for the JSON connector. This section enumerates the options in the Details panes in the JSON Easy 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 great detail in Adding a DataSet Using a Data Connector.Credentials Pane
No credentials are required to power up this connector. 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.Details Pane
Menu | Description |
|---|---|
Paste Your JSON Text Here | Copy JavaScript Object Notation (JSON) text from a file and paste into the provided text box. |
Does Your JSON Text Require A Line Reader? | Select ‘Yes’, if your JSON text includes consecutive ones that should be read. |
Should The Backlash Be Escaped? | Select ‘Yes’, if your JSON text has backslash characters that needs to escape. |
Do You Require Additional Options? | Select ‘Yes’, if you want to specify header tags, data tags or exclude specific fields. |
Enter Your Header Tag | Enter the tag for the header in your JSON text. |
Enter Your Data Tag | Enter the tag for the data in your JSON. |
Enter Fields To Exclude | Provides a comma separated list of fields you want to exclude from the JSON import. |