Netsuite: How to get a rowcount as a value instead of the saved search result?

Integrator.io
1

Instead of exporting the rows in the saved search. I want to just get a count for the number of rows there are.
For example.

Saved search of transactions, returns 1000 rows to Integrator to pass along, I want to just pass a single row, with value 1000 in it.

This is for a validation process with a partner, so I need to be able to get the row count.

2

Hello Ross,

You can use the 'Count' summary type on the internal ID field after adding it as a column in the saved search.

5301043caa20740200000001-b869c683925249199f7f7a093f8ae33f.png
5301043caa20740200000001-b869c683925249199f7f7a093f8ae33f.png606×317 15.6 KB

5301043caa20740200000001-2ff47dc0e5404b6fb597c7c51fca041d.png
5301043caa20740200000001-2ff47dc0e5404b6fb597c7c51fca041d.png732×286 13.6 KB

3

Hi Ross,

Another approach would be to use the following in your Saved Search's results tab:

5301043caa20740200000001-8728aad8ae984cd5b847eb2e9a572a2a.png


This could potentially be more accurate for other record types where the results include line information, for instance, a Sales Order record, which would have the same Internal ID for those lines.

Best Regards,
Dan

4

Thanks Dan, Thats exactly what I was looking for.