I really struggled to get it using python, whether it be via the Condenser API or the deprecated BEEM. All I got was bad figures and the documentation anD examples suck!

HIVE-SQL..

SELECT curation_rewards/1000.0, posting_rewards/1000.0 FROM accounts WHERE name =  '{account}'

It's periodically updated and added to the accounts table, so you are not trawling through data (which takes ages!).

You can call this via Python using the pypyodbc libary.