Is there an AWS API to query the price of the different AWS products?

The Price List Query API and the Bulk API is the best you can do. There is no handy RESTful API if that's what you're looking for. The pricing results may be quite large, as you observed, but perhaps you can cache it locally after downloading once? If you run the code on an EC2 instance then it should be quite fast to download.