JDBC Driver for NetSuite

Build 22.0.8462

CreateSavedSearchSchema

Creates the schema for the table specified. Saves the schema at the location set by the Location connection property.

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 An instance of an output stream where file data is written to. Only used if Location is not set.

Result Set Columns

Name Type Description
FileData String If the Location input is empty.
Result String Returns Success or Failure.
SchemaFile String The generated schema file.
Columns String The number of columns found.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462