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.