JSON data update and serialization
When working with JSON files in Robot Studio, you can:
- Parse and process a JSON schema.
- Create an empty .NET object based on the JSON schema.
- Populate the .NET object with data through automation.
- Serialize the .NET object back into a JSON file.
These actions help to ensure data consistency and facilitate integration with external data management systems by enhancing the flexibility of robotic solutions.
Creation of an empty .NET object
Using the JSONParser component, you can either build a .NET object from existing JSON data or create an empty object based on a JSON schema and populate it using robotic automation. When working with an empty schema that lacks example data, you must first validate it by using a JSON validator. Then, use the CreateEmptyObject method of the component to access and update the data within your automation.
For more information about instantiating objects in Robot Studio, see Creating empty .NET objects from JSON schemas.
JSON arrays
After you have the .NET object, you can easily add, update, or remove its elements in robotic automation. For example, a telecommunication company has introduced a new channel for customers to report network outages over the phone, in addition to the existing online form. The company maintains the claim database in JSON format to ensure data consistency. It has developed an automation that updates the JSON file based on the information provided by customer service representatives. This automation use the constructors and proxies created in earlier steps to generate the array and populate it with the relevant data, as shown in the following figure:
For more information about adding, updating, and deleting items in .NET objects, see Working with JSON arrays.
Serialization
After updating the necessary data in your automation using a .NET object, you can serialize it back into a JSON file that other applications or systems in your organization can use. To achieve serialization, use the SerializeObjectToFile method of the JSONParser component. This method creates a JSON file based on the modified data from your automation and saves it to the specified location. For more information about converting data in a .NET object to a JSON string, see Serializing .NET objects to JSON-based files.
Check your knowledge with the following interaction:
This Topic is available in the following Module:
If you are having problems with your training, please review the Pega Academy Support FAQs.
Want to help us improve this content?