Long Text in XMLPort Microsoft Dynamics NAV
Updated: Nov 12, 2019
A colleague of mine recently had a requirement for lengthy text (over 1024 characters) in a XML tag. No problem right? NAV doesn't limit text length 2013 onwards. Eh, not quite.
XMLPort Elements have a property TextType, which defaults to Text and is limited to 1024 characters. To work around this, you need to do the following:
Set TextType to BigText
Declare a Text Variable with DataType Text, and no length
Then used the GETSUBTEXT function to store the Imported Text into the variable
You can then use the Text variable to manipulate the imported text.
I would like to say a special thanks to Neil Murray aka Momo for sharing this with me.