Use the DeserializeObject component
Convert a string containing JSON data to a JSON object by using the DeserializeObject component in RPA Desktop Design Studio. You can also extract specific properties from the JSON object.
Antes de Iniciar
Role required: none
Por Que e Quando Desempenhar Esta Tarefa
To configure the properties for the DeserializeObject component, see Properties of the JSON utilities.
Procedimento
Convert a string to a JSON object
In this example, the ReadFromExcel component reads data from an Excel document and passes to the SerializeObject component. The SerializeObject component converts the data to string and passes to the DeserializeObject component. The DeserializeObject component converts the string to the JSON object. The items in the Excel document traverses from first to last in the For Each component and passes the item to the GetProperties component. The GetProperties component returns the name of the component and passes the name of the item to the Show component. The item is shown in a message box.