Welcome to ThinkTalent.us

Technical Blog by ThinkTalent.net

tt_staff
March 24, 2014

Taleo Web Services – Candidate Service

In looking at the services, I selected candidate as the first one to test. I’m using Soap UI for my testing purposes. I’ve created a project utilizing the Think Talent partner zone candidate service by entering the copied URL for the WSDL. Here is what I’m presented with:

WebServiceCandidateService

Comments Off on Taleo Web Services – Candidate Service InTaleo Web Services
tt_staff
March 10, 2014

TCC – A SAX parsing error occurred

One of the most general errors you will encounter in TCC is the dreaded SAX parsing error.  It happens often and gives you no clue as to what went wrong.

SAXerror

The way to get it to give you the details of the error is to go into the post processing tab of the config file and uncheck the ‘Fail on export error’ checkbox.  While this won’t fix the error it will now return the error (more specifically the field that’s causing the error) in the response file.

UncheckFailOnError

1 Comment on TCC – A SAX parsing error occurred InTCC
tt_staff
March 7, 2014

TCC – Response File Encoding

This applies to the encoding of the file that TCC produces for the response.  Let’s say you need it in something other that UTF-8.  In this case we’d like to see it in ISO-8859-1.  First you have to specify the response encoding in the configuration general tab:

ResponseEncoding1

If you were to save and run at this point, it will fail.  In the manual you will find this on the subject:

The Encoding states the way the file is encoded. The Taleo environment only supports UTF-8 encoding.
Conversion is available in the Pre- and post-processing steps. -p55 TCC-13B-UserManual

This means that there needs to be a post processing step to change the encoding, fortunately it’s a pre-populated function called ‘Convert Encoding’.  Simply add that into the post processing step after the Strip SOAP step as shown below and you’re good to go.

ResponseEncoding2

1 Comment on TCC – Response File Encoding InTCC
tt_staff
March 7, 2014

TCC – Max Offer Filter for New Hire

This complex filter ensures that you are pulling the most recent offer information with the new hire.


<quer:filtering xmlns:quer="http://www.taleo.com/ws/integration/query">
 <quer:equal>
 <quer:field path="Offers"/>
 <quer:query projectedClass="Offer" alias="My_Offer_Subquery">
 <quer:projections>
 <quer:projection alias="MaxOffer">
 <quer:maximum>
 <quer:field path="Offers,Number"/>
 </quer:maximum>
 </quer:projection>
 </quer:projections>
 <quer:filterings>
 <quer:filtering>
 <quer:equal>
 <quer:field path="Application,Offers"/>
 <quer:field ownerQuery="NewHire" path="Offers,Number"/>
 </quer:equal>
 </quer:filtering>
 </quer:filterings>
 </quer:query>
 </quer:equal>
</quer:filtering>
Comments Off on TCC – Max Offer Filter for New Hire InTCC
tt_staff
February 23, 2014

JobTemplate default CSV export template (fixed)

Retrieved off of 12C, other versions not tested.


<?xml version="1.0" encoding="UTF-8"?>
<quer:query productCode="PRO1001" model="http://www.taleo.com/ws/tee800/2009/01" projectedClass="JobTemplate" locale="en" mode="CSV" csvheader="true" csvdelimiter="|" csvquote="&quot;" largegraph="true" preventDuplicates="false" xmlns:quer="http://www.taleo.com/ws/integration/query"><quer:subQueries/><quer:projections><quer:projection>
 <quer:field path="EffectiveFrom"/>
 </quer:projection><quer:projection>
 <quer:field path="EffectiveTill"/>
 </quer:projection><quer:projection>
 <quer:field path="JobCode"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,AdditionalInformation"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,CreationDate"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,DepartmentString"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,DescriptionActive"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,DescriptionBaseLocale"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,DescriptionExternal"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,DescriptionExternalHTML"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,DescriptionInternal"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,DescriptionInternalHTML"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,EmployeeStatus,Active"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,EmployeeStatus,Number"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,EmploymentEquityEstablishment,Description"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,ExternalBonusAmount"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,ExternalBonusTracking"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,ExternalQualification"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,ExternalQualificationHTML"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,HighQuartileSalary"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,HireType,Active"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,HireType,Description"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,HireType,Number"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,InternalBonusAmount"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,InternalBonusTracking"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,InternalQualification"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,InternalQualificationHTML"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,JobBoardDescription"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,JobField,Code"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,JobField,Name"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,JobGrade"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,JobLevel,Active"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,JobLevel,Number"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,JobSchedule,Active"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,JobSchedule,Number"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,JobShift,Active"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,JobShift,Number"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,JobType,Active"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,JobType,Number"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,LastModifiedDate"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,LowQuartileSalary"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,MidPointSalary"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,Number"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,OfferParameter,MaximumSalary"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,OfferParameter,PayFrequencyBasis,Description"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,OfferParameter,PayFrequencyBasis,Number"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,OfferParameter,Salary"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,OfferParameter,SignOnBonus"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,Organization,Name"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,OtherCosts"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,OvertimeStatus,Description"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,OvertimeStatus,Number"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,PrimaryLocation,Code"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,PrimaryLocation,Name"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,RelocationCosts"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,SourcingBudget"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,StudyLevel,Active"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,StudyLevel,Number"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,Title"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,TravelCosts"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,WillingnessToTravel,Active"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,WillingnessToTravel,Number"/>
 </quer:projection><quer:projection>
 <quer:field path="JobInformation,WillingnessToTravel,Value"/>
 </quer:projection><quer:projection>
 <quer:field path="State,Description"/>
 </quer:projection><quer:projection>
 <quer:field path="State,Number"/>
 </quer:projection></quer:projections><quer:projectionFilterings/><quer:filterings><quer:filtering>
 <quer:equal>
 <quer:field path="JobCode"/>
 <quer:string>INSERT JOB CODE HERE</quer:string>
 </quer:equal>
 </quer:filtering></quer:filterings><quer:sortings/><quer:sortingFilterings/><quer:groupings/><quer:joinings/></quer:query>
Comments Off on JobTemplate default CSV export template (fixed) InTCC
tt_staff
February 10, 2014

TCC – Lower Child Entity Structure in the GUI

It would seem that you can progress further into an entity than indicated by the entity structure listed in TCC.  This is some really great news.  The issue is that I needed to return the Agency when the hire type was going to be contingent.  But when digging down the application entity, you’re halted at Candidate,TalentUser,Profile,RecruitmentSource as seen here:

It seems that if you know the path to a related entity (including child entities) you can dig in and show that information, for example:
Candidate,TalentUser,Profile,RecruitmentSource,ParentSource,Description will actually return the agency name.

Comments Off on TCC – Lower Child Entity Structure in the GUI InTCC
tt_staff
February 9, 2014

TCC – Max Function

I killed myself for hours on this, still never got it but it was created for me by a smarter mind:

<quer:filtering xmlns:quer="http://www.taleo.com/ws/integration/query">
<quer:or>
<quer:equal>
<quer:field path="ProfileInformation,Experiences,DisplaySequence"/>
<quer:query projectedClass="Application" alias="expSubQuery">
<quer:projections>
<quer:projection>
<quer:maximum>
<quer:field path="ProfileInformation,Experiences,DisplaySequence"/>
</quer:maximum>
</quer:projection>
</quer:projections>
<quer:filterings>
<quer:filtering>
<quer:equal>
<quer:field ownerQuery="expSubQuery" path="Number"/>
<quer:field ownerQuery="mainQuery" path="Number"/>
</quer:equal>
</quer:filtering>
</quer:filterings>
</quer:query>
</quer:equal>
<quer:isNull>
<quer:field path="ProfileInformation,Experiences,DisplaySequence"/>
</quer:isNull>
</quer:or>
</quer:filtering>
Comments Off on TCC – Max Function InTCC
tt_staff
February 9, 2014

TCC – Case by Value

So we’ve established that case can be done by criterion or value.  Criterion has been done previously in the blog, here is how to do it by value:


<quer:projection alias="testCase" xmlns:quer="http://www.taleo.com/ws/integration/query">
<quer:switchByValue>
<quer:baseValue>
<quer:field path="Requisition,JobInformation,HireType,Description"/>
</quer:baseValue>
<quer:cases>
<quer:case>
<quer:string>Contingent</quer:string>
<quer:string>This is temp work</quer:string>
</quer:case>
</quer:cases>
<quer:defaultValue>
<quer:string> </quer:string>
</quer:defaultValue>
</quer:switchByValue>
</quer:projection>
Comments Off on TCC – Case by Value InTCC
tt_staff
January 30, 2014

TCC – LessThanOrEqual (Expirience)

This is a less than or equal to X to return work experiences.

<quer:filtering xmlns:quer="http://www.taleo.com/ws/integration/query">
 <quer:or>
 <quer:lessThanOrEqual>
 <quer:field path="ProfileInformation,Experiences,DisplaySequence"/>
 <quer:integer>1</quer:integer>
 </quer:lessThanOrEqual>
 <quer:isNull>
 <quer:query projectedClass="Experience" alias="My_Exp_SubQuery">
 <quer:projections>
 <quer:projection alias="My_Exp_Alias">
 <quer:field path="DisplaySequence"/>
 </quer:projection>
 </quer:projections>
 <quer:filterings>
 <quer:filtering>
 <quer:equal>
 <quer:field path="Number"/>
 <quer:field ownerQuery="NewHire" path="ProfileInformation,Experiences"/>
 </quer:equal>
 </quer:filtering>
 </quer:filterings>
 </quer:query>
 </quer:isNull>
 </quer:or>
</quer:filtering>

 

Comments Off on TCC – LessThanOrEqual (Expirience) InTCC