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.