NetSuite Import Mapping to update existing Contract Lines

Integrator.io
1

Hello!

I am trying to query line data of NetSuite Contract (native transaction type = estimate). I am querying all three line Ids using saved search

  1. Line
  2. Line Sequence Number
  3. Line Unique Key
    In a later step I am trying to update these NetSuite Contrace lines in a NetSuite Import.
    In the import I see following Line Id fields for Contract Items
  4. Line ID
  5. Line Number (fieldid: linenum)
  6. Line Number (fieldid: linenumber)

Which Line ID from Transaction Saved Search should be mapped to which NS Import Line ID so that it will successfully update the lines without getting following errors:

  1. “Failed to save record because Please enter a value for amount.“ I am using following mapping

image

Thanks!

2

Hi @sujitdesai :waving_hand:
I've endorsed this to our CEE team, and they're currently looking into this. I will let you know as soon as there's an update. Thanks!

3

@sujitdesai

Can you please share your flow ZIP and the sample input JSON?