Some simple examples - Desktop Liberation

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

Because the GAS API is so similar to parse.com – nosql database for VBA, you may want to read that too, which has similar examples. Note that virtually all methods can be chained leading to pretty compact code.

Page Content hide

1 Retrieving an object by unique ID

2 Querying objects

3 Counting objects

4 Updating Objects

Retrieving an object by unique ID

In parse every object (row) is assigned a unique ID. If you know it you can retrieve that object. You can find it in your parse.com dashboard and substitute in a valid unique ID in the example below

function testGetItemByUniqueId () {

    // get a handle for this class
    var parseCom = cParseCom.getParsed("gasParseData",findRegistryPackage());
    
    // use a valid unique ID to get the data
    if (parseCom.getObjectById("ZflFVMnczp").isOk()) {
      Logger.log (JSON.stringify(parseCom.jObject()));
    }
    else {
      throw ("failed to get object:" + parseCom.browser().url() + ":" + parseCom.browser().status() + ":" + parseCom.browser().text());
    }

}

The results

[13-11-29 19:26:23:811 GMT] {"customerid":1,"date":"Sat Aug 10 2013 00:00:00 GMT+0100 (BST)","invoiceid":145,"quantity":9,"value":4230,"createdAt":"2013-11-29T17:25:57.655Z","updatedAt":"2013-11-29T17:25:57.655Z","objectId":"ZflFVMnczp"}

Querying objects

You can query by example, and add options like sort order

function testparsequery () {

    // get a number of items that match a query by example
    var w = getParsed("gasParseData").getObjectsByQuery( {customerid:1},{order:'-value'});
    //test if it worked, and do something with the results
    if (w.isOk() ){
      Logger.log( "all is ok"+ JSON.stringify(w.jObject()));
    }
    else {
      throw( "failed to do query:" + w.browser().url() + ":" + w.browser().status() + ":" + w.browser().text());
    }

}

The results

[13-11-29 19:16:50:352 GMT] all is ok{"results":[{"customerid":1,"quantity":9,"value":4230,"invoiceid":145,"date":"Sat Aug 10 2013 00:00:00 GMT+0100 (BST)","createdAt":"2013-11-29T17:25:57.655Z","updatedAt":"2013-11-29T17:25:57.655Z","objectId":"ZflFVMnczp"},{"customerid":1,"quantity":10,"value":3900,"invoiceid":246,"date":"7/25/2013","createdAt":"2013-11-29T17:26:00.448Z","updatedAt":"2013-11-29T17:26:00.448Z","objectId":"NgDkL6qg8u"},{"customerid":1,"quantity":3,"value":1560,"invoiceid":151,"date":"5/21/2013","createdAt":"2013-11-29T17:25:57.874Z","updatedAt":"2013-11-29T17:25:57.874Z","objectId":"XDRMUJSbaA"},{"customerid":1,"quantity":2,"value":1050,"invoiceid":175,"date":"8/22/2013","createdAt":"2013-11-29T17:25:58.538Z","updatedAt":"2013-11-29T17:25:58.538Z","objectId":"QjqVyykjip"}]}

Counting objects

You can count total number in the class, or matching a query

function testparseCount () {
    // how many records in the class
    Logger.log (getParsed("gasParseData").count());
    // how many records in the class with given query
    Logger.log (getParsed("gasParseCustomers").count({country:"Libya"}));
}

The results

[13-11-29 19:20:51:038 GMT] 308.0
[13-11-29 19:20:51:210 GMT] 1.0

Updating Objects

You can do a query, and update some or all of the fields in the matching objects

function testparseUpdate () {

    // get some items by query and change the scheme name to something else
    var w = getParsed("gasParseData").batch(true).updateObjects({customerid:39}, {customerid:1}).batch(false);
    if (w.isOk() ){
      Logger.log( "all is ok"+ JSON.stringify(w.jObject()));
    }
    else {
      throw( "failed to do query:" + w.browser().url() + ":" + w.browser().status() + ":" + w.browser().text());
    }
}

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