本節提供您可使用 XPATH 查詢從 Workday 擷取的屬性清單。 根據您打算使用的 Workday Web 服務 API 版本,請參閱適當的章節。
Workday Web 服務 (WWS) API v21.1 的 XPATH 值
下表所擷取的 Workday 屬性和對應的 XPATH 運算式清單,會現成隨附於 Workday 輸入佈建應用程式連接器。 如果連線 URL 中未指定任何版本資訊,或如果版本設定為 v21.1,則會使用這些 XPATH 值。
| # | Workday 屬性名稱 | Workday XPATH API 運算式 |
|---|---|---|
| 1 | 使用中 | 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 | 公司 | 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 | 國家參考數字 | 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 | 國家參考雙字母碼 | 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 | 國家地區參考資料 | 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 | 電子郵件地址 | 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:描述元),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='WORK']/wd:Email_Address/text() |
| 20 | 員工編號 | 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 | 傳真 | 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 | 名字 | 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 | 姓氏 | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Legal_Name_Data/wd:Name_Detail_Data/wd:Last_Name/text() |
| 二十七 | 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() |
| 二十九 | 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 | 中間名 | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Legal_Name_Data/wd:Name_Detail_Data/wd:Middle_Name/text() |
| 32 | 行動 | 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),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='WORK']/@wd:Formatted_Phone |
| 33 | 市 | 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 | 郵遞區號 | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Postal_Code/text() |
| 37 | 偏好名字 | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Preferred_Name_Data/wd:Name_Detail_Data/wd:First_Name/text() |
| 38 | 優先姓氏 | 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 | 連續工作首日狀態 | 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 | 狀態日期進入職場 | 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 | 狀態終止工作日期 | 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 | 狀態雇用日期 | 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 | 狀態初始聘用日期 | 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() |
| 六十 | StatusRehire | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Rehire/text() |
| 61 | 狀態辭職日期 | 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 | 狀態退休日期 | 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 | StatusTerminated | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Terminated/text() |
| 68 | 狀態終止日期 | 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 | 監督組織 | 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 | 電話 | 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() |
| 七十八 | WorkerID | wd:Worker/wd:Worker_Data/wd:Worker_ID/text() |
| 79 | 工人類型 | 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 |
Workday Web 服務 (WWS) API v30+ 的 XPATH 值
如果您在連線 URL 中使用 WWS API v30.0 或更高版本,如下所示:
...接著,在開啟佈建作業之前,請先更新 [屬性對應] -> [進階選項] -> [編輯 Workday 的屬性清單] 下的 [XPATH API 運算式],以使用資料表中所列的值。
若要設定其他 XPATHs,請參閱教學課程:管理您的設定一節。
| # | Workday 屬性名稱 | Workday XPATH API 運算式 |
|---|---|---|
| 1 | 使用中 | 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 | 公司 | 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 | 國家參考數字 | 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 | 國家參考雙字母碼 | 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 | 國家地區參考資料 | 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 | 電子郵件地址 | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Email_Address_Data[wd:Usage_Data/@wd:Public='1' and string(wd):Usage_Data/wd:Type_Data/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='WORK']/wd:Email_Address/text() |
| 20 | 員工編號 | 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 | 傳真 | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[wd:Usage_Data/@wd:Public='1' and string(wd:Usage_Data/wd:Type_Data/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='WORK' and string(wd:Phone_Device_Type_Reference/wd:ID[@wd:type='Phone_Device_Type_ID'])='Fax']/@wd:Workday_Traditional_Formatted_Phone |
| 23 | 名字 | 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 | 姓氏 | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Legal_Name_Data/wd:Name_Detail_Data/wd:Last_Name/text() |
| 二十七 | 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() |
| 二十九 | 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 | 中間名 | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Legal_Name_Data/wd:Name_Detail_Data/wd:Middle_Name/text() |
| 32 | 行動 | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[wd:Usage_Data/@wd:Public='1' and string(wd:Usage_Data/wd:Type_Data/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='WORK' and string(wd:Phone_Device_Type_Reference/wd:ID[@wd:type='Phone_Device_Type_ID'])='Mobile']/@wd:Workday_Traditional_Formatted_Phone |
| 33 | 市 | 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 | 郵遞區號 | 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 | 偏好名字 | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Preferred_Name_Data/wd:Name_Detail_Data/wd:First_Name/text() |
| 38 | 優先姓氏 | 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' and string(wd:Usage_Data/wd:Type_Data/ wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='WORK' and string(wd:Phone_Device_Type_Reference/wd:ID[@wd:type='Phone_Device_Type_ID'])='Landline']/@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 | 連續工作首日狀態 | 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 | 狀態日期進入職場 | 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 | 狀態終止工作日期 | 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 | 狀態雇用日期 | 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 | 狀態初始聘用日期 | 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() |
| 六十 | StatusRehire | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Rehire/text() |
| 61 | 狀態辭職日期 | 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 | 狀態退休日期 | 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 | StatusTerminated | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Terminated/text() |
| 68 | 狀態終止日期 | 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 | 監督組織 | 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 | 電話 | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[wd:Usage_Data/@wd:Public='1' and string(wd:Usage_Data/wd:Type_Data/ wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='WORK' and string(wd:Phone_Device_Type_Reference/wd:ID[@wd:type='Phone_Device_Type_ID'])='Landline']/@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() |
| 七十八 | WorkerID | wd:Worker/wd:Worker_Data/wd:Worker_ID/text() |
| 79 | 工人類型 | 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” 或 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 |
自訂 XPATH 值
下表提供從 Workday 將背景工作角色佈建至 Active Directory 或 Microsoft Entra ID 時,其他常用自訂 XPATH API 運算式的清單。 請參考教學課程:管理您的設定一節中所述的指示,使用您的 Workday 版本測試此處提供的 XPATH API 運算式。
若要將多個屬性新增至 XPATH 資料表,以取得客戶實作此整合的優點,請在下方留言,或直接對文章投稿。
| # | Workday 屬性名稱 | Workday API 版本 | Workday XPATH API 運算式 |
|---|---|---|---|
| 1 | 通用識別碼 | v30.0+ | wd:Worker/wd:Worker_Data/wd:Universal_ID/text() |
| 2 | 使用者名稱 | v30.0+ | wd:Worker/wd:Worker_Data/wd:User_Account_Data/wd:User_Name/text() |
| 3 | 管理層級識別碼 | 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 | 撤銷雇用 | v30.0+ | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Hire_Rescinded/text() |
| 5 | 指派的佈建群組 | v21.1+ | wd:Worker/wd:Worker_Data/wd:Account_Provisioning_Data/wd:Provisioning_Group_Assignment_Data[wd:Status='Assigned']/wd:Provisioning_Group/text() |
支援的 XPATH 函數
以下提供的是 Microsoft .NET XPATH 程式庫所支援的 XPATH 函數清單,您可以在建立 XPATH API 運算式時使用這些函數。
- NAME
- 最後一
- 位置
- 字串
- 子字串
- concat
- substring-after
- starts-with
- string-length
- 包含
- 翻譯
- normalize-space
- substring-before
- 布爾值
- 是
- 不是
- 假的
- 數值
- 天花板
- 總和
- 圓形
- 地板