How can we read the data from PDF file coming from FTP Server?

Integrator.io
1

I got the blobkey from source but how to get the data from that so that I can import the required data in NetSuite Custom Record. Please help me on this

Source Data:
{
"success": true,
"fileMeta": {
"fileName": "US90620425.PDF",
"lastModifiedTime": 1778149929000,
"fileSize": 104226,
"filename": "US90620425.PDF",
"filesize": 104226,
"type": "PDF"
},
"blobKey": "c2698848e78e4450a6f7020e862550f0"
}

What to do next to get the data which is in that pdf file through this vis celigo custom flow???

2

The blobKey is not the PDF data itself. It is Celigo’s internal reference to the downloaded file. To create a NetSuite Custom Record from data inside that PDF, you need one more step that reads/parses the PDF content into structured fields, then map those fields into NetSuite.

3

Hi Nuri,

Thank you for the clarification — that makes sense.

Could you please guide me on the next step? Specifically, how do I read the PDF content (referenced by the blobKey) and parse it into structured fields that can then be mapped into a NetSuite Custom Record?

Any example or documentation reference would be very helpful.

Thanks again!

4

Try this:
→ Convert blob/file to base64 or transfer actual PDF file
Check this post: FAQ: Convert a blob key to base64 string for import? - #4 by tylerlamparter
→ Send PDF/base64 to OCR service
→ OCR returns extracted text/fields
→ Map extracted fields to NetSuite Custom Record