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 there,

    This plugin works for me when I use a simple SQL statement: SELECT []  from []  where [] =  [] 

    However, I keep getting syntax errors when I try something more complex: SELECT [] from [] where [] = [] AND [] = []

    What would be the correct way to format this string?

    Thank you

Comment
  • Hi there,

    This plugin works for me when I use a simple SQL statement: SELECT []  from []  where [] =  [] 

    However, I keep getting syntax errors when I try something more complex: SELECT [] from [] where [] = [] AND [] = []

    What would be the correct way to format this string?

    Thank you

Children
No Data