Unstructured Data while using MS Document Intelligence API

Question

Dear Forum Members,

I am using the Microsoft Document Intelligence (Invoice) pretrained model by calling through API in UiPath by using HTTP request. Now, the output is in JSON format. For that, I am using Deserialize JSON. And data I am getting is in unstructured format. I have checked in Microsoft Azure as well. On UI, it looks fine but in the Result tab, JSON looks unstructured. For example: Vendor Name\nABC\nInvoice Date\nInvoice No\n03-Oct-2023\n567890. In this case, when I am trying to extract Invoice No, it is giving me 03-Oct-2023. Is there any way that I could Deserialize and I could get proper data.

Thanks

Answer 1

Hi @Dimple Khurana

Thank you for reaching out to the Microsoft Q&A community forum.

Based on your query, it seems that the unstructured format of the JSON data is causing issues while extracting the required data.

I tried to repro this issue at my end by using the POSTMAN. See below:

POST Request: GET Request using the operation-Location URL above.

SELECTED "RAW" tab in outputs. See below.

Selected "Pretty" tab, that helped beautify and formatting JSON.

One possible reason for the unstructured format could be the RAW format of the JSON data. You can try using the "Pretty" format to beautify the JSON data and make it more structured.

Regarding your question on how to deserialize, please use libraries such as JSON.NET for .NET and json module for Python to deserialize the JSON data into a structured format, if you would like to perform this programmatically.

import json 
# Deserialize the JSON data into a dictionary 
data = json.loads(json_data)

For more information on Microsoft Document Intelligence API and JSON deserialization libraries, please refer to the following links:

• Microsoft Document Intelligence API: https://docs.microsoft.com/en-us/azure/cognitive-services/document-understanding/
• JSON.NET library for .NET: https://www.newtonsoft.com/json
• json module for Python: https://docs.python.org/3/library/json.html

I hope you understand, and the provided details helps in debugging and resolving your issue.

Thank you.

---

If this answer is helpful, please click on or upvote which might help other community members reading this thread.