ADO.NET Provider 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 Accepts Output Streams Description
SavedSearch String False The name of the saved search. This will be the name of the resulting table.
SavedSearchId String False The InternalId of the saved search.
SavedSearchDescription String False An optional description of the saved search.
SearchType String False 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 False An integer designating the number of results to sample.

The default value is 50.

FileStream String True A data stream object to which the search results will be written if no file path is specified in the Location input.

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