PureConnect

Discussion Thread View
Expand all | Collapse all

How to use the DataManager Query to get Contact List Sources entries?

  • 1.  How to use the DataManager Query to get Contact List Sources entries?

    GCAP Member
    Posted 02-05-2021 12:20
    The documentation is pretty scant for the DMQ tool, so I was hoping someone would be able to provide me with an example of how to use it to get the entries for a contact list source?  The XML is pretty opaque...

    FWIW I'd much rather do this using ICWS, but my own research didn't turn up anything useful on that front unfortunately.
    #Handlers

    ------------------------------
    Tyler Style
    Interactive Intelligence Engineer, WellCare Health Plans
    ------------------------------


  • 2.  RE: How to use the DataManager Query to get Contact List Sources entries?

    GCAP Member
    Posted 02-05-2021 13:08
    I should mention I've fiddled some and can get results, but can't actually get what I want entirely.

    From the sample query in the docs, I have

    <query>
    <querymode>contact</querymode>
    <rowlimit>1000</rowlimit>
    <sortorder>ID</sortorder>
    <timeout>10000</timeout>
    <source>Transfer Directory</source>
    <attributes>
    <field>FirstName</field>
    <field>LastName</field>
    <field>Name</field>
    <field>BusinessPhone</field>
    <field>Workgroups</field>
    <field>Extension</field>
    </attributes>
    </query>

    However, I'm not getting back the data I expect:
    • rowlimit doesn't seem to matter - I'm always getting back 200 entries
    • fields don't seem to matter - I only ever get Name and BusinessPhone (tho to be fair those are the only two fields populated AFAIK)
    Plus, there doesn't seem to be any way to paginate?  How can I get the next page of data, or all the data at once?

    ------------------------------
    Tyler Style
    Interactive Intelligence Engineer, WellCare Health Plans
    ------------------------------