Can anyone point me to some thing to help me get a better understanding working with API's? I have an basic/intermediate understanding of HTML/PHP/MySQL etc, but would like to get to know about implementing API's, at least at a basic level.
By "implementing",. do you mean building your own? Or do you mean using ("consuming") others APIs? If so, from what language?
That's the question!! If web based, it would be php. If calling information into MS Office, I have no idea!!!
I'd suggest you spend some time reading about SOAP and PHP / .Net, that would cover the basics needed for a web or MS Office connection. There's no real idiot's guide, the Accounting API - Automated Bookkeeping details the KashFlow end of things