The article: Integration Object - Appian 23.3 says that if the response body is in JSON format, the maximum size of the response file should be <5MB.
In our environment, there are instances when we are getting Integration response when the file size is 7MB and there are instances where we are not getting integration response when the response body is 5.12MB with the error :“Response body size limit exceeded.”
Any explanation to this query is much appreciated.
Moreover, When a file is encoded in base64, its size increases by approximately 33% compared to the original data size. This made me curious how the maximum limit for JSON body is 5MB and Base64 is 75MB.
Discussion posts and replies are publicly visible
To your last question. The body is directly handled as a file and stored to disk. This is why the limit is higher.
To the first question. I do not have a good answer to this. You will have to investigate deeper. In general, I think that transporting a multi-megabyte JSON payload is probably not the best idea.