parse.com

Parse

cParseCom examples

January 13, 2020 Comments Off on cParseCom examples

In parse.com – nosql database for VBA, I described how to use cParseCom to be able to use parse.com directly from VBA. You can find the implementation details here parse.com api class for VBA Here’s a few […]

Apps Script & Java Script

cParseCom implementation

January 13, 2020 Comments Off on cParseCom implementation

I use scriptDB a lot , both with Google Apps Script and from other sources, including VBA, and in this blog post, I  compare parse.com performance with script DB. One of the things that Parse.com has going […]

Apps Script & Java Script

Some simple examples

January 13, 2020 Comments Off on Some simple examples

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 […]

Apps Script & Java Script

creating Parse Classes from Google Spreadsheets

January 13, 2020 Comments Off on creating Parse Classes from Google Spreadsheets

Just as in parse.com – nosql database for VBA, you’ll probably want to load up some test data from a Google Spreadsheet to a Parse.com class.  You’ll find some test data in this workbook – it’s same data […]

Parse

Query Limits on parse.com

November 13, 2019 Comments Off on Query Limits on parse.com

The first problem we hit is the 1000 object limit on parse queries. Here’s how to get round it using jQuery promises. <!DOCTYPE HTML> <html> <head> <title></title> <link rel=”stylesheet” type=”text/css” href=”css/colortable.css”> <script src=”http://www.parsecdn.com/js/parse-1.2.2.min.js”></script> <script src=”js/colortable.js”></script> […]

Parse

Updating ScriptDB

November 13, 2019 Comments Off on Updating ScriptDB

Writing to parse.com was fairly complex, with all the asynchronicity and limiting. Writing the workbook to scriptDB should be much easier. We’ll use exactly the same approach as for Updating parse.com , namely get the data, get the existing […]

Parse

Updating parse.com

November 13, 2019 Comments Off on Updating parse.com

We’ve looked at Query Limits on parse.com and Google Visualization API data to prepare for loading the color table from Playing around with GAS color into parse.com. Now to load the data Using parse.save One of the constraints of parse  is that it’s […]

Parse

Query parse.com from GAS

May 2, 2019 Comments Off on Query parse.com from GAS

First up we’ll query the colortable  created in Updating parse.com, using the parse REST API. We can’t use the javaScript API in dome way from GAS, because it’s not caja compliant – if it were, we […]

Apps Script & Java Script

parse.com – noSQL database for GAS

April 13, 2019 Comments Off on parse.com – noSQL database for GAS

Google Apps Script already has a noSQL database – scriptDB. I use it a lot, and have plenty of examples on this site. When I was developing parse.com api class for VBA , part of the motivation was […]

Microsoft Office & VBA

more complex parse API topics

April 13, 2019 Comments Off on more complex parse API topics

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 […]

Parse

Common query code

April 5, 2019 Comments Off on Common query code

Following on from Query parse.com from GAS,  and Query scriptDB from GAS here’s the common code they each need to construct and compile the queries and results. colorschemer created by GitJsonApi https://github.com/brucemcpherson/colorschemer 0 forks. 4 stars. 0 open […]

Parse

parse.com api class for VBA

March 31, 2019 Comments Off on parse.com api class for VBA

parse.com – nosql database for VBA, describes how to use this class to be able to use parse.com directly from VBA. Here’s the details of the implementation. List of functions and properties Can be found […]