SavedSearches
Lists all saved searches within NetSuite, categorized by SearchType. Useful for understanding available search templates and their configurations.
Table Specific Information
Select
The NetSuite connector requires filtering on SearchType in order to perform the query.
For example:
SELECT * FROM SavedSearches WHERE SearchType='Customer';
Columns
| Name | Type | Description |
| InternalId | String | A system-generated unique identifier for the saved search within NetSuite. This ID is used for referencing, managing, and automating searches programmatically in scripts, integrations, or API requests. |
| Name | String | The descriptive and user-friendly name assigned to the saved search. It helps users quickly recognize the search's purpose, making it easier to locate and execute within NetSuite's search interface. |
| SearchType | String | Specifies the category or data type that the saved search queries, such as transactions, customers, items, employees, or vendors. This classification is essential for filtering results and structuring reports effectively.
The allowed values are Account, AccountingPeriod, AccountingTransaction, BillingAccount, BillingSchedule, Bin, Bom, BomRevision, Budget, CalendarEvent, Campaign, Charge, Classification, Contact, ContactCategory, ContactRole, CostCategory, ConsolidatedExchangeRate, CouponCode, CurrencyRate, Customer, CustomerCategory, CustomerMessage, CustomerStatus, CustomerSubsidiaryRelationship, CustomList, CustomRecord, Department, Employee, EntityGroup, ExpenseCategory, FairValuePrice, File, Folder, GiftCertificate, GlobalAccountMapping, HcmJob, InboundShipment, InventoryNumber, Item, ItemAccountMapping, ItemDemandPlan, ItemRevision, ItemSupplyPlan, Issue, Job, JobStatus, JobType, Location, ManufacturingCostTemplate, ManufacturingOperationTask, ManufacturingRouting, MerchandiseHierarchyNode, Message, Nexus, Note, NoteType, Opportunity, OtherNameCategory, Partner, PartnerCategory, Paycheck, PaymentMethod, PayrollItem, PhoneCall, PriceLevel, PricingGroup, ProjectTask, PromotionCode, ResourceAllocation, RevRecSchedule, RevRecTemplate, SalesRole, SalesTaxItem, Solution, SiteCategory, Subsidiary, SupportCase, Task, TaxGroup, TaxType, Term, TimeBill, TimeSheet, Topic, Transaction, UnitsType, Usage, Vendor, VendorCategory, VendorSubsidiaryRelationship, WinLossReason. |