We've dealt with parse.com - nosql database for VBA, cParseCom examples and shown the code at parse.com api class for VBA. Here's a few selected topics to help you understand a lottle more about how the API works
Any parse.com query parameters such as count, skip, limit, order etc can be added to any query as an additional argument. Here's how .count() deals with modifying any parameters you supply (in the queryParams argument).
There are various limits, such as how many results can be returned , and how many records can be batched at once. Most of this is dealt with automatically (for example if you delete 100 records and the batch limit is 25, the API will automatically make 4 batched calls). Update and Create work the same way. However, you need to deal with limits when doing a Query yourself. This is to protect against memory leaks with big classes. Here's how to change the limit to a query.
A Parse query has a maximum of 1000, and a default of 100. If your query has or might have more than the limit, you need to deal with it using skip. Here's how cParseCom deals with updating more objects than the limit by doing multiple queries using the skip parameter.
Parse.com can usually make sense of data types from the data it gets sent. One exception is dates, which it expects in ISO format. Here's how cDataSet.jobject deals with converting Excel dates to ISO. In addition parse needs the date field to be explicitly typed.
The .jobject property of cDataSet takes a couple of arguments that tell it whether its doing stuff for parse.com.
Converting back and forwards (and preserving the number of milliseconds) is done with this (I haven't done timezones yet)
You can get me on Google plus, Twitter or this forum. See parse.com - nosql database for VBA for more on this topic
Services > Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation > Parse.com > parse.com - nosql database for VBA >