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