How to access XML Search Request Examples via XML worksheet
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:
- Boolean Examples
- Date Examples
- Number/Amount Examples
- String Examples
- 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>