I am looking for a way to convert Base 64 format string to document in Appian.
Note: The base 64 format string is coming as a JSON input request string when external system hits Appian web API. So, I don't have any integration object here to auto-convert the same to document using default Appian functionality in integration object. I need to receive this format, convert into document, store in Appian document folder and show the same in UI (without using integration).
Discussion posts and replies are publicly visible
Hi varunbawa ,
We also have the same scenario like we get the document as base64 string when dot net system hits our API, we saved the string in Database table and then we used the below plugin to convert the string to document and store it in Appian folder.
Thanks Sri Ram Kaja for quick response. I will try that.
Also, can you help me with the storing of that base64 string in Appian DB. What datatype of what length should I use to store those strings considering what's supported as max in Appian?
We have used MEDIUMTEXT in Database for saving the string. You can go for medium or long text.
Note: Since the column is more than 4000 characters, During record sync, system will sync first 4000 characters. So please take care of that.
Sure. Got it. Anyway, I was thinking to wipe off that string after its converted and stored in Appian doc folder just to not have high impact on database memory usage.
But, still out of curiosity, how did you handle that record sync issue in your usecase?
Also, while mapping longtext in Cdt xsd, do we need to specify any length to TEXT cdt datatype?
When we did that, there is no record sync functionality. Now I am not in that organisation. Even We also save the data then generate the file and save the docId and later delete the base 64 string
Hi ,
You can do it this way
Thanks! It worked for me.