Convert Image to varbinary

[Istwineres]

I was wondering if it is possible to convert an image (passport photo) to varbinary(max) in Alteryx. I'm trying to use the BLOB tool, but the web service SOAP where I should pass the encoded Base64 binary data image, doesn't respond. Thanks!

[danilang]

@Istwineres 

The Blob Input->Blob Convert sequence is the correct way to convert an image to a Base64 encoded string.  I think the issue may be on the receiving end.  Make sure you've properly formatted the download tool params to include any required headers, authentication details and payload fields

Dan 

[Istwineres]

Hi Dan, thanks for the prompt reply! I can tell you the header and the payload worked without the image encoded input in the XML. 

[Istwineres]

Perhaps the embedded newlines in the encoded binary image?

[Istwineres]

The V_string size was the issue! but is it possible to convert multiple images in the same workflow/app?

[danilang · Accepted solution]

Hi @Istwineres 

The blob input tool has an optional input connector.  If you connect a list of paths to this input and select an option from the "Modify File Name Using Optional Input" option, you can convert multiple images at once.  Each of them will be converted individually.  The download tool will the see multiple rows and make multiple calls to your web service sending one file at a time.

Dan