Here is the list of examples that may help you to better understand the principles of using an X-SQLT language. All examples listed here (and even more) can be found in an X-SQLT installation folder, so you can try them in practice.
Files and databases, referenced in all examples, are located relatively to a given sample project, so you can find them in the same folder, or somewhere near.
- Convert CSV to XML
- Convert CSV to XML with namespaces
- Convert XML to CSV
- Convert XML to CSV using path filter
- Convert XML to CSV using path filter with namespaces
- Convert XML to JSON
- Convert JSON to XML
- Convert JSON to XML using path filter
- Filter XML by XPath
- Filter XML by XPath using selection namespaces
- Get a value from XML by XPath
- Transform XML with XSLT
- Extract data from database using SQL
- Extract data from database using SQL (parameterized)
- Extract data from database using command-line only
- Import data into database
- pdScript transformation
- VBScript transformation with parameters
- Script conditions