CreateSchema
Creates an RSD schema file for a custom WooCommerce endpoint by scanning the endpoint response and inferring column names and types.
Table Specific Information
Execute
Creates an RSD schema file for a custom WooCommerce endpoint by scanning the endpoint response and inferring column names and types.
The schema file is created in the directory set in the Location connection property. You can specify the FileName input to write the schema to a different location.
To create a schema for a custom endpoint, execute:
EXEC CreateSchema EndpointName='custom-records';
Input
| Name | Type | Required | Accepts Output Streams | Description |
| EndpointName | String | True | False | The name of the custom WooCommerce endpoint to introspect (e.g., ssis-transactions). |
| FileName | String | False | False | The full path and file name of the schema file to generate. The .rsd extension is appended automatically if omitted. If not set, the schema is returned in the FileData output. |
| FileStream | String | False | True | An output stream that receives the generated schema file content. Used in place of FileName when writing to a stream is preferred. |
Result Set Columns
| Name | Type | Description |
| Result | String | Returns Success or Failure. |
| FileData | String | The generated schema encoded in base64. Only returned if FileName is not set. |