Welcome to WebmasterWorld Guest from 18.104.22.168
I beleive the only way to get actual cpc data is via the adwords api.
That is correct.
And...you have to wait a few days to get accurate information. About 1 day after a click occurs Google is pretty accurate as to the pricing and such but I have seen changes to click information several days after the click. Sometimes changes happen on the cpc but the click itself can go away several days later if Google decides it was fraud. It's not easy to sync up with Google and you will drive yourself crazy trying to sync up an external app in real time :-/