Update Nov2017
UPDATE:  parse.com as now been closed and moved to parseplatform.org. I will update the content of this page an move the back-end to this platform

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

Query parameters

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).

Limits

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.

Date formats

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)

Get involved

For help and more information join our forum, follow the blog or follow me on Twitter