Referens för Workday-attribut för Microsoft Entra-ID
Det här avsnittet innehåller en lista över attribut som du kan hämta från Workday med hjälp av XPATH-frågor. Baserat på Workday Web Services API-versionen planerar du att använda, se lämpligt avsnitt.
XPATH-värden för Workday Web Services (WWS) API v21.1
Tabellen nedan innehåller en lista över Workday-attribut och motsvarande XPATH-uttryck som skickas ut ur rutan med anslutningsappen för inkommande Workday-etableringsappar. Dessa XPATH-värden används om ingen versionsinformation anges i anslutnings-URL:en eller om versionen är inställd på v21.1.
| # | Namn på workday-attribut | Workday XPATH API-uttryck |
|---|---|---|
| 1 | Aktiv | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Active/text() |
| 2 | AddressLine2Data | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_2']/text() |
| 3 | AddressLine3Data | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_3']/text() |
| 4 | AddressLine4Data | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_4']/text() |
| 5 | AddressLine5Data | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_5']/text() |
| 6 | AddressLine6Data | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_6']/text() |
| 7 | AddressLine7Data | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_7']/text() |
| 8 | AddressLine8Data | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_8']/text() |
| 9 | AddressLine9Data | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_9']/text() |
| 10 | AddressLineData | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data/text() |
| 11 | BusinessTitle | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Title/text() |
| 12 | Företag | wd:Worker/wd:Worker_Data/wd:Organization_Data/wd:Worker_Organization_Data[translate(string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID ']),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='COMPANY']/wd:Organization_Reference/@wd:Descriptor |
| 13 | ContingentWorkerID | wd:Worker/wd:Worker_Reference/wd:ID[@wd:type='Contingent_Worker_ID']/text() |
| 14 | CountryReference | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Country_Reference/wd:ID[@wd:type='ISO_3166-1_Alpha-3_Code']/text() |
| 15 | CountryReferenceFriendly | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Country_Reference/@wd:Descriptor |
| 16 | CountryReferenceNumeric | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Country_Reference/wd:ID[@wd:type='ISO_3166-1_Numeric-3_Code']/text() |
| 17 | CountryReferenceTwoLetter | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Country_Reference/wd:ID[@wd:type='ISO_3166-1_Alpha-2_Code']/text() |
| 18 | CountryRegionReference | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Country_Region_Reference/@wd:Descriptor |
| 19 | EmailAddress | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Email_Address_Data[translate(string(wd:Usage_Data/wd:Type_Data/wd:Type_Reference/@wd:Descriptor),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='WORK']/wd:Email_Address/text() |
| 20 | EmployeeID | wd:Worker/wd:Worker_Reference/wd:ID[@wd:type='Employee_ID']/text() |
| 21 | FacilityLocation | wd:Worker/wd:Worker_Data/wd:Organization_Data/wd:Worker_Organization_Data[translate(string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID'']),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='FACILITY']/wd:Organization_Reference/@wd:Descriptor |
| 22 | Fax | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[translate(string(wd:Phone_Device_Type_Reference/@wd:Descriptor),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'))='FAX' and translate(string(wd:Usage_Data/wd:Type_Data/wd:Type_Reference/@wd:Descriptor),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='WORK']/@wd:Formatted_Phone |
| 23 | FirstName | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Legal_Name_Data/wd:Name_Detail_Data/wd:First_Name/text() |
| 24 | JobClassificationID | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Job_Classification_Summary_Data/wd:Job_Classification_Reference/wd:ID[@wd:type='Job_Classification_Reference_ID']/text() |
| 25 | JobFamilyID | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Job_Profile_Summary_Data/wd:Job_Family_Reference/wd:ID[@wd:type='Job_Family_ID']/text() |
| 26 | LastName | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Legal_Name_Data/wd:Name_Detail_Data/wd:Last_Name/text() |
| 27 | LeaveAbsenceType | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Leave_Status_Data[wd:On_Leave='1']/wd:Leave_of_Absence_Type_Reference/wd:ID[@wd:type='Leave_of_Absence_Type_ID']/text() |
| 28 | LocalReference | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Local_Reference/wd:ID[@wd:type='Locale_ID']/text() |
| 29 | LocationIdentifier | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Location_Reference/wd:ID[@wd:type='Location_ID']/text() |
| 30 | ManagerReference | wd:Worker/wd:Worker_Data/wd:Management_Chain_Data/wd:Worker_Supervisory_Management_Chain_Data[position()=1]/wd:Management_Chain_Data[last()=position()]/wd:Manager_Reference/wd:ID[@wd:type='WID']/text() |
| 31 | Mellannamn | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Legal_Name_Data/wd:Name_Detail_Data/wd:Middle_Name/text() |
| 32 | Mobilt | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[translate(string(wd:Phone_Device_Type_Reference/@wd:Descriptor),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'')='MOBILE' and translate(string(wd:Usage_Data/wd:Type_Data/wd:Type_Reference/@wd:Descriptor),'abcdefghijknopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='WORK']/@wd:Formatted_Phone |
| 33 | Kommun | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Municipality/text() |
| 34 | PositionID | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Position_ID/text() |
| 35 | PositionTitle | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Position_Title/text() |
| 36 | PostalCode | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Postal_Code/text() |
| 37 | PreferredFirstName | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Preferred_Name_Data/wd:Name_Detail_Data/wd:First_Name/text() |
| 38 | PreferredLastName | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Preferred_Name_Data/wd:Name_Detail_Data/wd:Last_Name/text() |
| 39 | PreferredMiddleName | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Preferred_Name_Data/wd:Name_Detail_Data/wd:Middle_Name/text() |
| 40 | PreferredNameData | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Preferred_Name_Data/wd:Name_Detail_Data/@wd:Formatted_Name |
| 41 | PrimaryWorkTelephone | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[wd:Usage_Data/wd:Type_Data/@wd:Primary='1' and translate(string(wd:Usage_Data/wd:Type_Data/wd:Type_Reference/@wd:Descriptor),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='WORK']/@wd:Formatted_Phone |
| 42 | StatusAcademisTenureDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Academic_Tenure_Date/text() |
| 43 | StatusActiveStatusDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Active_Status_Date/text() |
| 44 | StatusBenefitsServiceDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Benefits_Service_Date/text() |
| 45 | StatusCompanyServiceDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Company_Service_Date/text() |
| 46 | StatusContinuousFirstDayOfWork | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:First_Day_of_Work/text() |
| 47 | StatusContinuousServiceDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Continuous_Service_Date/text() |
| 48 | StatusDateEnteredWorkforce | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Date_Entered_Workforce/text() |
| 49 | StatusDaysUnemployed | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Days_Unemployed/text() |
| 50 | StatusEndEmploymentDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:End_Employment_Date/text() |
| 51 | StatusExpectedRetirementDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Expected_Retirement_Date/text() |
| 52 | StatusHireDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Hire_Date/text() |
| 53 | StatusMonthsContinuousPriorEmployment | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Months_Continuous_Prior_Employment/text() |
| 54 | StatusNotEligibleForHire | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Not_Eligible_For_Hire/text() |
| 55 | StatusNotEligibleForRehire | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Not_Eligible_for_Rehire/text() |
| 56 | StatusOriginalHireDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Original_Hire_Date/text() |
| 57 | StatusProbationEndDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Probation_End_Date/text() |
| 58 | StatusProbationStartDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Probation_Start_Date/text() |
| 59 | StatusRegrettableTermination | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Regrettable_Termination/text() |
| 60 | StatusRehire | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Rehire/text() |
| 61 | StatusResignationDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Resignation_Date/text() |
| 62 | StatusRetired | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Retired/text() |
| 63 | StatusRetirementDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Retirement_Date/text() |
| 64 | StatusRetirementEligibilityDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Retirement_Eligibility_Date/text() |
| 65 | StatusSeniorityDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Seniority_Date/text() |
| 66 | StatusSeveranceDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Severance_Date/text() |
| 67 | StatusTerminerad | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Terminated/text() |
| 68 | StatusTerminationDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Termination_Date/text() |
| 69 | StatusTerminationInvoluntary | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Termination_Involuntary/text() |
| 70 | StatusTerminationLastDayOfWork | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Termination_Last_Day_of_Work/text() |
| 71 | StatusTimeOffServiceDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Time_Off_Service_Date/text() |
| 72 | StatusVestingDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Vesting_Date/text() |
| 73 | Tillsynsorganisering | wd:Worker/wd:Worker_Data/wd:Organization_Data/wd:Worker_Organization_Data/wd:Organization_Data[translate(string(wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='SUPERVISORY']/wd:Organization_Name/text() |
| 74 | Telefon | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[translate(string(wd:Phone_Device_Type_Reference/@wd:Descriptor),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'')='TELEPHONE' and translate(string(wd:Usage_Data/wd:Type_Data/wd:Type_Reference/@wd:Descriptor),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='WORK']/@wd:Formatted_Phone |
| 75 | TransactionLogData | wd:Worker/wd:Worker_Data/wd:Transaction_Log_Entry_Data/wd:Transaction_Log_Entry |
| 76 | UserID | wd:Worker/wd:Worker_Data/wd:User_ID/text() |
| 77 | WID | wd:Worker/wd:Worker_Reference/wd:ID[@wd:type='WID']/text() |
| 78 | WorkerID | wd:Worker/wd:Worker_Data/wd:Worker_ID/text() |
| 79 | WorkerType | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Worker_Type_Reference/@wd:Descriptor |
| 80 | WorkSpaceReference | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Work_Space__Reference/@wd:Descriptor |
XPATH-värden för Workday Web Services (WWS) API v30+
Om du använder WWS API v30.0 eller senare i anslutnings-URL:en enligt nedan:
... innan du aktiverar etableringsjobbet uppdaterar du XPATH API-uttrycken under Attributmappning –> Avancerade alternativ –> Redigera attributlista för Workday för att använda värdena som anges i tabellen.
Information om hur du konfigurerar ytterligare XPATH:er finns i avsnittet Självstudie: Hantera konfigurationen.
| # | Namn på workday-attribut | Workday XPATH API-uttryck |
|---|---|---|
| 1 | Aktiv | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Active/text() |
| 2 | AddressLine2Data | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_2']/text() |
| 3 | AddressLine3Data | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_3']/text() |
| 4 | AddressLine4Data | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_4']/text() |
| 5 | AddressLine5Data | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_5']/text() |
| 6 | AddressLine6Data | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_6']/text() |
| 7 | AddressLine7Data | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_7']/text() |
| 8 | AddressLine8Data | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_8']/text() |
| 9 | AddressLine9Data | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_9']/text() |
| 10 | AddressLineData | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data/text() |
| 11 | BusinessTitle | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Title/text() |
| 12 | Företag | wd:Worker/wd:Worker_Data/wd:Organization_Data/wd:Worker_Organization_Data[translate(string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']]),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='COMPANY']/wd:Organization_Data/wd:Organization_Name/text() |
| 13 | ContingentWorkerID | wd:Worker/wd:Worker_Reference/wd:ID[@wd:type='Contingent_Worker_ID']/text() |
| 14 | CountryReference | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Country_Reference/wd:ID[@wd:type='ISO_3166-1_Alpha-3_Code']/text() |
| 15 | CountryReferenceFriendly | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Country_Reference/@wd:Descriptor |
| 16 | CountryReferenceNumeric | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Country_Reference/wd:ID[@wd:type='ISO_3166-1_Numeric-3_Code']/text() |
| 17 | CountryReferenceTwoLetter | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Country_Reference/wd:ID[@wd:type='ISO_3166-1_Alpha-2_Code']/text() |
| 18 | CountryRegionReference | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Country_Region_Descriptor/text() |
| 19 | EmailAddress | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Email_Address_Data[wd:Usage_Data/@wd:Public='1' och string(wd:Usage_Data/wd:Type_Data/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='WORK']/wd:Email_Address/text() |
| 20 | EmployeeID | wd:Worker/wd:Worker_Reference/wd:ID[@wd:type='Employee_ID']/text() |
| 21 | FacilityLocation | wd:Worker/wd:Worker_Data/wd:Organization_Data/wd:Worker_Organization_Data/wd:Organization_Data[translate(string(wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID ']),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='LOCATION_HIERARCHY']/wd:Organization_Name/text() |
| 22 | Fax | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[wd:Usage_Data/@wd:Public='1' och string(wd:Usage_Data/wd:Type_Data/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='WORK' och string(wd:Phone_Device_Type_Reference/wd:ID[@wd:type='Phone_Device_Type_ID'])='Fax']/@wd: Workday_Traditional_Formatted_Phone |
| 23 | FirstName | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Legal_Name_Data/wd:Name_Detail_Data/wd:First_Name/text() |
| 24 | JobClassificationID | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Job_Classification_Summary_Data/wd:Job_Classification_Reference/wd:ID[@wd:type='Job_Classification_Reference_ID']/text() |
| 25 | JobFamilyID | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Job_Profile_Summary_Data/wd:Job_Family_Reference/wd:ID[@wd:type='Job_Family_ID']/text() |
| 26 | LastName | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Legal_Name_Data/wd:Name_Detail_Data/wd:Last_Name/text() |
| 27 | LeaveAbsenceType | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Leave_Status_Data[wd:On_Leave='1']/wd:Leave_of_Absence_Type_Reference/wd:ID[@wd:type='Leave_of_Absence_Type_ID']/text() |
| 28 | LocalReference | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Local_Reference/wd:ID[@wd:type='Locale_ID']/text() |
| 29 | LocationIdentifier | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Location_Reference/wd:ID[@wd:type='Location_ID']/text() |
| 30 | ManagerReference | wd:Worker/wd:Worker_Data/wd:Management_Chain_Data/wd:Worker_Supervisory_Management_Chain_Data[position()=1]/wd:Management_Chain_Data[last()=position()]/wd:Manager_Reference/wd:ID[@wd:type='WID']/text() |
| 31 | Mellannamn | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Legal_Name_Data/wd:Name_Detail_Data/wd:Middle_Name/text() |
| 32 | Mobilt | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[wd:Usage_Data/@wd:Public='1' och string(wd:Usage_Data/wd:Type_Data/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='WORK' och string(wd:Phone_Device_Type_Reference/wd:ID[@wd:type='Phone_Device_Type_ID'])='Mobile']/@wd: Workday_Traditional_Formatted_Phone |
| 33 | Kommun | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Municipality/text() |
| 34 | PositionID | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Position_ID/text() |
| 35 | PositionTitle | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Position_Title/text() |
| 36 | PostalCode | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Postal_Code/text() |
| 37 | PreferredFirstName | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Preferred_Name_Data/wd:Name_Detail_Data/wd:First_Name/text() |
| 38 | PreferredLastName | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Preferred_Name_Data/wd:Name_Detail_Data/wd:Last_Name/text() |
| 39 | PreferredMiddleName | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Preferred_Name_Data/wd:Name_Detail_Data/wd:Middle_Name/text() |
| 40 | PreferredNameData | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Preferred_Name_Data/wd:Name_Detail_Data/@wd:Formatted_Name |
| 41 | PrimaryWorkTelephone | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[wd:Usage_Data/@wd:Public='1' och string(wd:Usage_Data/wd:Type_Data/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='WORK' och string(wd:Phone_Device_Type_Reference/wd:ID[@wd:type='Phone_Device_Type_ID'])='Fastline']/@wd: Workday_Traditional_Formatted_Phone |
| 42 | StatusAcademisTenureDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Academic_Tenure_Date/text() |
| 43 | StatusActiveStatusDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Active_Status_Date/text() |
| 44 | StatusBenefitsServiceDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Benefits_Service_Date/text() |
| 45 | StatusCompanyServiceDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Company_Service_Date/text() |
| 46 | StatusContinuousFirstDayOfWork | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:First_Day_of_Work/text() |
| 47 | StatusContinuousServiceDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Continuous_Service_Date/text() |
| 48 | StatusDateEnteredWorkforce | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Date_Entered_Workforce/text() |
| 49 | StatusDaysUnemployed | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Days_Unemployed/text() |
| 50 | StatusEndEmploymentDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:End_Employment_Date/text() |
| 51 | StatusExpectedRetirementDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Expected_Retirement_Date/text() |
| 52 | StatusHireDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Hire_Date/text() |
| 53 | StatusMonthsContinuousPriorEmployment | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Months_Continuous_Prior_Employment/text() |
| 54 | StatusNotEligibleForHire | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Not_Eligible_For_Hire/text() |
| 55 | StatusNotEligibleForRehire | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Not_Eligible_for_Rehire/text() |
| 56 | StatusOriginalHireDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Original_Hire_Date/text() |
| 57 | StatusProbationEndDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Probation_End_Date/text() |
| 58 | StatusProbationStartDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Probation_Start_Date/text() |
| 59 | StatusRegrettableTermination | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Regrettable_Termination/text() |
| 60 | StatusRehire | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Rehire/text() |
| 61 | StatusResignationDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Resignation_Date/text() |
| 62 | StatusRetired | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Retired/text() |
| 63 | StatusRetirementDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Retirement_Date/text() |
| 64 | StatusRetirementEligibilityDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Retirement_Eligibility_Date/text() |
| 65 | StatusSeniorityDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Seniority_Date/text() |
| 66 | StatusSeveranceDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Severance_Date/text() |
| 67 | StatusTerminerad | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Terminated/text() |
| 68 | StatusTerminationDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Termination_Date/text() |
| 69 | StatusTerminationInvoluntary | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Termination_Involuntary/text() |
| 70 | StatusTerminationLastDayOfWork | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Termination_Last_Day_of_Work/text() |
| 71 | StatusTimeOffServiceDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Time_Off_Service_Date/text() |
| 72 | StatusVestingDate | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Vesting_Date/text() |
| 73 | Tillsynsorganisering | wd:Worker/wd:Worker_Data/wd:Organization_Data/wd:Worker_Organization_Data/wd:Organization_Data[translate(string(wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='SUPERVISORY']/wd:Organization_Name/text() |
| 74 | Telefon | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[wd:Usage_Data/@wd:Public='1' och string(wd:Usage_Data/wd:Type_Data/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='WORK' och string(wd:Phone_Device_Type_Reference/wd:ID[@wd:type='Phone_Device_Type_ID'])='Fastline']/@wd: Workday_Traditional_Formatted_Phone |
| 75 | TransactionLogData | wd:Worker/wd:Worker_Data/wd:Transaction_Log_Entry_Data/wd:Transaction_Log_Entry |
| 76 | UserID | wd:Worker/wd:Worker_Data/wd:User_ID/text() |
| 77 | WID | wd:Worker/wd:Worker_Reference/wd:ID[@wd:type='WID']/text() |
| 78 | WorkerID | wd:Worker/wd:Worker_Data/wd:Worker_ID/text() |
| 79 | WorkerType | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Worker_Type_Reference[wd:ID/@wd:type="Contingent_Worker_Type_ID" eller wd:ID/@wd:type="Employee_Type_ID"]/@wd:Descriptor |
| 80 | WorkSpaceReference | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Work_Space__Reference/@wd:Descriptor |
Anpassade XPATH-värden
Tabellen nedan innehåller en lista över andra vanliga anpassade XPATH API-uttryck när du etablerar arbetare från Workday till Active Directory eller Microsoft Entra ID. Testa XPATH API-uttrycken som tillhandahålls här med din version av Workday med hjälp av anvisningarna i avsnittet Självstudie: Hantera konfigurationen.
Om du vill lägga till fler attribut i XPATH-tabellen till förmån för kunder som implementerar den här integreringen lämnar du en kommentar nedan eller bidrar direkt till artikeln.
| # | Namn på workday-attribut | Workday API-version | Workday XPATH API-uttryck |
|---|---|---|---|
| 1 | Universellt ID | v30.0+ | wd:Worker/wd:Worker_Data/wd:Universal_ID/text() |
| 2 | Användarnamn | v30.0+ | wd:Worker/wd:Worker_Data/wd:User_Account_Data/wd:User_Name/text() |
| 3 | ID på hanteringsnivå | v30.0+ | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Job_Profile_Summary_Data/wd:Management_Level_Reference/wd:ID[@wd:type="Management_Level_ID"]/text() |
| 4 | Hire Rescinded | v30.0+ | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Hire_Rescinded/text() |
| 5 | Tilldelad etableringsgrupp | v21.1+ | wd:Worker/wd:Worker_Data/wd:Account_Provisioning_Data/wd:Provisioning_Group_Assignment_Data[wd:Status='Assigned']/wd:Provisioning_Group/text() |
XPATH-funktioner som stöds
Nedan visas listan över XPATH-funktioner som stöds av Microsoft .NET XPATH-biblioteket som du kan använda när du skapar ditt XPATH API-uttryck.
- name
- senaste
- position
- sträng
- Delsträng
- concat
- substring-after
- starts-with
- stränglängd
- innehåller
- översätta
- normalize-space
- substring-before
- boolean
- true
- not
- falskt
- Nummer
- tak
- summa
- avrunda
- floor