Handling JSON FAQs

Get answers to frequently asked JSON handling questions.

What is JSON, and why is it important in the context of Workato?

JSON (JavaScript Object Notation) is a data syntax used for storing and exchanging data. It is a popular and widely used format in the world of APIs. JSON is based on name/value pairs and arrays, making it highly readable and easily transmitted. In Workato, JSON is essential for handling data within recipes.

How does Workato typically handle JSON data?

Workato exposes JSON data as input fields and output datapills in recipes, making JSON mostly transparent to regular users. However, you may occasionally handle raw JSON data in specific workflow automation.

What is an example of JSON data?

The following JSON data example represents an array of contacts:

[
  {
    "Name" : {
      "first_name" : "Sally",
      "last_name" : "Jones"
    },
    "Address": {
      "street" : "20450 Stevens Creek Blvd #150",
      "city" : "Cupertino",
      "st" : "CA",
      "postal": "95014"
    },
    "phone" : "4105554119"
  },
  {
    "Name" : {
      "first_name" : "Bob",
      "last_name" : "Towner"
    },
    "Address": {
      "street" : "1 Hacker Way",
      "city" : "Menlo Park",
      "st" : "CA",
      "postal": "94025"
    },
    "phone" : "8552982507"
  }
]

How can I parse JSON data in Workato?

The easiest way to convert raw JSON content into usable datapills is to use the built-in JSON parser by Workato. This native application does not require any connection setup and simplifies the parsing process.

What are the input fields for the JSON parser in Workato?

Input fields for the JSON parser are:

• Sample document: A sample JSON with the same format as the JSON document to be parsed.
• Document: The input JSON content to be parsed.

What can I expect as the output of the JSON parser in Workato?

Datapills are generated based on the JSON format in the Sample document. For example, if your JSON contains an array with nested objects like name and address, the output includes corresponding datapills.

Are there alternatives to the built-in JSON parser for handling JSON data?

Yes. If you frequently work with raw JSON data, we recommend that you consider more permanent solutions, such as custom connectors. Workato offers two primary options:

• HTTP connector: This is a convenient way to handle raw data from APIs. You can build HTTP triggers and actions to manage JSON data.

• Workato Connector SDK: This extension of the Workato framework supports various authentication procedures and allows developers to build, maintain, and distribute connectors to integration-seekers.