CreateSchema
Creates a custom schema file based on the CRM View name, FetchXML expression, or SQL query.
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. |