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