load form recognizer json in azure data factory

Shambhu Rai 1,406 Reputation points
2022-05-05T19:03:42.973+00:00

Hi Expert,

i got below mentioned form recognizer code and needs to load the data to azure data factory using notebook or transformatoin

{
"status": "success",
"pages": [
{
"number": 1,
"height": 841,
"width": 595,
"clusterId": 0,
"keyValuePairs": [
{
"key": [
{
"text": "XXXXX",
"boundingBox": [
415.3,
778.6,
564.5,
778.6,
564.5,
765.4,
415.3,
765.4
]
}
],
"value": []
},
{
"key": [
{
"text": "Abendmarkt 2",
"boundingBox": [
81.0,
681.3,
137.5,
681.3,
137.5,
672.6,
81.0,
672.6
]
}
],
"value": [
{
"text": "XXXX",
"boundingBox": [
80.7,
670.6,
151.1,
670.6,
151.1,
661.1,
80.7,
661.1
],
"confidence": 1.0
}
]
},
{
"key": [
{
"text": "Datum:",
"boundingBox": [
361.1,
635.0,
393.4,
635.0,
393.4,
625.5,
361.1,
625.5
]
}
],
"value": [
{
"text": "27.06.2019",
"boundingBox": [
489.5,
635.2,
539.0,
635.2,
539.0,
625.5,
489.5,
625.5
],
"confidence": 1.0
}
]
},

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,416 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,059 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,071 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 38,326 Reputation points Microsoft Employee
    2022-05-09T09:14:38.897+00:00

    Hi @Shambhu Rai ,

    Thank you for posting query in Microsoft Q&A Platform.

    If I understand correctly, You downloaded json from Form recognizer and now you are looking for ways to load that json to ADLS Gen2? If correct me If I am wrong with more details on your implementation and destination storage where you want to load data.

    If your data is json file you can consider using dataset with format type of json. You should consider creating a dataset for your source file and then creating a dataset for sink storage location and use both of them in copy activity.

    If you mean to say getting json from form recognise API as response and looking for ways to load that to sink storage using ADF, then you should consider using REST connector dataset as source and copy activity.

    Please check below link to know complete details of who to copy data from API using REST connector.
    Copy and transform data from and to a REST endpoint by using Azure Data Factory

    Hope this helps. Please let us know if any further queries.

    ---------------

    Please consider hitting Accept Answer. Accepted answers help community as well.