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

Were you able to resolve this issue?

Were you able to resolve this issue?