Overview
Provides simple Base64 functions intended for use on SAIL interfaces:
Key Features & Functionality
check out this https://community.appian.com/b/appmarket/posts/encryption-utils
FWIW, for anyone who's primarily interested in simple base64-to-text or text-to-base64 conversions, I wrote both expression rules using all-OOTB functionality a few years ago and left them both in this thread. They have no hard-capped length limits, though testing yesterday with an input string of 10,000 characters I realized that anything much longer is likely to lead to (momentary) performance implications.
What's the max lenght of hex2base64 function?
You are right, it is not a problem of limitation. It seem the limitation is now more than 150 chars.
When I decode your base64, I can see "[Document:9399]" in your message. It is probably not you want.
You try to put the document content by just setting fv!item. It cannot work.
You must read the file content.and put the result inside. You can use the function readtextfromfile that is provided by the plugin Text File Utilities.
The XML itself seem well formatted. I don't see any XML syntax error.
<?xml version="1.0" encoding="UTF-8" standalone="yes"?><solicitudUnicoType xmlns:xsi="">www.w3.org/.../XMLSchema-instance" xmlns:sms="SMSBus" xmlns:email="email" xmlns:push="push"> <solicitud> <envioObligado>EMAIL</envioObligado> <email> <email:solicitudEmail> <email:codigoPeticion>PRUEBAPRE123</email:codigoPeticion> <email:destinatarios emailUnico="S"> <email:destinatario>lfprados@minsait.com</email:destinatario> </email:destinatarios> <email:plantilla codigo="TESORERIA-NOTIFICACION"/> <email:asunto>Prueba notificación cambio de estado</email:asunto> <email:cuerpo>Estimado usuario,<br><br>Se le informa de que la solicitud <b>00000001</b> se encuentra en estado <i>'Autorizado, pendiente de validaci&oacute;n'</i>. Acceda al Portal en el siguiente enlace: <br><br>csect-dev.appiancloud.com/.../design<br><br>Un saludo.</email:cuerpo> <email:adjuntos> <email:adjunto id="idEjemplo" nombre="Prueba - copia - copia.pdf" extension="pdf">[Document:9399]</email:adjunto> </email:adjuntos> </email:solicitudEmail> </email> </solicitud></solicitudUnicoType>
I know what I have really into the message.
The request code is:
{ sourceApp: cons!ARQ_GNM_VALOR_SOURCE_APP, destinationApp: cons!ARQ_GNM_VALOR_DESTINATION_APP, singleMessage: encodebase64string( concat( "<?xml version=""1.0"" encoding=""UTF-8"" standalone=""yes""?>", "<solicitudUnicoType xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"" xmlns:sms=""SMSBus"" xmlns:email=""email"" xmlns:push=""push"">", "<solicitud><envioObligado>", /*(Opcional) Indicar si se debe realizar la comunicación solamente por una vía de envío: SMS, EMAIL, PUSH sin contingencias*/ "EMAIL", "</envioObligado>", "<email><email:solicitudEmail><email:codigoPeticion>", ri!codigoPeticion, "</email:codigoPeticion><email:destinatarios emailUnico=""", cons!ARQ_GNM_VALOR_EMAIL_UNICO, """>", /*Destinatarios*/ joinarray( a!forEach( items: ri!arrayDestinatarios, expression: char(10) & "<email:destinatario>" & fv!item & "</email:destinatario>" ), "" ), "</email:destinatarios><email:plantilla codigo=""", cons!ARQ_GNM_VALOR_CODIGO_PLANTILLA, """></email:plantilla><email:asunto>", ri!asunto, "</email:asunto><email:cuerpo>", toHtml(ri!cuerpo), "</email:cuerpo>", if( a!isNullOrEmpty(ri!adjuntos), null, concat( "<email:adjuntos>", a!forEach( items: ri!adjuntos, expression: concat( "<email:adjunto id=""idEjemplo"" nombre=""", document(fv!item, "name") & "." & document(fv!item, "extension"), """ extension=""pdf"">", fv!item, "</email:adjunto>" ) ), "</email:adjuntos>" ) ), "</email:solicitudEmail></email>", "</solicitud></solicitudUnicoType>" ) ) }
The problem is the document, because the encodebase64string function corrupts the document sent.
The HTTP REQUEST sent is:
{"sourceApp":"TESORERIA","destinationApp":"PUSH","singleMessage":"PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiIHN0YW5kYWxvbmU9InllcyI/Pjxzb2xpY2l0dWRVbmljb1R5cGUgeG1sbnM6eHNpPSJodHRwOi8vd3d3LnczLm9yZy8yMDAxL1hNTFNjaGVtYS1pbnN0YW5jZSIgeG1sbnM6c21zPSJTTVNCdXMiIHhtbG5zOmVtYWlsPSJlbWFpbCIgeG1sbnM6cHVzaD0icHVzaCI+PHNvbGljaXR1ZD48ZW52aW9PYmxpZ2Fkbz5FTUFJTDwvZW52aW9PYmxpZ2Fkbz48ZW1haWw+PGVtYWlsOnNvbGljaXR1ZEVtYWlsPjxlbWFpbDpjb2RpZ29QZXRpY2lvbj5QUlVFQkFQUkUxMjM8L2VtYWlsOmNvZGlnb1BldGljaW9uPjxlbWFpbDpkZXN0aW5hdGFyaW9zIGVtYWlsVW5pY289IlMiPgo8ZW1haWw6ZGVzdGluYXRhcmlvPmxmcHJhZG9zQG1pbnNhaXQuY29tPC9lbWFpbDpkZXN0aW5hdGFyaW8+PC9lbWFpbDpkZXN0aW5hdGFyaW9zPjxlbWFpbDpwbGFudGlsbGEgY29kaWdvPSJURVNPUkVSSUEtTk9USUZJQ0FDSU9OIj48L2VtYWlsOnBsYW50aWxsYT48ZW1haWw6YXN1bnRvPlBydWViYSBub3RpZmljYWNpw7NuIGNhbWJpbyBkZSBlc3RhZG88L2VtYWlsOmFzdW50bz48ZW1haWw6Y3VlcnBvPkVzdGltYWRvIHVzdWFyaW8sJmx0O2JyJmd0OyZsdDticiZndDtTZSBsZSBpbmZvcm1hIGRlIHF1ZSBsYSBzb2xpY2l0dWQgJmx0O2ImZ3Q7MDAwMDAwMDEmbHQ7L2ImZ3Q7IHNlIGVuY3VlbnRyYSBlbiBlc3RhZG8gJmx0O2kmZ3Q7J0F1dG9yaXphZG8sIHBlbmRpZW50ZSBkZSB2YWxpZGFjaSZhbXA7b2FjdXRlO24nJmx0Oy9pJmd0Oy4gQWNjZWRhIGFsIFBvcnRhbCBlbiBlbCBzaWd1aWVudGUgZW5sYWNlOiAmbHQ7YnImZ3Q7Jmx0O2JyJmd0O2h0dHBzOi8vY3NlY3QtZGV2LmFwcGlhbmNsb3VkLmNvbS9zdWl0ZS9kZXNpZ24mbHQ7YnImZ3Q7Jmx0O2JyJmd0O1VuIHNhbHVkby48L2VtYWlsOmN1ZXJwbz48ZW1haWw6YWRqdW50b3M+PGVtYWlsOmFkanVudG8gaWQ9ImlkRWplbXBsbyIgbm9tYnJlPSJQcnVlYmEgLSBjb3BpYSAtIGNvcGlhLnBkZiIgZXh0ZW5zaW9uPSJwZGYiPltEb2N1bWVudDo5Mzk5XTwvZW1haWw6YWRqdW50bz48L2VtYWlsOmFkanVudG9zPjwvZW1haWw6c29saWNpdHVkRW1haWw+PC9lbWFpbD48L3NvbGljaXR1ZD48L3NvbGljaXR1ZFVuaWNvVHlwZT4="}
Thanks and regards.
I don't understand how your code can works if the limit is reached and it clearly the case. Copy paste the singleMessage into a tool to decode the base64 and see what you have really into the message.
Why is it related to character limitation?The issue is when document is sending. Because when we use de plugin to convert the XML, which contains the parameters, included the documents attached, to Base64 it corrupt the document.
Hi,
This function is limited to 150 characters. You must update and recompile the plugin if you want to extend this limitation.
We are trying to integrate with a client's external system to send notifications. One of the input parameters of this system is "singleMessage" which is of type text and must be passed an XML converted to base64 with the email parameters (body, recipients, attachments, etc.). To convert the XML to Base64 I use the encodebase64string function (attached screenshot of the code), but this function corrupts the file. I also attach the request sent to the system and the resulting email (with the corrupt document).
Could you help me?
Hello Tim Nguyen , would it be possible to make max lenght unlimited? Usecase for this is to send email body with variable lenght as base64string. Thanks for response.