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.
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. |
| 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. |