JSON paquete

The JSON paquete enables you to extract and parse information from JSON data sources. It allows you to manipulate the JSON data, such as adding or updating values within a JSON string, parsing JSON strings into objects using node path, and converting JSON strings to dictionaries and vice versa.

JSON paquete plays a crucial role in seamlessly integrating automation workflows with web services and APIs that use JSON for data exchange.

Benefits

  • JavaScript Object Notation (JSON) is a lightweight, easy-to-understand, extensible format for storing, transporting, and retrieving data. JSON uses key-value pairs of data and delivers faster data interchange and web service results.
  • Most REST Web Services (APIs), some configuration files, and many NoSQL databases such as MongoDB commonly use JSON because of its flexible format for data exchange. It is text-based, lightweight, and has an easy-to-parse data format, which means it requires no additional code to understand and interpret the provided data.
  • JSON files can be great for storing and retrieving configuration data your automation might reference when determining server, environment-specific, or folder-share details.
  • JSON's flexible structure efficiently accommodates various data types and complex data hierarchies.

JSON data types

The values in JSON must be of following data type:
  • Strings
  • Numbers
  • Object (JSON Object)
  • Array
  • Booleans
Note: The value NULL is not supported in Automation 360. Therefore, when you extract JSON data and convert it to a dictionary variable, any null values in the JSON string are not converted, as dictionary variables do not support null values. However, if the JSON contains an empty string ("") instead of null, it will be successfully converted to a dictionary variable.

Understanding JSON structures

In JSON, data is mainly stored in two structures:
  • Objects: Objects in JSON are collections of key, value pairs enclosed in curly braces {}. Each key is a string enclosed with quotes (““) followed by a colon (:) , and commas (,) are used to separate the key, value pairs.
    Example: 
    {"name ": "John", "age": "30", "city": Detroit}
  • Arrays: Arrays are ordered lists of values, enclosed in square brackets []. Values within an array are separated by commas (,).
    Example: 
    ["John", "Annie", "Shane"]

Using JSON paquete

Use the acciones in the JSON paquete in the following order:
  1. Start the JSON session using the Start session acción. Use this session name for all corresponding acciones.
  2. Use the different acciones available in the JSON package to automate JSON related tasks.
  3. End the session using the End session acción to complete a task.

Acciones in the JSON paquete

The JSON paquete includes the following acciones:
Note: When you create an automation on the macOS platform, a confirmation window prompts you to grant app permissions in macOS. See this topic for a list of prompt messages and instructions on managing app permissions.

Permisos de aplicaciones en macOS

Acción Description
Start session Start a new JSON session based on the specified JSON data source. See acción Iniciar sesión en JSON.
Add node value Add a new node to the JSON specified in Start session data source. See Agregar valor de nodo.
Convert Dictionary to JSON Converts the content of a Dictionary variable to JSON format. See Convertir diccionario a JSON.
Convert JSON to Dictionary Extract the contents of the JSON data source to a Dictionary variable. See Convertir JSON a diccionario.
Get node list Retrieves the list of nodes for a node path. See Obtener lista de nodos acción en JSON.
Get nodes Extracts the key values from the JSON source. See Get nodes in JSON
Get node value Retrieves the value of a node from the JSON source. See acción Obtener el valor del nodo en JSON.
Update node value Update the value of a node in the JSON data source. See Actualizar valor del nodo.
Validate Validates the syntax, structure, and schema of the JSON data source. See Validate action
End session Closes a JSON session. See Finalizar sesión acción en JSON.

More resources