AnsweredAssumed Answered

How do I convert a BLOB or CLOB field to a file?

Question asked by jeremy.hill on Oct 9, 2018

The data is populated from a SQL Server varbinary column into a BLOB profile field. The data appears to be Base64 encoded already. After decoding the data is a binary string 0x[...].

 

I have tried:

  • Inserting the Base64 and Binary strings into a Message Shape and Document Cache.
  • Using Groovy to create an InputStream from the bytes.

 

The result is always the same: Boomi essentially treats the binary string as plain text that gets inserted into a file. I have tried this with a text file, jpg, and pdf (sending to disk or as a mail attachment).

Outcomes