How to Perform Basic Database Operations: Create, Read, Update and Delete

Posted: October 13th, 2016Author:

The Backend Services consists of the following components:

  • Database – for storing any app data.
  • Server Code – for writing server-side app logic using JavaScript.
  • API Express – integrating with external systems and APIs.
  • Push Notifications – sending push messages to devices.
  • Web Hosting – publishing and hosting mobile web apps.

In this post, we will show you how a Server Code script integrates with the Database.

One of the most common questions we get is how to work with the database, how to create, edit and delete data. This makes sense as virtually any mobile app needs to store data in a database and perform these basic operations. To access the database, we are going to use Server Code script. Server Code allows writing app logic using JavaScript which will be executed on the server. For example, a script can access the database, send a Push Notification message, sort data and invoke an external REST API. We will start with the most basic operation: how to read data from the database.

The database collection used in this post looks like this:

Database collection.

Database collection.

This can be data collected from a form inside an app – a form that collects information about the user.

Reading Data

Server Code script has out-of-the-box API to access the database to perform all the basic operations. The following script reads all objects from the above collection.

One line 2, the script retrieves all the data.

One line 3, the script response is set. A Server Code script is invoked as a REST API. The code on this line defines the API response.

A script can be quickly tested from the Run tab where you can see the JSON data:

Testing the script.

Testing the script.

Reading data from a database collection is fast and simple. Next, we are going to save data into the database.

Read the rest of this entry »

How to Build and Test an Ionic SMS App with Nexmo API

Posted: October 7th, 2016Author:

This video shows how to build and test an Ionic SMS app using Nexmo API. The video tutorial first shows how to create a backend to invoke Nexmo API. Then the Ionic app is created which uses the backend. The app is then tested in the browser and on the device using the Tester app. The video also shows how to build a binary file for Android and iOS.

Also, check out how to create an app backend with API Express and Nexmo SMS API.

October Update: More Secure, Better Auto-Update, Binary Support, Google Maps and More

Posted: October 3rd, 2016Author:

We got some interesting stuff in October platform update, check out what’s new below.

More Secure with HTTPS

We switched to HTTPS to make everything more secure. If you are using any non-HTTPS API services a quick workaround is to invoke the API from the Server Code or API Express.

Improved User Experience on Android During Auto-Update

This was a long requested feature from our community. When an Android device was checking and installing auto updates, the screen would simply go black which created a pretty bad user experience. We pushed a minor update which we believe will greatly improve the user experience. If an update is available you will see a short message explaining that the app is checking and installing updates.

Send Binary Data with API Express Service

It’s now fast and simple to work with binary data inside API Express service with the new binary option. For example, you can build an API Express service which uploads binary data to an external REST API service.


API Express binary data option.

Read the rest of this entry »

Video Tutorial: How to Expose a Custom SQL Query as a Login REST API Service

Posted: September 28th, 2016Author:

This video shows how to use the SQL and Script components to build a Login service. The SQL component runs a custom SQL query to check if a user exists in a database. The Script component adds custom logic to check what the SQL component returned and defines the response (user found or user not found).

Want to learn more how to connect to enterprise data source? Watch our API Express playlist.

Updates to Salesforce Import Service Inside the App Builder

Posted: September 28th, 2016Author:

Please read about upcoming changes here. It’s important to understand that invoking Salesforce APIs (or any APIs) is now perfomed using the Server Code or API Express. This update only impacts the App Builder (development time).

Learn How to Build an Ionic App with an RSS Feed [Video]

Posted: September 9th, 2016Author:

Looking to add an RSS feed into your Ionic app? This video shows you to display an RSS feed inside an Ionic app.

Learn from other short YouTube videos on the channel.

How to Build an App with API Express and External REST API

Posted: August 30th, 2016Author:

This short video shows how to build a complete app with an external REST API. This video covers:

  • Using API Express to connect to an external REST API. is used for the API.
  • Importing API Express service into the app (App Builder).
  • Designing the app UI (1 page).
  • Binding and using the service from the page.
  • Testing the app.

Looking for more videos? Visit our YouTube channel for many more short videos.

Video: How to Import Backend Services APIs Into Your App

Posted: August 18th, 2016Author:

This short video shows how to import backend services APIs into your app. services consist of a cloud database, Server Code for custom app logic, and API Express for enterprise integration and service orchestration.

Our YouTube channel has many more short videos where you can learn how to build apps fast with

Upcoming New Pricing – Consider Subscribing at Today’s Price

Posted: August 15th, 2016Author:

Update August 25: Please see a message on pricing from our CEO.

On August 30th, 2016 we will be revamping the online pricing for the platform. Although pricing will be generally higher reflecting the significant enhancements we’ve introduced, we will grandfather in existing paid subscriptions.

Subscribe Today

If you are considering subscribing or upgrading your plan, you may want to do so before August 30th to be grandfathered in at today’s prices. Your price will be locked unless you make changes later. This is a great time to lock in the annual plan (or monthly) which has a big discount included. Please see the note about grandfathered plans at the end of this post.

New Pricing

To simplify the pricing there are now three plans: Pro, Team, and Enterprise.

The Pro plan is good for individual developers or small teams. The plan comes with 1 developer seat, and you can add 2 more developer seats to join your team.

The Team plan is for larger mobile development teams coming with 6 developer seats.

The Enterprise plan is for small, medium and large enterprises. The Enterprise plan may have any number of developer seats, apps, or API calls. It has private cloud or on-premise installation option, SLAs, and premium support.

We have also simplified and consolidated the platform API calls. There is now a single count for all platform API calls which includes: Database, Server Code, Push Notifications and API Express.

New pricing:

Cost$90/month (or $60/month annual)$200/month (or $135/month annual)Starts at $2,000/month
Seats1 included (add 2 more)6 includedAny
API calls50K200K1 Million or more
Overages$0.0020/API call$0.0020/API call$0.0020/API call or less
Storage2Gb5Gb10Gb or more
SupportForum and emailForum and emailEmail with priority
SLAsBest effortBest effort99.90% or higher

Grandfathering Information

About grandfathering current subscriptions (Basic, Standard, Pro, and Premium): Current paid subscriptions will continue with existing prices until a change is made to the subscription. Any change in the subscription will require the customer to change to one of the existing/current plans at the time of the change. For example, adding or subtracting developer seats, upgrading or downgrading a subscription, or letting a subscription expire without payment will require the selection of one of the new plans, at the new pricing. If you subscription expires or cancels due to no payment, you will need to select from one of the existing/current plans as well.


We’re Going HTTPS: Here Is What You Need to Know

Posted: July 21st, 2016Author:

We want to let you know that after September 15, 2016 we will be moving the platform to HTTPS protocol. This blog post explains everything that you need to know about this update.

Why the switch to HTTPS? Going to an HTTPS page (instead, of HTTP page) protects you against malicious activities, such as site forgery, content alteration, and others.

 Backend Services

All Backend Services already use HTTPS protocol so there is nothing you need to do here. This means that when you invoke an backend service from an app such API Express, database, or Server Code script, the REST API URL uses HTTPS. This has been supported from the very beginning of our platform.

Screen Shot 2016-07-20 at 11.54.33 AM

Secured API Express service.

Read the rest of this entry »