Format Tools - XML to Recordset

The XML to Recordset Tool is used to create a Task Step that converts XML produced by other tools such as connector tools feeding other systems into Recordsets for use in the many other tools which consume recordsets for uses such as powering alerts via fax/email/sms, create reports, power a workflow, perform FTP transfer, etc.

The options set in the configuration of the step determine the fields present in the output recordset. Only those fields selected from the tree structure will be created in the output recordset.

At runtime, the data exposed in the output Recordset of the step is a union of all the child objects selected in the XML structure, thereby converting the hierarchical data contained within the XML into a flat recordset as used by many other tools in TaskCentre.

» Third party product and technology license disclaimer

Download Resources

Works with other Tools

These are other Tools that this Tool will interact directly with whether by exposing information to it or consuming information from it.

Query Database
Call Procedure
Save as File
Format as Text
Format as HTML
Run Crystal Report
File Transfer (FTP)
Run Program
Call COM Object
Run VB Script
Decision
Data Filter

Dependencies

These are other products, technologies, protocols or systems that are required for the tool to work.

• None

Consumes

Objects that the Tool consumes that are exposed by other actions. Match these with ‘Exposes’ in other Tool specifications.

• XML Documents – Hierarchically structured information

Exposes

Objects that the Tool exposes that can be utilised by other tools. Match these with ‘Consumes’ in other Tool specifications.

• Recordset - Information Structured into Columns and Rows