Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

in Integration 3 comments

Summary:


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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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