Connector Improvement: Workday HCM: Add option to enable Include_Reference_Descriptors_In_Response in the header of the SOAP API requests
CompletedHi Fivetran team,
As a context, some of the values we received from the Workday HCM connector is the Reference ID of the field as opposed to the label or descriptor shown in the Workday UI. This creates a difficulty as we have to map the descriptors to the business value and to validate. For example, we have Termination Category with the descriptor "Other" that has the Ref ID "TERMINATION_CATEGORY-3-1". The value returned in `primary_termination_category` column in `worker` and `worker_history` table is "TERMINATION_CATEGORY-3-1" and therefore this needs some mapping.
After discussing with the Workday system admin in the company, I found that it is possible to have the descriptors returned in the SOAP API by updating the Header as follows:
<bsvc:Workday_Common_Header>
<bsvc:Include_Reference_Descriptors_In_Response>true</bsvc:Include_Reference_Descriptors_In_Response>
</bsvc:Workday_Common_Header>
Is it possible to have this feature as an option in the Connector Setup please?
Thank you,
Michael
-
Official comment
Hi everyone,
We've included descriptors for the requested tables. See our release notes here for more details. Thank you to everyone on this thread for your feedback and patience throughout the process.
Thanks,
Frank -
Hi Michael,
Thanks for sending this request. I will have to have our team look into this to confirm if this is possible. Is primary_termination_category the only field where you are looking at this for or are there other fields?
Frank
-
Hi Frank,
I would like this to be implemented on all the fields or endpoints. This is observed in Organization, Leave Type, Employee Type, and more.I am hoping this could be a toggle flag in the Connection Setup similar to Sync Custom and Calculated fields feature as the common header would need to be added to the SOAP API request.
Thank you.
Michael
Please sign in to leave a comment.
Comments
3 comments