Is it possible to get live data?
Currently the snap shot of the data are at least a day old, is it possible get use API calls to get live data?
You cannot get anything fresher than the 24-36 hour thing with Canvas Data right now.
In some cases, you can roll a custom solution where you pull from Canvas data and then get the rest through the API, but many API calls do not support a date feature as a filter, so that's going to be limited.
Anything that comes through the API is pulled from live data at the time. Reports may be a few minutes old before you get them.
As to whether or not you can get the data that you want in a live form, that's a different question. Some things are only accessible through Canvas Data (delayed) and some are only available through the API (live) and some aren't available at all except through the web-interface or perhaps undocumented AJAX calls (live).
We can't answer that question about getting live data without knowing what exactly you're looking for. There has been talk of providing incremental updates throughout the day with Canvas Data so that the delay is less, but it still wouldn't be truly live.
Some things are available in both Canvas Data and the API, but they're so large that obtaining them through the API is not realistic. For example, our requests table is currently 20GB compressed and 98GB uncompressed.
Sorry for not being clear in my initial question. I know you can get live data by using Canvas API calls, but for the most part you are only getting individual records from the table. I was hoping there was a way to get tables of data instead, but I understand why it's not that way, because some table can get really big like "enrollment". So I turned to reports like provisioning reports, it provides live data, and it also provides "tables of data", but problem with that is you don't get all the data that you want from those reports.
Then I was introduced to Canvas Data, it actually have the tables of data in a nice flat file format, which can be easily imported into our database, and it also have it's API calls to make automation a possibility. The only downside is that the data is about 24-36 hrs. old.
So what I am looking for would be something that combines provisioning report and Canvas Data, where it would allow us to generate live data in the form that current Canvas data is in.
Can this be achieved in Canvas Data already, if yes, please let me know how.
Retrieving data ...