Skip to main content
Mitratech Success Center

Client Support Center

Need help? Click a product group below to select your application and get access to knowledge articles, webinars, training content, and release notes or to contact our support team.

Authorized users - log in to create a ticket, view tickets status and check your success plan details.

 

How to access XML Search Request Examples via XML worksheet

  1. Last updated
  2. Save as PDF
This article provides the information about how to access the XML Search Request Examples via XML worksheet.

XML Search Request Examples

This appendix provides XML search request examples for the following data types:

  1. Boolean Examples
  2. Date Examples
  3. Number/Amount Examples
  4. String Examples
  5. Search for Project Examples

Boolean Examples

Search Request 
<TeamConnectRequest>
<Authentication>
    <Username>george</Username>
    <Password>password</Password>
</Authentication>
<Search>
    <Query>
    <Entity>Contact</Entity>
    <Criteria>
        <Detail.CONT_EMPL.Married is="equals">1</Detail.CONT_EMPL.Married>
    </Criteria>
    </Query>
    <SearchResults>
        <Contact>
            <PrimaryKey/>
            <Name/>
            <FirstName/>
            <SsOrTaxNumberString/>
            <Phone>
                <Type>
                    <Name/>
                </Type>
                <PhoneString/>
            </Phone>
            <Email>
                <Type>
                    <Name/>
                </Type>
                <EmailString/>
            </Email>
            <Skill>
                <Type>
                    <Name/>
                </Type>
                <SkillLevel/>
            </Skill>
            <DefaultRateValue/>
            <Detail select="Detail[CONT_EMPL]">
                <DateOfHire select="DetailValue[DateOfHire]"/>
                <AnnualSalary select="DetailValue[AnnualSalary]"/>
                <Comments select="DetailValue[Comments]"/>
            </Detail>
        </Contact>
    </SearchResults>
</Search>
</TeamConnectRequest>

TeamConnect Response
<TeamConnectResponse><Authentication><SessionID>7073657502003817083</SessionID></Authentication>
<Contact key="202" version="0"><PrimaryKey>202</PrimaryKey>
<Name>Carter</Name>
<FirstName>Helen</FirstName>
<SsOrTaxNumberString>623-52-8541</SsOrTaxNumberString>
<Phone key="152" version="0"><Type key="PHON_HOME" version="1"><Name>Home</Name>
</Type>
<PhoneString>(818) 572-0315</PhoneString>
</Phone>
<Phone key="153" version="0"><Type key="PHON_BUS1" version="1"><Name>Business</Name>
</Type>
<PhoneString>(310) 280-0660 ext.840</PhoneString>
</Phone>
<Phone key="154" version="0"><Type key="PHON_MOBI"
version="1"><Name>Mobile</Name>
</Type>
<PhoneString>(818) 269-8021</PhoneString>
</Phone>
<Email key="103" version="0"><Type key="MAIL_BUS1"
version="1"><Name>Business</Name>
</Type>
<EmailString>andrea@mitratech.com</EmailString>
</Email>
<Email key="102" version="0"><Type key="MAIL_PER1"
version="1"><Name>Personal</Name>
</Type>
<EmailString>andrea@cmu.com</EmailString>
</Email>
<Skill key="62" version="0"><Type key="SKIL_LITI"
version="1"><Name>Litigation</Name>
</Type>
<SkillLevel>3</SkillLevel>
</Skill>
<DefaultRateValue>100</DefaultRateValue>
<Detail key="CONT_EMPL" version="0"><DateOfHire>1996-04-01T00:00:00+00:00</DateOfHire>
<AnnualSalary>75000</AnnualSalary>
<Comments>Helen is an exceptional employee and is a great asset to our company.</Comments>
</Detail>
</Contact>
</SearchResults>
</TeamConnectResponse>

Date Examples

Search Request
<TeamConnectRequest>
<Authentication>
    <Username>george</Username>
    <Password>password</Password>
</Authentication>
<Search>
    <Query>
    <Entity>Task</Entity>
    <Criteria>
        <And>
            <CompletedOn is="equals">2005-07-14</CompletedOn>
            <PriorityIID is="equals">1</PriorityIID>
        </And>
    </Criteria>
    </Query>
    <SearchResults>
        <Task>
            <PrimaryKey/>
            <Name/>
            <ShortDescription/>
            <ActivityItem>
                <Name/>
            </ActivityItem>
            <RateAmount/>
            <ActualHours/>
            <TotalAmount/>
            <Contact>
                <SsOrTaxNumberString/>
            </Contact>
            <Project>
                <NumberString/>
            </Project>
        </Task>
    </SearchResults>
</Search>
</TeamConnectRequest>

TeamConnect Response
<TeamConnectResponse><Authentication><SessionID>411261600526049936</SessionID></Authentication><SearchResults>
<Task key="110" version="0"><PrimaryKey>110</PrimaryKey>
<ShortDescription>Review Policy</ShortDescription>
<ActivityItem key="ACTI_BILL" version="1"><Name>Bill</Name>
</ActivityItem>
<RateAmount>75.00000</RateAmount>
<ActualHours>5.00000</ActualHours>
<TotalAmount>375.00000</TotalAmount>
<Contact key="24" version="0"><SsOrTaxNumberString>562-35-3251</SsOrTaxNumberString>
</Contact>
<Project key="152" version="0"><NumberString>AP-03211</NumberString>
</Project>
</Task>
</SearchResults>
</TeamConnectResponse>

Number/Amount Examples

Search Request 
<TeamConnectRequest>
<Authentication>
    <Username>george</Username>
    <Password>password</Password>
</Authentication>
<Search>
    <Query>
    <Entity>Project</Entity>
    <Criteria>
        <NumberString is="equals">03-15-2005</NumberString>
    </Criteria>
    </Query>
    <SearchResults>
        <Project>
            <Name/>
            <Application/>
            <OpenedOn/>
            <Assignee>
                <User>
                    <Contact>
                        <Name/>
                        <FirstName/>
                    </Contact>
                </User>
                <IsActive/>
            </Assignee>
            <MainAssignee>
                <User>
                    <Contact>
                        <FirstName/>
                        <Name/>
                    </Contact>
                </User>
            </MainAssignee>
            <Detail select="Detail[CLAM_AUTO]">
                <InsuredState select="DetailValue[InsuredState]"/>
                <VIN select="DetailValue[VIN]"/>
                <LossLocation select="DetailValue[LossLocation]"/>
            </Detail>
            <Parent>
                <Name/>
                <NumberString/>
            </Parent>
        </Project>
    </SearchResults>
</Search>
</TeamConnectRequest>

TeamConnect Response
<TeamConnectResponse><Authentication><SessionID>6942614420833689264</SessionID>
</Authentication><SearchResults><Project key="195" version="0"><Application key="CLAM" version="20"></Application>
<OpenedOn>2005-03-15T12:30:00+00:00</OpenedOn>
<Assignee key="132" version="1"><User key="jane" version="0"><Contact key="18" version="0"><Name>Smeeth</Name>
<FirstName>Jane</FirstName>
</Contact>
</User>
<IsActive>true</IsActive>
</Assignee>
<Assignee key="133" version="1"><User key="charlotte"
version="0"><Contact key="25" version="0"><Name>Krackenberg</Name>
<FirstName>Charlotte</FirstName>
</Contact>
</User>
<IsActive>false</IsActive>
</Assignee>
<Assignee key="130" version="1"><User key="jessica" version="0"><Contact
key="9" version="0"><Name>Polanski</Name>
<FirstName>Jessica</FirstName>
</Contact>
</User>
<IsActive>true</IsActive>
</Assignee>
<Assignee key="131" version="1"><User key="jake" version="0"><Contact
key="17" version="0"><Name>Ashby</Name>
<FirstName>Jake</FirstName>
</Contact>
</User>
<IsActive>true</IsActive>
</Assignee>
<MainAssignee key="132" version="1"><User key="jane" version="0"><Contact
key="18" version="0"><FirstName>Jane</FirstName>
<Name>Smeeth</Name>
</Contact>
</User>
</MainAssignee>
<Detail key="CLAM_AUTO" version="1"><InsuredState>1</InsuredState>
<VIN>326513256214586</VIN>
<LossLocation>The incident occurred on Broadway, where the insured
resides.</LossLocation>
</Detail>
<Parent key="194" version="0"><Name>MacDonald, Amy's Policy</Name>
<NumberString>AP-053214</NumberString>
</Parent>
</Project>
</SearchResults>
</TeamConnectResponse>

String Examples

Search Request
<TeamConnectRequest>
<Authentication>
    <Username>george</Username>
    <Password>password</Password>
</Authentication>
<Search>
    <Query>
    <Entity>Account</Entity>
    <Criteria>
        <Name is="like">Auto Claims</Name>
    </Criteria>
    </Query>
    <SearchResults>
    <Account>
        <PrimaryKey/>
            <Name/>
            <IsActive/>
            <ApplStartOn/>
            <ApplEndOn/>
            <TypeIID/>
            <OverdraftTypeIID/>
            <AllocationLimit/>
            <DefaultCategory>
                <Name/>
                <TreePosition/>
                <PrimaryKey/>
            </DefaultCategory>
        </Account>
    </SearchResults>
</Search>
</TeamConnectRequest>

TeamConnect Response
<TeamConnectResponse><Authentication><SessionID>8906496126402937066</SessionID></Authentication><SearchResults>
<Account key="118" version="1"><PrimaryKey>107</PrimaryKey>
<Name>Auto Claims 2005 Account</Name>
<IsActive>true</IsActive>
<ApplStartOn>2005-01-01T00:00:00+00:00</ApplStartOn>
<ApplEndOn>2005-12-31T00:00:00+00:00</ApplEndOn>
<TypeIID>2</TypeIID>
<OverdraftTypeIID>2</OverdraftTypeIID>
<AllocationLimit>10000000</AllocationLimit>
<DefaultCategory key="ACCT_PJCT" version="1"><Name>Project</Name>
<TreePosition>ACCT_PJCT</TreePosition>
<PrimaryKey>100</PrimaryKey>
</DefaultCategory>
</Account>
</SearchResults>
</TeamConnectResponse>

Search for Project Examples

Search Request
<TeamConnectRequest>
<Authentication>
    <Username>a</Username>
    <Password>a</Password>
</Authentication>
<Search>
    <Query>
    <Entity>Project</Entity>
    <Criteria>
        <And>
            <Application.ProjObjectDefinition.UniqueCode is="equal">MATT</Application.ProjObjectDefinition.UniqueCode>
            <Name is="beginswith">avtest</Name>
        </And>
    </Criteria>
    </Query>
<SearchResults>
    <Project>
        <Name />
        <NumberString />
        <CurrentPhaseType>
        <Name />
        </CurrentPhaseType>
        </Project>
        </SearchResults>
    </Search>
</TeamConnectRequest>

TeamConnect Response
<TeamConnectResponse>
<Authentication>
    <SessionID>7774214887184924364</SessionID>
</Authentication>
    <SearchResults>
        <Project key="102" version="1">
            <Name>avtest</Name>
            <NumberString>12</NumberString>
            <CurrentPhaseType key="6" version="1">
                <Name>Open</Name>
            </CurrentPhaseType>
        </Project>
    </SearchResults>
</TeamConnectResponse>

Compact Search Request
<TeamConnectRequest>
    <Authentication>
        <Username>a</Username>
        <Password>a</Password>
    </Authentication>
    <Search>
        <Query>
            <Entity>Project</Entity>
            <Criteria>
                <And>
                    <Application.ProjObjectDefinition.UniqueCode is="equal">MATT</Application.ProjObjectDefinition.UniqueCode>
                    <Name is="beginswith">avtest</Name>
                </And>
            </Criteria>
        </Query>
    <SearchResults>
        <Project>
            <Name/>
            <NumberString />
            <Phase select="CurrentPhaseType/Name" />
            <Phase select="CurrentPhaseType/UniqueCode" />
        </Project>
    </SearchResults>
</Search>
</TeamConnectRequest>

Compact TeamConnect Response
<TeamConnectResponse>
    <Authentication>
        <SessionID>970861401575968901</SessionID>
    </Authentication>
    <SearchResults>
        <Project key="102" version="1">
            <Name>avtest</Name>
            <NumberString>12</NumberString>
            <Phase>Open</Phase>
            <Phase>OPEN</Phase>
        </Project>
    </SearchResults>
</TeamConnectResponse>
  1. Back to top
  • Was this article helpful?

Recommended articles

  1. Article type
    Topic
  2. Tags
    1. Search Request
    2. XLM Search
    3. XML worksheet