PDF Extraction to sql server table
Hi Expert
in the blob structure, I am connecting to Azure database and when i mapped the json i am getting status, page, bounding text columns, i want table column header and data to map with sql server table column
here is my code
{"status":"succeeded","createdDateTime":"2022-04-27T14:15:46Z","lastUpdatedDateTime":"2022-04-27T14:15:48Z","analyzeResult":{"version":"2.1.0","readResults":[{"page":1,"angle":0,"width":11.6806,"height":8.2639,"unit":"inch","lines":[{"boundingBox":[0.1977,0.8568,1.166,0.8619,1.166,1.0647,0.1977,1.0596],"text":"intertek","appearance":{"style":{"name":"other","confidence":0.878}},"words":[{"boundingBox":[0.1977,0.8619,1.1052,0.8619,1.1103,1.0697,0.2028,1.0647],"text":"intertek","confidence":0.986}]},{"boundingBox":[4.19,1.0151,5.5355,1.0151,5.5355,1.0806,4.19,1.0806],"text":"India CRUDE OIL QUALITY REPORT","appearance":{"style":{"name":"other","confidence":1}},"words":[{"boundingBox":[4.19,1.0151,4.4838,1.0151,4.4838,1.0717,4.19,1.0717],"text":"India","confidence":1},{"boundingBox":[4.509,1.0152,4.7505,1.0152,4.7505,1.0717,4.509,1.0717],"text":"CRUDE","confidence":1},{"boundingBox":[4.7771,1.0151,4.8915,1.0151,4.8915,1.0717,4.7771,1.0717],"text":"OIL","confidence":1},{"boundingBox":[4.9153,1.0151,5.2293,1.0151,5.2293,1.0806,4.9153,1.0806],"text":"QUALITY","confidence":1},{"boundingBox":[5.2558,1.0151,5.5355,1.0151,5.5355,1.0717,5.2558,1.0717],"text":"REPORT","confidence":1}]},{"boundingBox":[0.2028,1.085,0.8821,1.085,0.8821,1.161,0.2079,1.161],"text":"Total Quality. Assured.","appearance":{"style":{"name":"other","confidence":0.878}},"words":[{"boundingBox":[0.2079,1.09,0.3447,1.09,0.3498,1.1661,0.2129,1.1661],"text":"Total","confidence":0.994},{"boundingBox":[0.3599,1.09,0.5932,1.09,0.5932,1.1661,0.365,1.1661],"text":"Quality.","confidence":0.991},{"boundingBox":[0.6084,1.09,0.8821,1.09,0.8821,1.161,0.6084,1.1661],"text":"Assured.","confidence":0.94}]},{"boundingBox":[0.4893,1.2427,0.6554,1.2427,0.6554,1.2984,0.4893,1.2984],"text":"Motel:","appearance":{"style":{"name":"other","confidence":1}},"words":[{"boundingBox":[0.4893,1.2427,0.6554,1.2427,0.6554,1.2984,0.4893,1.2984],"text":"Motel:","confidence":1}]},{"boundingBox":[0.9796,1.2418,1.2381,1.2418,1.2381,1.2984,0.9796,1.2984],"text":"Tony","appearance":{"style":{"name":"other","confidence":1}},"words":[{"boundingBox":[0.9796,1.2418,1.2381,1.2418,1.2381,1.2984,0.9796,1.2984],"text":"Tony","confidence":1}]},{"boundingBox":[4.1871,1.2386,5.4172,1.2386,5.4172,1.3128,4.1871,1.3128],"text":"Grade Name: Tony light crude oil","appearance":{"style":{"name":"other","confidence":1}},"words":[{"boundingBox":[4.1871,1.2387,4.399,1.2387,4.399,1.2984,4.1871,1.2984],"text":"Grade","confidence":1},{"boundingBox":[4.4282,1.2426,4.6542,1.2426,4.6542,1.2984,4.4282,1.2984],"text":"Name:","confidence":1},{"boundingBox":[4.6847,1.2427,4.9071,1.2427,4.9071,1.3128,4.6847,1.3128],"text":"Tony","confidence":1},{"boundingBox":[4.9339,1.2386,5.0874,1.2386,5.0874,1.3128,4.9339,1.3128],"text":"light","confidence":1},{"boundingBox":[5.1128,1.2387,5.3097,1.2387,5.3097,1.2984,5.1128,1.2984],"text":"crude","confidence":1},{"boundingBox":[5.336,1.2386,5.4172,1.2386,5.4172,1.2984,5.336,1.2984],"text":"oil","confidence":1}]},{"boundingBox":[8.5307,1.2386,9.1631,1.2386,9.1631,1.3128,8.5307,1.3128],"text":"Month Reporting:","appearance":{"style":{"name":"other","confidence":1}},"words":[{"boundingBox":[8.5307,1.2386,8.7644,1.2386,8.7644,1.2984,8.5307,1.2984],"text":"Month","confidence":1},{"boundingBox":[8.7956,1.24,9.1631,1.24,9.1631,1.3128,8.7956,1.3128],"text":"Reporting:","confidence":1}]},{"boundingBox":[9.5881,1.2418,9.8167,1.2418,9.8167,1.2984,9.5881,1.2984],"text":"Jan-22","appearance":{"style":{"name":"other","confidence":1}},"words":[{"boundingBox":[9.5881,1.2418,9.8167,1.2418,9.8167,1.2984,9.5881,1.2984],"text":"Jan-22","confidence":1}]},{"boundingBox":[0.4393,1.3658,0.7068,1.3658,0.7068,1.4217,0.4393,1.4217]
How can we take columns headers and data and not any other things or may be we remove it use the file properly . i just needs header and data that sit
Expected output:
Motel:India Grade Name:India light crude oil India QUALITY
BL Date