Do you get full message in AR System Email Message form? What is setting of 'Use Original Template format' setting for incoming mailbox in AR System Email Mailbox form? Chaning this parameter value may help.
Are you sure if construct mentioned in your post is correct ? For testing purpose you can harcode start and end position in SUBSTR fucntion.
yes, I get a full message on AR System Email Messages form. The problem is to send it from the AR System Email Messages form to the interface form. The content in <Descritption>approx 5000 char</Description> is truncated then.
I think that the constuct is correct because I need to send only text in <Descritption>approx 5000 char</Description> to field Description. The number of character ca be different per message. Message itself seems like this:
<Description>text - approx 5000 characters</Description>
<TicketID>3rd party system ID - characters</TicketID>
<RequestStart>date – Unix epoch time</RequestStart>
<RequestEnd>date– Unix epoch time</RequestEnd>
Thank you very much,
Construct is correct (tested quickly).
Can you change 'Use Original Template Format' parameter to 'Yes'? restart email engine and test. Please capture workflow logs and post here.
I've changed the parameters like this:
and tried to create a new email in AR System Email Messages. 3027 characters have been sent (to the Description field), but only 2515 characters have been saved on interface form - Description field.
Filter and DB log is attached.
workflow.log 1.5 MB
It seems the problem will be on DB side. Field "Description" should be unlimited, but it's not and the number of characters which are truncated are different and depends on number of characters sent. So, this problem should be related to configuration of a related DB.