Can someone please suggest how I can find underlying addresses (or balance/transactions) from an xpub, zpub, or ypub bitcoin address, using an API or offline tool?

I'm a developer working on an application. The ultimate goal is to find Bitcoin balances and transactions. All API's I've found so far don't offer it (e.g. Tatum, Moralis, Quicknode, …). And example code/tools I've found on the internet don't work anymore. I don't mind paying for a subscription service.

Can anyone please help, it's taken me over 2 weeks of searching. Or can you recommend a different approach?

Thanks