Netsuite Export - export record only once

Integrator.io
1

Hi Everyone,

I’d like to ask if there’s a way to get around this. In NetSuite, I have two custom records. A Parent and a Child record.

When creating the saved search, I’m using the Parent record type and joining fields from the Child record.

In Celigo, I’m using a single export that points to the Parent record and references a checkbox field there. However, I’ve noticed that it only exports 1,000 records at a time, so I need to manually uncheck the box in the NetSuite parent record to process the remaining records.

I hope my inquiry makes sense. I just wanted to confirm if this is expected behavior in Celigo, and if so, is there a possible workaround to handle more than 1,000 records automatically?

Thank you

2

Hi Marco,

Per our documentation, this behavior is expected: NetSuite returns a maximum of 1,000 records per request. You can read more here: Fine-tune integrator.io for optimal performance and data throughput.

Currently, your export is set to “Once”, which in some cases can cause issues: if the flow fails midway, the checkbox may already be marked, preventing reprocessing unless you manually uncheck the records.

A possible alternative is to use a Delta export instead. With Delta:

  1. The first export processes all existing records.

  2. Subsequent runs only capture updates or new records.

  3. You can add a writeback function in your import to mark the checkbox automatically, eliminating the need for manual unchecking.

This approach helps ensure all records are processed reliably, even if the flow encounters interruptions.

1 Like
3

Are you using the group rows by internal id function or you want these child records to process in your flow independently?

4

Hi @tylerlamparter, I want to process these child records independently

5

Hi Nel, thanks for the reply. I'll do more research about it