Dynamics Connector 24.1

# 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

Copyright 2023 Open Text
Version 24.1 | Last updated December 2023

Send documentation feedback

Close

Send documentation feedback

To send feedback using your default email client, open an email window.

Otherwise, send your feedback and the information below to MFI-swpdl.idoldocsfeedback@opentext.com.

We appreciate your feedback!

Product: IDOL Dynamics Connector 24.1

Topic Title: Create the XML Retrieval Specification