I’m trying to extract item table from invoice using amazon textract. I used Analyze single page document activity & i get pageDetailCollection type variable which contains Json like data but not JSON. So how can i convert pageDetailCollection into datatable.
@Anil_G @Yoichi @Sudharsan_Ka @supermanPunch
I got respone like this -
PageDetail { ConfidenceScores=null, FormFields=FormFieldCollection { AvgConfidence=62.57, HighConfidence=86.89, Items=FormField[41] { FormField { Confidence=86.89, Name=“Place of Supply :”, Value=“MAHARASHTRA” }, FormField { Confidence=85.9, Name=“Customer Code :”, Value=“CUS4298674” }, FormField { Confidence=85.79, Name=“Phone No. :”, Value=“9922007844” }, FormField { Confidence=85.71, Name=“Customer Name :”, Value=“SHARVARI ENTERPRISES” }, FormField { Confidence=85.39, Name=“State Code :”, Value=“27” }, FormField { Confidence=83.81, Name=“GSTIN :”, Value=“27AVGPM6954J1Z0” }, FormField { Confidence=83.43, Name=“Invoice No. :”, Value=“CSRBAC1240000661” }, FormField { Confidence=83.31, Name=“PAN No. :”, Value=“” }, Line { Confidence=99.91, Text=“Invoice Details” }, Line { Confidence=99.72, Text=“Customer Code” }, Line { Confidence=97.45, Text=“: CUS4298674” }, Line { Confidence=99.78, Text=“Invoice Status” }, Line { Confidence=96.77, Text=“: NEW” }, Line { Confidence=99.79, Text=“Customer Name” }, Line { Confidence=93.78, Text=“:” }, Line { Confidence=99.49, Text=“SHARVARI ENTERPRISES” }, Line { Confidence=99.83, Text=“Invoice No.” }, Line { Confidence=96.26, Text=“: CSRBAC1240000661” }, Line { Confidence=99.93, Text=“GSTIN” }, Line { Confidence=93.2, Text=“: 27AVGPM6954J1Z0” }, Line { Confidence=99.88, Text=“Invoice Date” }, Line { Confidence=97.02, Text=“: 18/08/2023” }, Line { Confidence=99.86, Text=“Bill To” }, Line { Confidence=96.73, Text=“:” }, Line { Confidence=98.97, Text=“4, GONVADI, KHED, PUNE PUNE MAHARASHTRA” }, Line { Confidence=99.91, Text=“Ship To” }, Line { Confidence=98.4, Text=“: 4, GONVADI, KHED, PUNE PUNE” }, Line { Confidence=99.94, Text=“410501” }, Line { Confidence=99.61, Text=“MAHARASHTRA 410501” }, Line { Confidence=99.91, Text=“Place of Supply” }, Line { Confidence=97.18, Text=“: MAHARASHTRA” }, Line { Confidence=99.94, Text=“State” }, Line { Confidence=97.64, Text=“: MAHARASHTRA” }, Line { Confidence=99.89, Text=“State Code” }, Line { Confidence=97.36, Text=“: 27” }, Line { Confidence=99.86, Text=“State Code” }, Line { Confidence=96.59, Text=“: 27” }, Line { Confidence=99.88, Text=“Phone No.” }, Line { Confidence=97.62, Text=“: 9922007844” }, Line { Confidence=99.87, Text=“Sale Type” }, Line { Confidence=98.46, Text=“: WITHIN STATE” }, Line { Confidence=99.84, Text=“PAN No.” }, Line { Confidence=93.46, Text=“:” }, Line { Confidence=99.76, Text=“Ack No.” }, Line { Confidence=99.86, Text=“Payment Mode” }, Line { Confidence=97.92, Text=“: CREDIT” }, Line { Confidence=97.56, Text=“: 122317831348915” }, Line { Confidence=99.21, Text=“Irn No.” }, Line { Confidence=94.91, Text=“:” }, Line { Confidence=77.16, Text=“2a4b664428a09c0861031761a828faaae01a2aa0433f2e8” }, Line { Confidence=99.23, Text=“Vehicle Reg. No. :” }, Line { Confidence=98.38, Text=“282a7f05bbda9a868” }, Line { Confidence=99.72, Text=“Transaction Type” }, Line { Confidence=95.26, Text=“:” }, Line { Confidence=99.86, Text=“Invoiced” }, Line { Confidence=99.89, Text=“Unit Price” }, Line { Confidence=99.93, Text=“Net Taxable” }, Line { Confidence=99.61, Text=“KFCes” }, Line { Confidence=99.92, Text=“CGST” }, Line { Confidence=99.45, Text=“SGST/UTGST” }, Line { Confidence=98.18, Text=“Srl.” }, Line { Confidence=99.89, Text=“Part Number” }, Line { Confidence=99.87, Text=“Description” }, Line { Confidence=99.85, Text=“HSN” }, Line { Confidence=99.42, Text=“UOM” }, Line { Confidence=99.84, Text=“Unit Price” }, Line { Confidence=99.86, Text=“Discount” }, Line { Confidence=99.91, Text=“Total Amount” }, Line { Confidence=99.95, Text=“Qty” }, Line { Confidence=98.96, Text=“After Dis.” }, Line { Confidence=99.69, Text=“Amt.” }, Line { Confidence=94.85, Text=“S” }, Line { Confidence=99.77, Text=“%” }, Line { Confidence=99.41, Text=“Amt.” }, Line { Confidence=99.76, Text=“%” }, Line { Confidence=99.27, Text=“Amt.” }, Line { Confidence=99.43, Text=“1” }, Line { Confidence=99.48, Text=“0303BAV0051 LUBE” }, Line { Confidence=99.91, Text=“84212300” }, Line { Confidence=99.88, Text=“EA” }, Line { Confidence=94.66, Text=“1.000” }, Line { Confidence=97.78, Text=“1185.59” }, Line { Confidence=99.85, Text=“0.12” }, Line { Confidence=99.86, Text=“1185.47” }, Line { Confidence=99.82, Text=“1185.47” }, Line { Confidence=99.97, Text=“0.00” }, Line { Confidence=99.97, Text=“9.00” }, Line { Confidence=99.92, Text=“106.69” }, Line { Confidence=99.98, Text=“9.00” }, Line { Confidence=96.15, Text=“106.69” }, Line { Confidence=99.03, Text=“1398.85” }, Line { Confidence=99.85, Text=“ON” }, Line { Confidence=99.87, Text=“FILTER” }, Line { Confidence=99.88, Text=“SPIN ON” }, Line { Confidence=99.9, Text=“2” }, Line { Confidence=99.63, Text=“0305DAV0303 FUEL” }, Line { Confidence=99.86, Text=“84211100” }, Line { Confidence=99.91, Text=“EA” }, Line { Confidence=96.57, Text=“1.000” }, Line { Confidence=99.97, Text=“1423.73” }, Line { Confidence=99.81, Text=“0.14” }, Line { Confidence=99.95, Text=“1423.59” }, Line { Confidence=99.95, Text=“1423.59” }, Line { Confidence=93.26, Text=“0.00” }, Line { Confidence=99.97, Text=“9.00” }, Line { Confidence=99.85, Text=“128.12” }, Line { Confidence=96.34, Text=“9.00” }, Line { Confidence=99.94, Text=“128.12” }, Line { Confidence=99.49, Text=“1679.83” }, Line { Confidence=99.82, Text=“ON” }, Line { Confidence=99.79, Text=“FILTER FOR” }, Line { Confidence=83.48, Text=“I6 LCCR” }, Line { Confidence=99.87, Text=“APL” }, Line { Confidence=99.78, Text=“3” }, Line { Confidence=99.76, Text=“6402DAB0001 ELEMENT” }, Line { Confidence=99.76, Text=“84211100” }, Line { Confidence=99.89, Text=“EA” }, Line { Confidence=98.19, Text=“1.000” }, Line { Confidence=99.89, Text=“2076.27” }, Line { Confidence=99.87, Text=“0.21” }, Line { Confidence=99.97, Text=“2076.06” }, Line { Confidence=99.77, Text=“2076.06” }, Line { Confidence=82.46, Text=“0.00” }, Line { Confidence=99.34, Text=“9.00” }, Line { Confidence=94.82, Text=“186.85” }, Line { Confidence=99.82, Text=“9.00” }, Line { Confidence=99.74, Text=“186.85” }, Line { Confidence=99.96, Text=“2449.76” }, Line { Confidence=99.78, Text=“1N” }, Line { Confidence=99.92, Text=“PRIMARY” }, Line { Confidence=99.96, Text=“AIR” }, Line { Confidence=99.86, Text=“4” }, Line { Confidence=99.72, Text=“7306AAP0034 WATER” }, Line { Confidence=99.88, Text=“84211100” }, Line { Confidence=99.89, Text=“EA” }, Line { Confidence=90.94, Text=“1.000” }, Line { Confidence=99.87, Text=“961.02” }, Line { Confidence=99.94, Text=“0.10” }, Line { Confidence=99.94, Text=“960.92” }, Line { Confidence=99.92, Text=“960.92” }, Line { Confidence=79.99, Text="…