JSON 패키지

The JSON 패키지 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 패키지 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 패키지

Use the 작업 in the JSON 패키지 in the following order:
  1. Start the JSON session using the Start session 작업. Use this session name for all corresponding 작업.
  2. Use the different 작업 available in the JSON package to automate JSON related tasks.
  3. End the session using the End session 작업 to complete a task.

작업 in the JSON 패키지

The JSON 패키지 includes the following 작업:
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.

macOS에서의 애플리케이션 권한

작업 Description
Start session Start a new JSON session based on the specified JSON data source. See JSON에서 세션 시작 작업.
Add node value Add a new node to the JSON specified in Start session data source. See 노드 값 추가.
Convert Dictionary to JSON Converts the content of a Dictionary variable to JSON format. See 사전을 JSON으로 변환.
Convert JSON to Dictionary Extract the contents of the JSON data source to a Dictionary variable. See JSON을 사전으로 변환.
Get node list Retrieves the list of nodes for a node path. See 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 JSON에서 노드 값 가져오기 작업.
Update node value Update the value of a node in the JSON data source. See 노드 값 업데이트.
Validate Validates the syntax, structure, and schema of the JSON data source. See Validate action
End session Closes a JSON session. See JSON의 세션 종료 작업.

More resources