@Jeevitha Venkatraj,

There is a slight misunderstanding here, let me clarify.

In a structured output, or even in an agent response, the data is returned in JSON format. But what is JSON in the end? It is still text.

For example, if an agent returns:

[

  {

    "id": 1,

    "name": "Jeevitha",

    "email": "Jeevitha@example.com",

    "isActive": true

  },

  {

    "id": 2,

    "name": "Test",

    "email": "Test@example.com",

    "isActive": false

  }

]

This is clearly a list in structure, but inside your application, the data type is still Text. It only appears as a list in the UI.

This is exactly where the deserialization process comes in.

In summary, the AI agent always generates text-based output in the form of JSON. Even when it looks structured, it is still serialized text. It is up to you to deserialize this response into a proper List or Structure based on your requirements.

In ODC, when you define a Structure that matches the JSON and use it in the Agent’s structured output, the agent can automatically map the response to that Structure. In this case, you don’t need to manually deserialize because ODC already handles it for you.

However, if you use the default response from the AI model, then the output is just Text in JSON format. In that case, you will need to manually deserialize it into a List or Structure to use it properly.

So it depends on how you are consuming the response. If you rely on structured output with a defined schema, The Agent helps you avoid manual deserialization and maps it automatically for you. If you treat the response as plain text, then deserialization becomes your responsibility, and as a result you can map it to a list and use it as needed.

Thanks @Sherif El-Habibi for the clear explanation. Yes, currently the Output is text based in the form of JSON. Any suggestion to convert the JSON to Table format i.e list with seperate rows and columns. 

Using delimiter and list append action, I think we can convert the JSON text to list with seperate rows but need to get the list which is ready to download as excel format. 

Hi,

You can create a structure named Agent_Output with attributes defined as lists and use it as your structured output. 

Then, use JSONSerialize to generate the JSON, and JSONDeserialize to convert it back into a structured format for further processing or usage. 

Serialize:

Deserialize:

You can create a structure named Agent_Output with attributes defined as lists and use it as your structured output. 

Thank you @Sherif El-Habibi and @Mihai Melencu . I got the solution.