Hi Harrison,
I have gotten to play a bit with the new API for retrieving reports, and for the most part it works very well. (Aside: I noticed that "skip" in the new API includes the 'i', which I got a laugh from). We frequently pull data from QuickBase into other tools (e.g. Excel, R, Python) to run analyses, and using the API to load reports allows us to automate some of the data retrieval.
So far, I've only noticed two things worth commenting on:
- Latency - some times the data retrieval is quick, loading a 2000 x 40 report in a matter of seconds. Other times the same query will time out with a 30-second timeout set. This can happen even when the calls to the API happen sequentially. But we'll notice the same latency issues when we run reports inside of QuickBase, so this is probably not an API issue;
- Meta data on summary reports - I am told that for summary reports, all data is converted into either a number or text for display purposes. We have summary reports that summarize transactions by date. Because it is a summary report, the date is converted into text, and the meta data from the API indicates the date is text. I understand why the date is being converted into text for display in QuickBase, but it doesn't make sense that it should be converted to text when sending it to the API.
Also, the code examples for calling the API in the documentation are a nice addition. You might want to consider adding R sample code, as well as perhaps a discussion on setting up Postman to interact with the API.
Thanks,
------------------------------
Brian Yarrington
------------------------------
