将pdf或jpeg转换为SQL数据库中的记录
我将发票/开票凭证的PDF / JPEG格式上传到Office365 Sharepoint。
I upload the PDF/JPEG format of invoices/billing documents to Office365 Sharepoint.
然后它触发Microsoft Flow调用认知服务以识别上传的文件和将它们转换为SQL数据库记录。
Then it triggers a Microsoft Flow to call Cognitive Service to recognize the uploaded file and convert them into SQL database records.
是否可以这样做？
我可以参考的任何资源？
Any resource I can refer to?
谢谢，
Joe
您好，
由于您使用的是发票或帐单格式的PDF和图片，因此最好使用
表单识别器
API 并获取JSON格式的响应，您可以从中获取所需的字段并存储在SQL DB或noSQL DB中cosmos DB。
Since you are using PDF's and images which are of invoice or billing format it is ideal to use Form recognizer API and get the JSON formatted response from which you can take the required fields and store in a SQL DB or a noSQL DB like cosmos DB.