Overview
Provides the following two smart services that are database agnostic and supports dynamic queries.
Key Features & Functionality
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?