Forum Discussion

brianrandolph's avatar
brianrandolph
New Contributor III
8 years ago

Group line item docs into a NetSuite item object (array)

I have a source table with invoice items and I’m trying to create a NetSuite invoice object, which contains a list of items. Has anyone a good way to accomplish this? I tried a group by fields but ...
lukaszwisinski's avatar
lukaszwisinski
New Contributor
2 years ago
Copy LinkReport

Thanks koryknick 

I just wanted to confirm this functionality will not be removed.
As a workaround we can copy existing pipelines with expressions set on this field.

 

  • bojanvelevski's avatar
    bojanvelevski
    Valued Contributor
    5 years ago
    Copy LinkReport

    Hey @deepak.shaw,

    You should escape the controll characters like new line. Try .replaceAll(‘\n’,‘\n’) on the JSON string, and than parse it.

    Regards,

    Bojan

  • deepak_shaw's avatar
    deepak_shaw
    Contributor
    5 years ago
    Copy LinkReport

    Hi,

    Thanks for the reply… but suddenly it starts working, without doing any changes, it parses correctly with replacing any character.