i Wanted to store appian document into blob format in database, Can we have plugin for this
Discussion posts and replies are publicly visible
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.
yaa tried the zip, but would like to know how much size appian support sending the file size, Any size limit we have ?
I am confused! Do you want to send files from Appian TO another system, or receive files FROM another system?
Sending works via Connected System & Integration, for receiving you use a Web API.
i am sending files with webapi , so other system can call it
For receiving files using a Web API, the limit is 75MB.
docs.appian.com/.../passing-a-web-api-document-into-a-process-model.html
thanks for the input, but the above one is when external system wanted to upload files in appian , I am sending files to others from appian for this i exposed the api so azure can call it , i zipped the documents and sent to them it is working fine , but the file size are big so wanted to know what is the file size appian can expose as webapi so it will not break
Now I am even more confused. You write "I am sending files to others from appian for this i exposed the api so azure can call it". This sentence makes no sense in my head.
https://docs.appian.com/suite/help/22.2/Integration_Content_Types.html#document-(auto-detect)
Although there is no request body size limit imposed on this Content-Type, the best practice is not to exceed 250 MB for a single document.