Create Json input Schema and Json Output Schema

Hi Forum,

I have a sample excel which contains of two sheets input, output using this i need to generate Input jsonschema definition and output jsonschema definition.

The outputjson schema definition need to extract the transaction status and Exception for all successful or failed queue items.

Can anyone help me on this.
Thx in advance.
Sample.xlsx (9.4 KB)

1 Like

Hey @Ganesh_Preetham_Kopparapu,

Kindly refer this link : Auxiliobits - DataTable To JSON String - RPA Component | UiPath Marketplace

This is a custom activity which takes data in form of DataTable and convert that into Json format.

Sorry @urvesh.mistry. I need to extract completed transaction data from the queue. Using API

1 Like

Hello Ganesh,
In this video I do a lot of stuff with JSON (Chapter included) :

0:45 Install Deserialize JSON
1:10 Present all types of JSON that will use
1:35 Deserialize simple JSON
2:50 Deserialize a JSON with an Object inside
3:55 Deserialize a JSON with Array inside
6:00 When we use Deserialize JSON Array activity
7:00 Deserialize a JSON with a List of Strings inside
9:45 Create a simple JSON
11:05 Create a JSON with an Object inside
12:17 Create a JSON with Array inside
14:05 Create a JSON with a List of Strings inside
15:55 Datatable to JSON
17:50 JSON to Datatable

Cristian Negulescu

@Cristian_Negulescu Thanks for sharing this could be help me but i would like to have an idea about input schema and output schema for the Queue. For the reference see below screenshot!