Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Error: NetSuite Analytics connector's "Execute SuiteQL Query" returns missing or duplicate data

  • Last updated on

Errors

The NetSuite Analytics connector's "Execute SuiteQL Query" command will sometimes return unexpected results when compared to the source dataset in NetSuite. Though no error is displayed, a comparison between the two datasets will reveal some datasets are "missing" while others are displayed multiple times.

Cause

NetSuite's API limits each Execute SuiteQL response to 1000 records, so the requestor needs to send a followup request with an offset to fetch the rest of the results. Every followup request is then re-run by NetSuite, leading the same record to appear in a different place.

Solution

To resolve this issue, go to NetSuite and add an ORDER BY clause to a unique field in your query. This ensures each record will always have the same position in the result set. 

Learn more:

Was this article helpful?
0 out of 0 found this helpful
Errors The NetSuite Analytics connector's "Execute SuiteQL Query" command will sometimes return unexpected results wh...