Retrieve "Content as Base64" for All PDF-Attachments of an Instance

0

Subject: Assistance Needed – Retrieve "Content as Base64" for All PDF-Attachments of an Instance


Dear All,

I am currently looking for a way to extract the "Content as Base64" for all attachments associated with a specific instance. My goal is to obtain a single text line in the following format:
'Base64 PDF 1', 'Base64 PDF 2', 'Base64 PDF 3'. -> The easiest way would be to use built-in tools, but unfortunately, that doesn’t work (CONTENT AS BASE64[GET ATTACHMENTS])

After attempting this myself without success, I came across an answer provided by Karol in 2023: Karol Częczek https://community.webcon.com/forum/thread/2906?messageid=2906

However, I’ve encountered an issue: my attachments are not stored in the WFAttachmentFiles table (there are ONLY 20 files in that table). Instead, they seem to only have metadata available in the WFDataAttachments table.

Does anyone have any insight into this, or perhaps an alternative solution to generate a single text line containing all Base64-encoded PDF attachments, separated by single quotation marks and commas?


Thank you in advance for your help and suggestions.

Best regards,
Bjoern