Excel Add-In for NetSuite

Build 25.0.9434

CreateSavedSearchSchema

Generates and saves the schema for a specified NetSuite Saved Search, enabling structured data queries.

Input

Name Type Description
SavedSearch String The name of the saved search. This will be the name of the resulting table.
SavedSearchId String The InternalId of the saved search.
SavedSearchDescription String An optional description of the saved search.
SearchType String The type of search being used. Values include: 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
ResultsToSample String An integer designating the number of results to sample.

The default value is 50.

Result Set Columns

Name Type Description
FileData String Contains the file data if the Location input parameter is not provided.
Result String Returns Success or Failure.
SchemaFile String The generated schema file.
Columns String The number of columns found.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434