Base64 Document Database Integration

RE: Base64 Document Database Integration

ramaraoj090672 — Tue, 10 Mar 2026 21:10:27 GMT

Hi,

I need to send attachment in binary format in request xml for one soap service.

Is this smart service working for the attachments of size 25 MB. I was told that it's not working for attachments > 5 MB. Could someone Please confirm that is this working for bigger attachments with size till 25 MB.

Thank you.

RE: Base64 Document Database Integration

Appian AppMarket — Tue, 22 Apr 2025 22:00:15 GMT

v1.1.0 Release Notes

Updated deprecated APIs, and changed the application minimum version to 23.2

RE: Base64 Document Database Integration

malavikar21 — Mon, 24 Feb 2025 16:29:38 GMT

Hi, Is this plugin cloud approved?

RE: Base64 Document Database Integration

nourhan_abdelrazek67 — Sun, 12 Jan 2025 13:45:02 GMT

Hi,
when i use this pugi n, base64 is not stored in database.
what's wrong?

RE: Base64 Document Database Integration

harshajyotip0001 — Wed, 23 Oct 2024 16:26:30 GMT

We have upgraded the plugin to latest version to v1.0.4, however even after the upgrade it is still being flagged in Health check for using Deprecated appian APIs.

Base64 to Database Services (com.appiancorp.ps.db) references deprecated Appian APIs
[deprecated] com.appiancorp.suiteapi.content.ContentOutputStream.close()
[deprecated] com.appiancorp.suiteapi.content.ContentOutputStream.flush()
[deprecated] com.appiancorp.suiteapi.content.ContentOutputStream.getContentId()
[deprecated] com.appiancorp.suiteapi.content.ContentOutputStream.write(byte[])
[deprecated] com.appiancorp.suiteapi.content.ContentService.upload(com.appiancorp.suiteapi.knowledge.Document, java.lang.Integer)
[deprecated] com.appiancorp.suiteapi.knowledge.Document.getInternalFilename()

Hoping to understand if there is any plans for remediating the dependency on deprecated APIs in upcoming upgraded.

RE: Base64 Document Database Integration

rajarajasozhanh0003 — Wed, 31 Jul 2024 06:35:29 GMT

I am getting an error while using the Insert Document as Base64 into Database smart service

Error: "Cannot invoke "java.util.List.iterator()" because "this.inputs" is null".

Can anyone pls help here.

RE: Base64 Document Database Integration

Baby — Mon, 27 May 2024 14:01:45 GMT

hello

I'm using [Insert Document as Base64 into Database] but the value cannot change appian document id to base64 value .

What is wrong

RE: Base64 Document Database Integration

Alexis Argilés — Mon, 20 May 2024 08:34:16 GMT

Hi,

Is possible to increase the max_allowed_packet without doing it in the DB? Because in the case of restarting the environment, this value will always return to its original value.

RE: Base64 Document Database Integration

Anuj Sheth — Mon, 05 Jun 2023 15:31:21 GMT

What should be the JNDI name for connected system. I am using a different schema and have created connected system for Maria DB

RE: Base64 Document Database Integration

Maciej Borkowski — Wed, 20 Apr 2022 07:14:42 GMT

Dear Community,

The Plug-In works well for us, we are using 'Get Base64 Document from Database' Smart Service.

The documents are downloaded and stored as expected only when there is a data in the database record.

However when the field is empty (we are missing document for certain record), the Process is paused with error. I was rather expecting it will get completed and pass the information to me with output variables 'isSuccess' and 'errorMessage', but for this specific use case it is just crashing.

I am looking for a smart workaround. I can think of using the Query Database node before to check if there is a value in the database and depending on it: end the process or move forward. However that seems not very efficient for me as i will query database twice with this process.

Do you see any other solution ?

Thank you in advance for all suggestions,
Best Regards,
Maciej

RE: Base64 Document Database Integration

vishnud126275 — Wed, 15 Dec 2021 17:38:56 GMT

Hi Corrado, we have used this plugin in our application. In light of the recent discovery of vulnerabilities with log4j2, we would like to know if this plugin uses the affected version Log4j2, and if yes, would you release an updated version of this plugin to counter the exploit of vulnerability?

RE: Base64 Document Database Integration

jnamba — Fri, 02 Jul 2021 23:29:16 GMT

Hi there,

This plugin works for me when I use a simple SQL statement: SELECT [] from [] where [] = []

However, I keep getting syntax errors when I try something more complex: SELECT [] from [] where [] = [] AND [] = []

What would be the correct way to format this string?

Thank you

RE: Base64 Document Database Integration

encalafi — Wed, 07 Apr 2021 08:28:11 GMT

Hi everybody,

I tried to use this plugin in 19.4 Appian version.

I was able to configure the insert into db smart service but it provides me as output exactly the ID of the document instead of the base64 conversion.

Here below the configuration i have used:

input data:

*JNDI Name (text): "jdbc/BusinessData" --> found on the admin console / Data source

*Sql Statement (text): "INSERT INTO dbo.pkbbase64 VALUES (:documentid,:title)"

*documentid (number-integer): document id present in appian

*title (text): "test string"

what I get in the table is:

*base64 (varchar(4000)) --> exactly the documentID (not converted)

*title (varchar(255)) --> "test string"

This situation happens both for pdf and txt file.

Can anyone support me please?

Thanks

RE: Base64 Document Database Integration

arunramanathtm — Thu, 01 Apr 2021 15:52:43 GMT

Hello Team,
Im getting the following error : Error in executeUpdate, String or binary data would be truncated.
Can you help resolve this

RE: Base64 Document Database Integration

Appian AppMarket — Mon, 08 Mar 2021 22:37:15 GMT

v1.0.4 Release Notes

Updated commons-codec library, the base64 string is no longer chunked