Import Multi-line Text into NetSuite

Comments

4 comments

  • Anirudh Sundaram Senior Integration Engineer
    Engaged
    Great Answer

    Hi David,

    You can use the "join" helper like this - 

    {{join '\n' (join ": " "Name" data.name) (join ": " "Rank" data.rank) (join ": " "Serial" data.serial)}}

    0
  • Eric Popivker
    Engaged

    Hey Anirudh Sundaram, thanks, but that doesn't work. It reformats data by adding \, so I get \\n instead of new line.

    0
  • Dan Claypool Support manager NetSuite Integration Whiz
    Great Answer
    Celigo University Level 4: Legendary

    Hi David, Eric,

    Please try the following:

    Name: {{Name}}
Rank: {{Rank}}
Serial: {{Serial}}

    Here, we're sending the LF Unicode character to provide the Line Feeds.

    This should populate the Message field on the Task record with the line breaks. Since this is a "long text" field, it requires some special handling. Please also note that when you view the record directly, it will appear as if there are only spaces. When editing the record, you should see the breaks.

    Additionally, if you're importing into a Rich Text field in NetSuite, you can use <br> to insert line breaks between text.

    1
  • David Gollom Strategic Partner
    Top Contributor
    Celigo University Level 4: Legendary
    Answer Pro
    Great Answer
    Engaged

    Thanks for the help Dan!!  

    0

Please sign in to leave a comment.