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 ...
arvindnsn's avatar
arvindnsn
Contributor
7 years ago
Copy LinkReport

Thanks for the Solution. The Solution is almost what i need except the "Transaction_id should be displayed at the header level only. “The tenders” child array also displays the “TRANSACTION_ID” attribute which i don’t want to display at the tenders level.

I tried removing by having empty expression variable for “transactiod_id” in the “Remove groupBy tenders” Snap but didn’t work. It would be really helpful if this is sorted.

Thanks

  • 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.