Hi all, We want to import attachments in SQL Server DB to Appian KC and sho

phanibabuk over 8 years ago

Hi all,
We want to import attachments in SQL Server DB to Appian KC and show them under "Records".

The datatype used in the SQL table for attachments is "image" which is currently deprecated.

We tried casting/converting to base64binary but it didn't work.

Please let us know how can we import these attachments to Appian.

Discussion posts and replies are publicly visible

Parents

0 jamesw63 over 8 years ago

The base64binary type should work for storing the bytes, but I'm not sure how Appian would treat it. I've used varchar(max) before to store PDFs without any trouble. This way Appian will recognize it as a string. Then you can convert back to an image file using the smart service mentioned above. As for size, you'd have to check what your database supports. If it's just a small image, then you should be fine.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 jamesw63 over 8 years ago

The base64binary type should work for storing the bytes, but I'm not sure how Appian would treat it. I've used varchar(max) before to store PDFs without any trouble. This way Appian will recognize it as a string. Then you can convert back to an image file using the smart service mentioned above. As for size, you'd have to check what your database supports. If it's just a small image, then you should be fine.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data