load form recognizer json in azure data factory

Question

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
}
]
},

Answer 1

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.