Information
  • Author: Appian Corporation
  • Type: Plug-in (Function & Smart Service)
  • Support: This plug-in or utility is not supported by the author. The content is free to use with a licensed product, but it is made available as-is and Community supported.
  • Industry: All Industries
  • Compatible Version(s): 7.10+
  • First Released:
  • Last Updated:
  • Cost: Free
Share
Home » AppMarket » Base64 Document Database Integration

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

Comment

  • 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

Children

© 2024 Appian. All rights reserved.