Hi all,I need to convert a PDF file to Base64 to send it in a Request Soap field. Once the service returns the result in the same way it must be converted from Base64 to PDF file. I am using the component "Insert Document as Base64 into Database" but I can not find examples of how to configure this component. I have tried several ways to build the statement "Sql Statement" but it always returns error: << An error occurred in executing an Activity Class. >>Does anyone have any idea of a solution?
Discussion posts and replies are publicly visible
I believe you can break it in two. Encode to base64- function and send to web service.
Get from web-service and decode base64 to document - smart service.
Hope it helps!
Adding to the above comment.
You need to be a bit cautious while dealing with Base64 data, as this may impact your server performance.
Let's take an example to understand this better.
I would recommend, if there are any possibilities to deal with Binary Stream then you should prefer that otherwise you should consider using Base64 conversion wisely.
If you're still in need of an answer, your SQL statement includes pv!record.folderId which won't work.
According to the documentation provided with the plug-in, your SQL Statement should be
"INSERT INTO DB_DocumentBase64 VALUES ( :folderId )"
You then need to create an AC input variable called folderId and you can assign it the value pv!record.folderId
Although unintuitive, this is how the documentation explains the configuration of this node and it worked for me
I hope this helps, let me know how you get on
© 2022 Appian. All rights reserved.