How to download an attachment from UCM server and display that attachment detail in BI report
There is a custom HCM extract designed to send the outbound file to an FTP location.This extract calls a BI report which acts as the source for providing the data to the outbound file.
As part of this outbound file, we have a field that needs to send the attachments if there are any.
From Fusion perspective the file gets stored in the UCM server and we will be able to know the attachment name along with the UCM file ID through SQL. Is there any way to download the attachments based on this information and pass it on the field value. Please suggest the best approach as to how to get the attachments along with the outbound file.