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

© 2024 Appian. All rights reserved.