©2019 by Neil Roberts. Proudly created with Wix.com

  • Neil Roberts

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.

19 views