forms recognizer showing field in json but not in keyvalue pairs

Curtis Conner 1 Reputation point
2023-05-31T03:05:08.3766667+00:00

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

Screenshot 2023-05-31 at 10.03.46 AM

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
Azure AI Document Intelligence
An Azure service that turns documents into usable data. Previously known as Azure Form Recognizer.
1,523 questions
{count} votes