Create the XML Retrieval Specification
To retrieve information from Microsoft Dynamics, you must create an XML retrieval specification that specifies the content to retrieve and describes how to construct documents from this information. The specification refers to collections, objects, and items, which are data types stored in the Dynamics repository. OpenText recommends that the connector is configured by a Dynamics administrator who is familiar with your data.
The following XML is an example retrieval specification:
<?xml version="1.0" encoding="utf-8"?> <spec> <collection name="accounts"> <item name="accountid" /> <item name="name" /> <item name="description" /> <object name="owninguser"> <item name="employeeid" /> <item name="fullname" /> </object> <object name="parentaccountid"> <item name="accountid" /> </object> </collection> </spec>
The specification is contained within the <spec>
element, and can contain the following elements:
Element | Description | Occurrences |
---|---|---|
Collection
|
The collection element specifies a starting point for the connector. The connector creates one document for each member of the collection. |
1 or more per specification |
Object
|
Use the object element to retrieve an object from the collection or from another object and insert information about the object into the document. |
0 or more per collection, 0 or more per object |
Item
|
Use the item element to retrieve an item from the collection or from an object, and insert the value of this item into the document. |
0 or more per collection, 0 or more per object |