CreateSchema
Creates a custom schema file based on the CRM View name, FetchXML expression, or SQL query. If Query is not specified, the TableName should be set to an existing CRM View name.
Stored Procedure-Specific Information
To create a schema from a saved CRM View, enter:EXEC CreateSchema TableName = 'My Custom View'
To create a schema from a SQL query, enter:
EXEC CreateSchema TableName = 'My Sql View', Query = 'SELECT id, name, modifiedon FROM account ORDER BY modifiedon DESC', Description = 'Custom SQL view'
Input
| Name | Type | Accepts Output Streams | Description |
| TableName | String | False | The name for the new table. If Query is not specified, this should be set to an existing CRM View name. |
| Query | String | False | The SQL query or FetchXML expression for table. |
| Description | String | False | An optional description for the table. |
| WriteToFile | String | False | Wheather to write the contents of this stored procedure to a file or not (Default = true) needs to be set to false to output FileStream of FileData |
| FileStream | String | True | An instance of an output stream where file data is written to. Only used if OutputFolder is not set. |
Result Set Columns
| Name | Type | Description |
| Success | String | Whether or not the schema was created successfully. |
| SchemaFile | String | The generated schema file. |
| FileData | String | File data that will be outputted encoded in Base64 if the OutputFolder and FileStream inputs are not set. |