Workday GET_PAYMENT_ELECTION_ENROLLMENTS API筛选条件咨询

Workday Cash Management模块的GET_PAYMENT_ELECTION_ENROLLMENTS为SOAP协议接口，原生支持Request_Criteria节点传入筛选规则，IICS预置连接器未暴露请求条件配置入口时，直接使用自定义请求体模式传入带筛选逻辑的Payload即可，无需拉取全量数据后做二次过滤。

• 进入IICS的Workday连接操作配置页，放弃使用预置的GET_PAYMENT_ELECTION_ENROLLMENTS默认操作模板，选择「自定义SOAP请求」模式
• 将下方示例Payload粘贴到请求编辑区，替换凭证、租户、筛选条件为实际业务值，可按需增删国籍、城市、员工ID等筛选维度
• 响应解析规则直接映射Payment_Election_Enrollment节点下的银行账号、开户行、支付优先级等目标字段即可

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:bsvc="urn:com.workday/bsvc">
   <soapenv:Header>
      <bsvc:Workday_Common_Header>
         <bsvc:Include_Reference_Descriptors_In_Response>false</bsvc:Include_Reference_Descriptors_In_Response>
      </bsvc:Workday_Common_Header>
      <wsse:Security soapenv:mustUnderstand="1" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd">
         <wsse:UsernameToken>
            <wsse:Username>{API账号}@{租户ID}</wsse:Username>
            <wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">{API账号密码}</wsse:Password>
         </wsse:UsernameToken>
      </wsse:Security>
   </soapenv:Header>
   <soapenv:Body>
      <bsvc:Get_Payment_Election_Enrollments_Request bsvc:version="{你租户使用的Workday版本号，如v39.0}">
         <bsvc:Request_Criteria>
            <!-- 国籍筛选示例：筛选中国籍员工 -->
            <bsvc:Nationality_Criteria>
               <bsvc:Country_Reference bsvc:Descriptor="China">
                  <bsvc:ID bsvc:type="ISO_3166-1_Alpha-2_Code">CN</bsvc:ID>
               </bsvc:Country_Reference>
            </bsvc:Nationality_Criteria>
            <!-- 城市筛选示例：筛选上海办公地址的员工 -->
            <bsvc:Person_Address_Criteria>
               <bsvc:City_Data>
                  <bsvc:City>Shanghai</bsvc:City>
               </bsvc:City_Data>
               <bsvc:Address_Usage_Data bsvc:Address_Usage_Type="WORK">
                  <bsvc:Type_Reference bsvc:Descriptor="Work">
                     <bsvc:ID bsvc:type="Address_Usage_Type_ID">WORK</bsvc:ID>
                  </bsvc:Type_Reference>
               </bsvc:Address_Usage_Data>
            </bsvc:Person_Address_Criteria>
            <!-- 指定员工ID范围筛选，按需放开注释即可
            <bsvc:Worker_Reference>
               <bsvc:ID bsvc:type="Employee_ID">{员工工号1}</bsvc:ID>
            </bsvc:Worker_Reference>
            <bsvc:Worker_Reference>
               <bsvc:ID bsvc:type="Employee_ID">{员工工号2}</bsvc:ID>
            </bsvc:Worker_Reference>
            -->
            <bsvc:Exclude_Inactive_Workers>true</bsvc:Exclude_Inactive_Workers>
         </bsvc:Request_Criteria>
         <bsvc:Response_Filter>
            <bsvc:Page>1</bsvc:Page>
            <bsvc:Count>999</bsvc:Count>
         </bsvc:Response_Filter>
         <bsvc:Response_Group>
            <bsvc:Include_Bank_Account_Data>true</bsvc:Include_Bank_Account_Data>
            <bsvc:Include_Payment_Election_Data>true</bsvc:Include_Payment_Election_Data>
            <bsvc:Include_Worker_Summary_Data>true</bsvc:Include_Worker_Summary_Data>
         </bsvc:Response_Group>
      </bsvc:Get_Payment_Election_Enrollments_Request>
   </soapenv:Body>
</soapenv:Envelope>

注意：如果请求报字段不存在错误，可从Workday租户后台下载对应版本的Cash Management模块WSDL文件，核对筛选节点的路径和字段名即可，不同Workday版本的节点定义可能存在小幅差异。

内容的提问来源于stack exchange，提问作者Anand Krishna Iyer