Base64 Document Database Integration

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

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

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

The download package has been updated to include this documentation

The documentation for this was accidentally excluded from the latest release.
It's attached below.  This should answer many questions as to how to operate the plugin successfully.

PDF

Hi Jorge, can you please share all the values you set as input? Do you also have something logged in the stdOut when you tested it and got that error? That error is a generic one and most of the times indicates that the inputs of the SS have been wrongly mapped.

Still persists "An error occurred in executing an Activity Class."... What can I do?

JNDI is the datasource name (Example: jdbc/AppianBusinessDS) - You can find the datasource name under admin console>>Datasources or in the datastore object , you can find the datasource name

What is JNDI name??

In the end I got this working too. Thought I'd post and perhaps save someone else a little frustration. This really is a good plugin, would benefit from a few examples.

The node inputs on the Get Base64 Document from Database

• Document Name - example "MyFile"
• Format - or file extension, example "txt"
• Jndi Name - as above
• Sql Statement – Example "SELECT fileContent FROM MR_AD_FileInfo WHERE fileId = " & pv!fileId.
  • Note: fileContent is the field hold the base64 string (Varchar(MAX))
• Target Folder - standard appian folder type.