How to get only required fields from netsuite search


I am doing a Netsuite search operation, and I need only 10 to 12 fields from the response, where can I provide the columns list in the snap.


(1) You can use a JSON Splitter snap and a Mapper snap after the Search snap to map only the fields you want.

(2) You can create a Saved Search in the NetSuite UI to customize the result set so it contains only the fields you want. Then in the NetSuite Search snap, click the Advanced checkbox. The input schema of the snap will change to show the criteria for a NetSuite “advanced search”, which lets you specify the ID of a Saved Search to invoke.