Hi,
I designed cloud flow in power automate and as flow is triggered a record is received (get) where also all of attached files are being archived into the *.ZIP file format and that *.ZIP file is send with that record to BC SaaS. But I need that ZIP file will be extracted and send the extracted files in PDF file format to the BC SaaS.
My solution is to create new table ("Employee Attachment") and link that table with T5200 - Employee and as records is inserted from that Cloud flow, the extracted files will be inserted in the BLOB field; new records will be created for each file that is inserted.
Should I do the extraction of ZIP file already in the cloud flow, or as file is inserted in BC, then with some procedure to extract ZIP file and insert the extracted files.
I saw that BC version 15 supports blob storage module, but now sure to use that, since it cost additional money, which my client does not want to spent...
Do you think this will work?
Thanks Damjan