You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Attaching PDFs to Multiple Invoices

Accepted answer


Content (please ensure you mask any confidential information):

Hi all, I am attempting to attach PDFs to multiple invoices (a one to one).

The way things are set up right now is that we are getting a zip folder from an SFTP server with multiple files. I am using the action "Download File" and clicking the unzip option when using that SFTP connector. I also have a table in the ATP database with the invoices (that exist in Oracle SaaS). I am using the action "Run a SQL Statement" when using the ATP connector. This table has the fields: invoice_id, invoice_number, and file_name. File name is supposed to match the corresponding file name from the download file.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!