cancel
Showing results for 
Search instead for 
Did you mean: 

How to get only required fields from netsuite search

abhinav
New Contributor

Hi,

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.

Thanks,
Abhinav.

1 REPLY 1

ptaylor
Employee
Employee

(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.