Question
Blue Cross and Blue Shield of Minnesota
US
Last activity: 8 Oct 2020 0:15 EDT
Query blob to to extract files
We have a use case where we want to extract text from PDFs, JPGs (OCR). We decided we will use AWS's Textract. We are trying to query blob (pc_data_workattach, pzpvstream) to extract files but we are not able to read the files even after successful extraction. Does Pega encode the blob by it's proprietary mechanism? Any suggestions on how we approach our use case?
Updated: 16 Sep 2020 15:34 EDT
Pegasystems Inc.
US
The BLOB is the entire class instance serialized into a binary format. What you need is the content of the file itself which will be stored in one property inside the blob. I don't know the data model offhand, but you can start by investigating the Data-WorkAttach-File class to find what property the file content is stored in (perhaps pyFileData or pyAttachStream).
Blue Cross and Blue Shield of Minnesota
US
Thanks for reply.
We are using Connect-File to create the files in a folder and then use them. This is working for us and we don't want to query the blob anymore.
I have a different question now:
AWS Textract extracts data into a CSV file and is stored in a postgres table bytea column.
I tried "select lo_from_bytea(0,csv) from <table name>;" which gave me csv_oid.
And then I tried "\lo_export <csv_oid> <filename>" which fails.
How do I extract a csv and use it as a grid source in Pega?