WS BASE64 GET METHOD

Hi guadalupej0001,

You can sue the smart service Appian Document from Base64 String to do your job.

Below post may help you.

https://community.appian.com/discussions/f/integrations/13208/base-64-to-document/59846#59846

Thanks,

Venu.

Instead of a text datatypes in the data base, try something like "long" which has more space.  Please use caution in your database accumulating too many long values. Plan to delete the base64 strings out of the db as soon as you've converted them back into files.

Hello Venu, that component  is not available, another idea???

Thanks!!!

Thanks Robert I'm going to try it, I'll tell you what happend

https://community.appian.com/b/appmarket/posts/base64-document-database-integration

I have used this component before to transform base64 strings in the database into appian documents.

Hi, I'm trying that component Get Base64 Document from Database

My problem is the length, my base64 string is too long (14,000,000)

Don't use Text.  That's not appropriate for a string that large.  use a blob, clob, longtext or similar.

what type of database is it?

Oracle database,

Hi guadalupej0001,

One of the commenter in above post, upload the base64ToDoc-Appian.zip plug-in. if you are in on-premise you can deploy and use it. if it is in Cloud, you have request appian support.

As of 19.2, Appian has this out of the box with the Integration Object and the limit for a response with documents is 75mb.

https://docs.appian.com/suite/help/19.2/Appian_Release_Notes.html#receive-binary-with-integrations-and-receive-base64-inline-with-json

https://docs.appian.com/suite/help/19.2/Integration_Object.html

Before this, I have used the Base64 Request to REST Web Service plugin to turn base64 in a WS response directly into an Appian document. I don't know if there are any limits on this one.

https://community.appian.com/b/appmarket/posts/base64-request-to-rest-web-service