Base64 Document Database Integration

Hi Dave

If this helps, this is how I'm using the Insert Document as Base 64 smart service

The insert SQL command is structured so that each entry mirrors the layout of the MySQL database 

="INSERT INTO MONITORING_dp_config VALUES (:publisher,:name,:documentId,:description,:configid,:isuieditallowed)"

each value in the insert is then populated via the relevant input node entry - the input names are exact matches for the insert statement. When you pass the documentId of the document you want to store as Base64 the Smart Service will look for that document and convert it accordingly. 

Hope this helps you out.

Cheers

Paul 

Hi Ben, Reaching out trying to get help with consuming the services. When you get a minute can you please post an example of the sql and node inputs for the two services. It just needs a little bit of guidance to be easy to consume. Appreciate any help you can provide.

Thanks

Dave

If anybody has used this can you please post some examples of the sql and node inputs for the two services. It just needs a little bit of guidance to be easy to consume.

Much Appreciated.

I was able to convert a txt file into a Base64 encoded string in the database, however when I tried to convert a pdf file into Base64 the smart service did not work. Did anyone face a similar issue?

Thanks Ben Dudley

Hi arjunm497, It should be compatible.  There haven't been any recent changes that would affect the functionality.

Best, Ben

Hi arjunm497, I have reached out internally to determine if the plug-in works with newer Appian versions.  I would also suggest posting in Discussions (https://community.appian.com/discussions/) to see if other Community users have tried it with more recent Appian versions. Your question will get the most visibility that way!

Hi Anu,

We have a requirement where we have to convert Base64 encoded string to Appian document. Is this plugin compatible with Appian 18.1?

Thanks,

Arjun