Azure AI Document Intelligence
An Azure service that turns documents into usable data. Previously known as Azure Form Recognizer.
2,079 questions
forms recognizer showing field in json but not in keyvalue pairs
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 52%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECC%3C/text%3E%3C/svg%3E)
Curtis Conner
1
Reputation point
I have a custom form that seems to do well with most forms except this one. Looking at the json output i can see the fields in question but the keyvalue pairs are coming up null even though i can see the output in the json file.
Below is a small sample from the json the complete is too large to copy
"LineItems": {
"type": "array",
"valueArray": [
{
"type": "object",
"valueObject": {
"LineNumber": {
"type": "string",
"valueString": "1",
"content": "1",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
0.6215,
3.9792,
0.6502,
3.9792,
0.6502,
4.0573,
0.6215,
4.0573
]
}
],
"confidence": 0,
"spans": [
{
"offset": 946,
"length": 1
}
]
},
"Qty": {
"type": "string",
"valueString": "1",
"content": "1",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
6.2008,
3.9792,
6.2295,
3.9792,
6.2295,
4.0573,
6.2008,
4.0573
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1045,
"length": 1
}
]
},
"Description": {
"type": "string",
"valueString": "SSV DEF 6X6 DPS 64 HD10",
"content": "SSV DEF 6X6 DPS 64 HD10",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
1.659,
3.9754,
2.7677,
3.9754,
2.7677,
4.1858,
1.659,
4.1858
]
}
],
"confidence": 0,
"spans": [
{
"offset": 958,
"length": 23
}
]
},
"Model": {
"type": "string",
"valueString": "0009VPA00",
"content": "0009VPA00",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
0.7916,
3.9775,
1.3762,
3.9775,
1.3762,
4.0593,
0.7916,
4.0593
]
}
],
"confidence": 0,
"spans": [
{
"offset": 948,
"length": 9
}
]
},
"Year": {
"type": "string",
"valueString": "23",
"content": "23",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
2.1689,
4.1056,
2.2858,
4.1056,
2.2858,
4.1858,
2.1689,
4.1858
]
}
],
"confidence": 0,
"spans": [
{
"offset": 985,
"length": 2
}
]
},
"Color": {
"type": "string",
"valueString": "GN",
"content": "GN",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
1.9738,
4.1019,
2.1267,
4.1019,
2.1267,
4.1858,
1.9738,
4.1858
]
}
],
"confidence": 0,
"spans": [
{
"offset": 982,
"length": 2
}
]
},
"FinanceProgram": {
"type": "string",
"valueString": "L1",
"content": "L1",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
3.3943,
3.9775,
3.4875,
3.9775,
3.4875,
4.0573,
3.3943,
4.0573
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1002,
"length": 2
}
]
},
"SerialNumber": {
"type": "string",
"valueString": "3JB6GAX45PK000697",
"content": "3JB6GAX45PK000697",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
1.6573,
4.7691,
2.7802,
4.7691,
2.7802,
4.8529,
1.6573,
4.8529
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1118,
"length": 17
}
]
},
"EngineNumber": {
"type": "string",
"valueString": "MP531188",
"content": "MP531188",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
1.6617,
4.9148,
2.1865,
4.9148,
2.1865,
4.9965,
1.6617,
4.9965
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1136,
"length": 8
}
]
},
"UnitAmount": {
"type": "string",
"valueString": "19,995.00",
"content": "19,995.00",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
9.8144,
3.9792,
10.2932,
3.9792,
10.2932,
4.0735,
9.8144,
4.0735
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1074,
"length": 9
}
]
}
},
"confidence": 0
},
{
"type": "object",
"valueObject": {
"LineNumber": {
"type": "string",
"valueString": "2",
"content": "2",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
0.6132,
5.0797,
0.6666,
5.0797,
0.6666,
5.1578,
0.6132,
5.1578
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1157,
"length": 1
}
]
},
"Qty": {
"type": "string",
"valueString": "1",
"content": "1",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
6.2008,
5.0797,
6.2295,
5.0797,
6.2295,
5.1578,
6.2008,
5.1578
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1257,
"length": 1
}
]
},
"Description": {
"type": "string",
"valueString": "SSV DEF MAX DPS 62 HD9",
"content": "SSV DEF MAX DPS 62 HD9",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
1.6578,
5.0759,
2.6548,
5.0759,
2.6548,
5.2863,
1.6578,
5.2863
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1169,
"length": 22
}
]
},
"Model": {
"type": "string",
"valueString": "0008RPD00",
"content": "0008RPD00",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
0.7916,
5.078,
1.3884,
5.078,
1.3884,
5.1598,
0.7916,
5.1598
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1159,
"length": 9
}
]
},
"Year": {
"type": "string",
"valueString": "23",
"content": "23",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
2.2431,
5.2062,
2.36,
5.2062,
2.36,
5.2863,
2.2431,
5.2863
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1195,
"length": 2
}
]
},
"Color": {
"type": "string",
"valueString": "BK",
"content": "BK",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
2.0693,
5.2045,
2.2089,
5.2045,
2.2089,
5.2843,
2.0693,
5.2843
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1192,
"length": 2
}
]
},
"FinanceProgram": {
"type": "string",
"valueString": "L1",
"content": "L1",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
3.3943,
5.078,
3.4875,
5.078,
3.4875,
5.1578,
3.3943,
5.1578
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1214,
"length": 2
}
]
},
"SerialNumber": {
"type": "string",
"valueString": "3JBUBAP42PK003210",
"content": "3JBUBAP42PK003210",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
1.6573,
5.8717,
2.7858,
5.8717,
2.7858,
5.9535,
1.6573,
5.9535
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1330,
"length": 17
}
]
},
"EngineNumber": {
"type": "string",
"valueString": "MP552723",
"content": "MP552723",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
1.6617,
6.0153,
2.1871,
6.0153,
2.1871,
6.097,
1.6617,
6.097
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1348,
"length": 8
}
]
},
"UnitAmount": {
"type": "string",
"valueString": "18,215.00",
"content": "18,215.00",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
9.8144,
5.0797,
10.2932,
5.0797,
10.2932,
5.174,
9.8144,
5.174
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1286,
"length": 9
}
]
}
},
"confidence": 0
},
{
"type": "object",
"valueObject": {
"LineNumber": {
"type": "string",
"valueString": "3",
"content": "3",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
0.6141,
6.1802,
0.6683,
6.1802,
0.6683,
6.2603,
0.6141,
6.2603
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1369,
"length": 1
}
]
},
"Qty": {
"type": "string",
"valueString": "1",
"content": "1",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
6.2008,
6.1802,
6.2295,
6.1802,
6.2295,
6.2583,
6.2008,
6.2583
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1464,
"length": 1
}
]
},
"Description": {
"type": "string",
"valueString": "SSV DEF MAX XT 62 HD9",
"content": "SSV DEF MAX XT 62 HD9",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
1.659,
6.1764,
2.7225,
6.1764,
2.7225,
6.3868,
1.659,
6.3868
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1381,
"length": 21
}
]
},
"Model": {
"type": "string",
"valueString": "0008SPD00",
"content": "0008SPD00",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
0.7916,
6.1764,
1.3823,
6.1764,
1.3823,
6.2603,
0.7916,
6.2603
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1371,
"length": 9
}
]
},
"Year": {
"type": "string",
"valueString": "23",
"content": "23",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
2.101,
6.3067,
2.2179,
6.3067,
2.2179,
6.3868,
2.101,
6.3868
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1406,
"length": 2
}
]
},
"Color": {
"type": "string",
"valueString": "GY",
"content": "GY",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
1.912,
6.3029,
2.0657,
6.3029,
2.0657,
6.3868,
1.912,
6.3868
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1403,
"length": 2
}
]
},
"FinanceProgram": {
"type": "string",
"valueString": "L1",
"content": "L1",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
3.3943,
6.1786,
3.4875,
6.1786,
3.4875,
6.2583,
3.3943,
6.2583
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1421,
"length": 2
}
]
},
"SerialNumber": {
"type": "string",
"valueString": "3JBUCAP45PK001738",
"content": "3JBUCAP45PK001738",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
1.6573,
6.9701,
2.7918,
6.9701,
2.7918,
7.054,
1.6573,
7.054
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1537,
"length": 17
}
]
},
"EngineNumber": {
"type": "string",
"valueString": "MP549737",
"content": "MP549737",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
1.6617,
7.1158,
2.1872,
7.1158,
2.1872,
7.1976,
1.6617,
7.1976
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1555,
"length": 8
}
]
},
"UnitAmount": {
"type": "string",
"valueString": "19,906.00",
"content": "19,906.00",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
9.8144,
6.1802,
10.2932,
6.1802,
10.2932,
6.2746,
9.8144,
6.2746
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1493,
"length": 9
}
]
}
},
"confidence": 0
},
{
"type": "object",
"valueObject": {
"LineNumber": {
"type": "string",
"valueString": "4",
"content": "4",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
0.6131,
7.2807,
0.6684,
7.2807,
0.6684,
7.3588,
0.6131,
7.3588
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1576,
"length": 1
}
]
},
"Qty": {
"type": "string",
"valueString": "1",
"content": "1",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
6.2008,
7.2807,
6.2295,
7.2807,
6.2295,
7.3588,
6.2008,
7.3588
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1673,
"length": 1
}
]
},
"Description": {
"type": "string",
"valueString": "SSV DEF 6X6 XT 64 HD10",
"content": "SSV DEF 6X6 XT 64 HD10",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
1.659,
7.277,
2.6812,
7.277,
2.6812,
7.4873,
1.659,
7.4873
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1588,
"length": 22
}
]
},
"Model": {
"type": "string",
"valueString": "0009RPA00",
"content": "0009RPA00",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
0.7916,
7.2791,
1.3823,
7.2791,
1.3823,
7.3608,
0.7916,
7.3608
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1578,
"length": 9
}
]
},
"Year": {
"type": "string",
"valueString": "23",
"content": "23",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
2.1504,
7.4072,
2.2673,
7.4072,
2.2673,
7.4873,
2.1504,
7.4873
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1614,
"length": 2
}
]
},
"Color": {
"type": "string",
"valueString": "BE",
"content": "BE",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
1.9767,
7.4055,
2.1073,
7.4055,
2.1073,
7.4853,
1.9767,
7.4853
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1611,
"length": 2
}
]
},
"FinanceProgram": {
"type": "string",
"valueString": "L1",
"content": "L1",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
3.3943,
7.2791,
3.4875,
7.2791,
3.4875,
7.3588,
3.3943,
7.3588
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1630,
"length": 2
}
]
},
"UnitAmount": {
"type": "string",
"valueString": "22,665.00",
"content": "22,665.00",
"boundingRegions": [
{
"pageNumber": 1,
"polygon": [
9.806,
7.2807,
10.2932,
7.2807,
10.2932,
7.3751,
9.806,
7.3751
]
}
],
"confidence": 0,
"spans": [
{
"offset": 1702,
"length": 9
}
]
}
},
"confidence": 0
},
{
"type": "object",
"valueObject": {
"SerialNumber": {
"type": "string",
"valueString": "3JB6KAX44PK000415",
"content": "3JB6KAX44PK000415",
"boundingRegions": [
{
"pageNumber": 2,
"polygon": [
1.6573,
4.1019,
2.7669,
4.1019,
2.7669,
4.1837,
1.6573,
4.1837
]
}
],
"confidence": 0,
"spans": [
{
"offset": 2688,
"length": 17
}
]
},
"EngineNumber": {
"type": "string",
"valueString": "MP534693",
"content": "MP534693",
"boundingRegions": [
{
"pageNumber": 2,
"polygon": [
1.6617,
4.2455,
2.1871,
4.2455,
2.1871,
4.3272,
1.6617,
4.3272
]
}
],
"confidence": 0,
"spans": [
{
"offset": 2706,
"length": 8
}
]
}
},
"confidence": 0
}
],
"confidence": 0
},
"FinanceProgram": {
"type": "string",
"confidence": 0.8
},
"PoNumber": {
"type": "string",
"confidence": 0.873
},
"MfgNumber": {
"type": "string",
"confidence": 0.961
},
"FreeFlooringEndDate": {
"type": "string",
"confidence": 0.954
}
},
"confidence": 0.987,
"spans": [
{
"offset": 0,
"length": 11776
}
]
}
]
Notice the last 2 item in the array, the information is there correctly but when i display them in the training window i see blank for some field
See line 4 and 5, they are blank but in the json i see the values, what am i miss understanding
Azure AI Document Intelligence
{count} votes
-
romungi-MSFT 48,886 Reputation points Microsoft Employee Moderator2023-05-31T09:16:01.3333333+00:00 @Curtis Conner I think the response contains the Serial number "3JB6KAX44PK000415" but if you look at the page number it seems to recognize the same in page 2 and there is no line number in the result.
{ "type": "object", "valueObject": { "SerialNumber": { "type": "string", "valueString": "3JB6KAX44PK000415", "content": "3JB6KAX44PK000415", "boundingRegions": [ { "pageNumber": 2,Earlier results have the line number in the response object first and then the subsequent value objects.
{ "type": "object", "valueObject": { "LineNumber": { "type": "string", "valueString": "4", "content": "4", "boundingRegions": [ { "pageNumber": 1,I think this might be causing your display to be incorrect or as per the response received. If the original image or form has some alignment issues, then I think the analyze operation could have been affected. Try to compare the similar images and check if there is any discrepancy in this one. Thanks!!
-
Curtis Conner 1 Reputation point
2023-05-31T09:27:05.1333333+00:00 That could explain the last entry but not the 2nd to the last, all items are exactly the same as 1-3 and its missing data from that item in the keypair.
This is strange i see this work for many forms but just not this one
any ideas
Sign in to comment
Sign in to answer