i Wanted to store appian document into blob format in database, Can we have plugin for this
Discussion posts and replies are publicly visible
Maybe something you are looking for - community.appian.com/.../rdbms-blob-utility
What is the purpose of storing a binary document to the database?
Hi Stefan ,We have an application which users captures the images and will store in appian folders, We want this images need to move to another synapse database with meta data, We cant use webapi to send documents as we have lot of documents almost near to 100, so i am planning to push to synapse on each instance in process model when user submit the form instead daily load with api
Thanks a lot for the explanation. You say "We cant use webapi to send documents as we have lot of documents". Why is that?
IMHO it is a very questionable design to store binary data in a DB.
Would like to know will appian supports sending multiple documents in one API call ? if yes what is the approach, i tried but it is not working
You can enable a multipart/form-data post and define the type for each part including document.
I have seen this but this will be a post method where external system need to give an api to me and i can use integation object to do send documents , And also it supports maximum 75mb data
Am i following you?
OK. But what is your question?
i wanted to send mutliple document with creating webapi in appian , so other system can call it, But as of now i see it is supporting only one document
a!localVariables(
local!document: 35210,
a!httpResponse( headers: if( http!request.queryParameters.attachment, a!httpHeader( name: "Content-Disposition", value: concat( "attachment; filename=""", document(local!document, "name"), ".", document(local!document, "extension"), """" ) ), {} ), body: todocument(local!document) ) )
For incoming calls, AFAIK the current limit is one single file. That could be a ZIP archive if that helps.