CreateSchema
Generates a schema file that defines the structure of an XML collection, including element names and data types.
CreateSchema
Creates a local schema file (.rsd) from an existing table or view in the data model.
The schema file is created in the directory set in the Location connection property when this procedure is executed. You can edit the file to include or exclude columns, rename columns, or adjust column datatypes.
The connector checks the Location to determine if the names of any .rsd files match a table or view in the data model. If there is a duplicate, the schema file will take precedence over the default instance of this table in the data model. If a schema file is present in Location that does not match an existing table or view, a new table or view entry is added to the data model of the connector.
Input
| Name | Type | Description |
| TableName | String | Specifies the name of the XML table for which the schema file will be created. |
| URI | String | Specifies the Uniform Resource Identifier (URI) of the XML resource from which the schema will be generated. |
| XPath | String | Specifies the XPath expression that identifies a repeating element at the same hierarchy level within the XML document. This path determines how the document is divided into multiple rows. |
| WriteToFile | String | Indicates whether the generated schema should be written directly to a file. The default value is 'true'. To write the schema to FileStream or FileData instead, set to 'false'. |
| FileName | String | Specifies the full name and path of the generated schema file. |
| Method | String | Defines the HTTP method used to retrieve the XML data, such as GET or POST.
The default value is GET. |
| ContentType | String | Specifies the Content-Type header included in the request, particularly when sending data through the PostData field. |
| Data | String | Contains the data payload to be sent in the body of the HTTP request when applicable. |
Result Set Columns
| Name | Type | Description |
| Result | String | Indicates whether or not the operation was successful. |
| FileData | String | Returns the generated schema content encoded in base64. This output is provided only when WriteToFile is set to 'false' and FileStream is not used. |