RPA Quick Tips with Micah Smith: Handling JSON Using the JSON Object Manager Package

Introduction

In this tutorial, we will explore how to effectively use the JSON Object Manager package from Automation Anywhere's Bot Store. This package is essential for handling REST Web Services and parsing JSON responses. We will cover reading from a JSON file, reading from a JSON array, and updating values within a JSON structure. Whether you're a beginner or looking to enhance your RPA skills, this guide will provide you with practical tips and clear instructions.

Step 1: Setting Up the JSON Object Manager Package

1. Access the Bot Store

   • Go to the Automation Anywhere Bot Store.
   • Search for the "JSON Object Manager Package."
   • Download and install the package following the provided instructions.

2. Set Up Your Environment

   • Make sure you have a working Automation Anywhere environment.
   • Ensure you have access to the JSON file you will be working with. You can use the sample JSON file available at Employees.json.

Step 2: Reading from a JSON File

1. Load the JSON File

   • Use the JSON Object Manager to load your JSON file.
   • In your bot, select the action to read a JSON file and specify the path to your Employees.json file.

2. Extract Data

   • Choose the specific data points you want to extract from the JSON.
   • Use the appropriate methods from the JSON Object Manager to access these data points.

Step 3: Reading from a JSON Array

1. Identify the JSON Array

   • Locate the array within your JSON structure that you want to work with. For example, if your JSON contains an "employees" array, make a note of its structure.

2. Loop Through the Array

   • Implement a loop in your bot to iterate through each item in the JSON array.
   • Use the JSON Object Manager's methods to access and process each item in the array.

Step 4: Updating Values in a JSON

1. Select the Value to Update

   • Identify the specific key-value pair you want to change within your JSON structure.
   • Use the JSON Object Manager to target this key.

2. Modify the Value

   • Apply the update using the appropriate method from the JSON Object Manager.
   • Ensure that the data type of the new value matches the original.

3. Save the Updated JSON

   • After making the changes, save the updated JSON back to a file or to a variable for further use.

Conclusion

In this tutorial, we covered the essential steps for using the JSON Object Manager package in Automation Anywhere. You learned how to set up the package, read from JSON files and arrays, and update JSON values. By mastering these techniques, you can streamline your RPA processes when dealing with JSON data. For further learning, consider exploring more features of the JSON Object Manager or other packages available in the Bot Store. Happy automating!