...
SOAtest converts between CSV and and XML format to facilitate the rapid configuration, sending, and validation of CSV messages.
...
- Attach an XML Converter to the Response Output of the Messaging Client.
- Set the format to CSV and adjust that tool’s conversion options as needed.
- Attach a an XML Data Bank (to extract values) or other XML tools (to perform validations against specific values within the CSV).
...
The following conversion options are available in CSV Client and CSV Call Back tools:
- Separator -: Specifies which separator is used in the CSV file.
- Quote -: Specifies which quote character is used. Quotes can be used around individual values in a CSV file. They are used in cases where the value contains the separator character that is used is used in the file, or in cases where a quote appears in the value (if a single quote appears in the value, you would use a double quote to surround the value; if a double quote appears in the value, you would use a single quote to surround the value). If no quotes appear, you can use either single or double quotes to surround the value.
- Trim leading/trailing whitespace -: Specifies whether or not to strip whitespace from the beginning and end of the value.
- First row specifies column names -: Specifies whether or not to consider the first row of the CSV file as column names. If the first row specifies column names, the elements in Form XML will show the column names as the name of each value. If the first row does not specify column names, then the elements in Form XML will use "value" as the name of each value.
...