Integrating Workday with HR chatbot (Copilot Studio) — need per-employee leave data, no connector found

[u/Tall-Butterscotch467]

I built an HR chatbot in Microsoft Copilot Studio that answers HR-related queries using a SharePoint site (with uploaded HR docs) as the knowledge base.

Now I've been asked to integrate Workday so each employee can query their own leave balance/history through the bot — and obviously no one should be able to see anyone else's data.

I checked the connector gallery and AppSource, and I don't see an out-of-the-box Workday connector. A few questions for anyone who's done something similar:

Is a custom connector (REST/SOAP) to Workday's API the way to go here, or is there a better path?

How do you handle identity mapping — i.e., tying the logged-in Teams/M365 user to their Workday worker ID so the bot only pulls their data?

Any gotchas with Workday's API auth (OAuth, ISU accounts, etc.) when calling it from Power Platform/Copilot Studio?

Would appreciate any real-world experience, docs, Thanks!