AnsweredAssumed Answered

How to find record count of Netsuite Query Response

Question asked by spotlapally on Sep 27, 2016
Latest reply on Sep 28, 2016 by Sjaak Overgaauw

For checking duplicates in the destination system(Netsuite), Im using a Decision shape which is having a connector call querying the Netsuite system with Name as parameter and it returns internal id. Im checking that if the internal id exists then it is duplicate. However, when there is more than one record in Netsuite with same name it gives an error "Nested connector call returned more than 1 document" on the decision step

 

 

So, I want my query to the Netsuite system to return count of rows instead of multiple internal IDs and if the count is greater than one then I will consider it as Duplicate. How do I get the Netsuite query to return count of records and is there a better way of checking duplicates. Please help.

Outcomes