Base64 Document Database Integration

Overview

Provides the following two smart services that are database agnostic and supports dynamic queries.  

Key Features & Functionality

  • Get Base64 Document from Database - Retrieves a document as a base64 string from a SQL query and converts it into an Appian document, returning the document id.
  • Insert Document as Base64 into Database - Takes an Appian document id, converts to Base64 and updates the database as specified by a SQL query.
Anonymous
Parents
  • 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?

Comment Children
No Data