Excel Add-In for NetSuite

Build 24.0.9060

CreateSavedSearchSchema

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

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 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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060