I have a zip file containing a access file and a bunch of PDF files which can range from invoice, statements, remittance letters, credit letters…etc.
Each record in that access file corresponds to pdf file type in a random order
So for instance,:
Access file 1 could have 3 records for a statement, credit and upgrade offer letters (in pdf)
Access file 2 could have 2 records for a an invoice and reminder letters (in pdf)
Access file structure:
CustomerNumber, DocumentType, DocumentNumber, etc…
012345, Invoice, INV12345,etc…
456789,Credit, CR987654, etc…
The PDF files are named as follow:
The datamapper is based on the access file.
Sometimes, a PDF might be named with the wrong customer number or invoice number and we need to open the PDF to check that these values match the ones in the access file. The customer and invoice number will be written on the first page of the PDF at specific locations.
In there any way to open the PDF in the Action step for each record in the access datamapper to read the customer and document numbers inside the PDF?
So my datamapper is based on the Access file and I need to lookup information from a PDF file to complement or validate each record. Is this possible? If, so which object of the datamapper API do I use?