Extract SQL Output
Used used to extract XML into separate fields. Use with the output from the Execute SQL Select step.
Inputs
| 1. | doc | (Mandatory) | The XML document to be used for the Extract operation |
| 2. | Database Row Number | (Mandatory) | The row number from which the data is to be extracted |
| 3. | Database Field 1 | (Mandatory) | The field from which the data is to be extracted |
| 4. | Database Field 2-10 | (Optional) | The fields from which the data is to be extracted |
Fig. 1 - Extract SQL Output - Inputs
Outputs
| 1. | Result Field 1 | (Mandatory) | The field to be used to store the extracted data |
| 2. | Result Field 2-10 | (Optional) | The fields to be used to store the extracted data |
Fig. 2 - Extract SQL Output - Outputs
Outcomes
| 1. | Next | The Data Extract was successful |
| 2. | Fail | An error was returned from Softdial CallGem™ |
Fig. 3 - Extract SQL Output - Outcomes