SavedSearchRawXML
Outputs the raw eXtensible Markup Language (XML) structure for a specified saved search, aiding in search customization and API integration in NetSuite.
Table Specific Information
Select
The NetSuite connector requires filtering on SearchType and SavedSearchId in order to perform the query.
For example:
SELECT * FROM SavedSearchRawXML WHERE SearchType='Customer' AND SavedSearchId=10;
Columns
| Name | Type | Description |
| SavedSearchId | String | A unique identifier assigned to the saved search within NetSuite. This ID is used to reference the specific search when retrieving or managing search results programmatically. |
| SearchType | String | Specifies the category or method of the search performed, such as transaction, customer, or item searches. It determines how the saved search processes and structures data within NetSuite.
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. |
| ResponseXML | String | Contains the raw XML output generated from the search results, providing a structured format that is useful for integrations, automated workflows, and reporting applications requiring direct data extraction. |