Appery.io Newsletter (January 2017)

Posted: February 24th, 2017Author:

Our January 2017 newsletter.

Big Platform Upgrade: iOS 10, Cordova Update, Automatic APIs Sync and More

At the end of January we had a big platform update with new upgrades and benefits:

  • iOS 10 Support
  • Apache Cordova Upgrade
  • Automatically Sync Backend Services Changes with the App Builder
  • Organize with Folders Inside the App Builder
  • Backend Services APIs Are Now Placed in Folders for Easier Organization
  • Improved Media Manager
  • Improved Synchronization Between App and Server for Apps with Offline Support
  • New Page to Test API Express Services and Offline Support
  • New Auto-login with Offline Support

Learn more about this platform update from our blog.

Exposing a SQL Database via REST APIs: A Video Guide for Developers

Many organizations that are building mobile apps need to connect to and reuse existing internal systems. One of the most common such system is a relational (SQL) database. The following two videos show how to connect and expose a SQL database via REST API using API Express:

Appery.io + Pollfish: How to Integrate a Pollfish Survey into Your App

Our friends at Pollfish, a survey platform company, created a guide to help you monetize Appery.io apps with Pollfish surveys. Integration takes only a few minutes and can boost your revenue up to 20x more compared to any other traditional advertising format out there. Check our the easy-to-use integration guide.

Learn How Appery.io Ensures API Express and Server Code On-demand Deployment

Read this awesome (and technical) blog post by our Dev Ops Engineer Ruslan on how he ensures API Express and Server Code support on-demand deployment and can be scaled instantly for any platform traffic.

Can You Build a Conference Room Booking App Using Appery.io in 16 Hours?

Yes. Exadel, the parent company behind Appery.io, with over 800 employees and 7 worldwide offices built a Conference Room Booking App using Appery.io in 16 hours. This app helps with the well-known problem of double-booking conference rooms and then looking confused when someone is there when you need to have an important meeting. Learn more about this app.

Exposing a SQL Database via REST APIs: a How-To Video Guide for Developers

Posted: February 21st, 2017Author:

apiexpress_sql_component

 

Many organizations that are building mobile apps need to connect to and reuse existing (internal) systems. One of the most common system is a relational (SQL) database.

We have prepared two short videos that will show you how to do that using Appery.io API Express.

API Express connects to a relational database and exposes the database tables via REST APIs. Once the APIs are created, the mobile app can easily consume the APIs.

There are two approaches exposing a database:

The first approach automatically generates CRUD-like APIs to work with a database table. In many apps, this is close to 80% of what an app might need. This automatic approach also comes with very sophisticated offline support. In other words, you app can work offline and sync data with a remote database when a connection is reestablished.

With the second approach, you get full control as you write the actual SQL query (or Stored Procedure) that will be executed. With this approach, you can use a visual service editor to orchestrate the REST API. In addition to the SQL component (connector), you can use connectors such as Web Service (WSDL), REST  and others.

Check out the API Express video playlist to learn more.

Exadel Built a Conference Room Booking App Using Appery.io in 16 Hours

Posted: February 13th, 2017Author:

conference_room_book_general

It is safe to assume that you have experience this before. You go into a conference room to have an important phone call or meeting and someone is already sitting there. Someone is sitting there because your organization doesn’t have a conference room reservation software or even it it does have one, it’s so cumbersome to use, no one uses it.

At Exadel, the parent company behind Appery.io, with over 800 employees and 7 worldwide offices – this was happening on daily basis. When you come to a conference room to have an important meeting and can’t use it, it causes confusion (if someone is already inside the room) you waste time and other resources.

To solve this mandate problem, Exadel decided to build a mobile conference management app using the Appery.io platform and deploy it throughout its office worldwide.

ipad_air_mockup

The app is called Conference Room Booking App.

The app communicates with your Google Calendar via SOAP services and retrieves details about ongoing and upcoming events. In order to connect to an external SOAP service and expose it via RESTful APIs, the app uses Appery.io API Express.

The app uses the Appery.io cloud database to store meeting information and conference room information and bookings.

The app UI was built using Appery.io App Builder for Ionic.

The complete app was designed, developed and tested in about 16 hours.

Appery.io + Pollfish: How to Integrate a Pollfish Survey into Your App

Posted: February 10th, 2017Author:

Our friends at Pollfish, a survey platform company, created this guide to help you monetize Appery.io apps with Pollfish surveys. Integration takes only a few minutes and can boost your revenue up to 20x more compared to any other traditional advertising format out there.

pollfish-survey

Check out the steps below to create a Pollfish app and integrate it with Appery.io Ionic app.

Read the rest of this entry »

Ringing in 2017 With a Big Platform Update: iOS 10, Cordova Update, Automatic APIs Sync and More

Posted: January 29th, 2017Author:

We are happy to share that we starting 2017 with a big platform update. Read this blog post to learn what’s new.

iOS 10 Support

This update brings full iOS 10 support. This means when you build a binary app for iOS, it should run on an iOS device running version 10 without any problems.

ios10

This support is possible with Apache Cordova library update.

Apache Cordova Upgrade

In order to provide full iOS 10 support, we have upgraded the Apache Cordova library. The latest Cordova library for iOS is version 4.3.0 and for Android is 5.2.2. This update brings many bug fixes, improvements to Cordova. Your hybrid app will be just a little bit better and that’s good. Please read the technical release notes about this update.

The Appery.io Tester app will also be updated with the new Cordova library. Read more about it here.

Automatically Sync Backend Services Changes with the App Builder

Integration between the App Builder and Backend Services is one of the core values in the Appery.io platform. Importing API services into an app is very simple:

backendservices_import

Now, if you made any changes to the backend APIs, you had to either manually update the service in the App Builder or delete the service and then import it again. These approaches are not very good so with this update we are introducing an automatic sync feature between the App Builder and Backend Services. When you update a backend API service, simply click the Check for update button to update the service in the App Builder.

servercode_sync_update_button

This is very nice as you no longer need to make manual changes or even delete the services. Right now this feature is available only in an Ionic app but we are planning to add this support to a jQuery Mobile app as well.

Read the rest of this entry »

How to Search the Database by Date From Server-side JavaScript

Posted: January 19th, 2017Author:

clock

Searching or querying a database is one of the most common actions in a mobile app. Appery.io platform provides a cloud database to store any app data and Server Code that allows to write any server-side app logic using JavaScript. Server Code has an API to query the database that makes it easy to perform search queries based on a date. In this blog post you will learn how to write a script to query a database collection using dates.

To start, we need to create a sample database collection. Our collection looks like this:

Database collection

Database collection

The collection has two built-in date columns:

  • _createdAt – the time when a record was created
  • _updatedAt – the time when a record was updated (default value is set to _createdAt)

and two custom columns, both are of Date type:

  • startTime
  • endTime

You can of course include any other data.

Now let’s get to the code.

The first code examples shows how to query by using the built-in fields (_createdAt or _updatedAt).

This search query will return all objects where the _updatedAt date is less then ($lt) the current time (when the script runs).

When using one of the built-in data types in a query (_createdAt, _updatedAt), the date value must be formatted in ISO format. When using a custom column with Date type, using ISO format is not required.

The next code examples uses a custom endDate column (type Date). Note that the syntax to use the built-in date column (above) and a custom column is slightly different:

This query returns all records where the endTime is less than December 31, 2016. Based on data in the collection, only the record that contains tablets will be returned. This is how the response looks:

Let’s now look at another code example where we will use the startTime and endTime together.

In the following code snippet we query for all objects where the startTime is greater than December 31, 2016 and the endTime is less then February 1, 2017.

Querying the database by dates or any other columns is best suited for server-side logic as you can test the script and ensure it works before using in an app. Moving this logic to the client would only complicate the app and make it more error prone.

Once the Server Code script is tested and read you can import the service API for it inside the App Builder. This short video shows how to import a backend service. To learn more about Server Code, watch the Server Code YouTube playlist videos.

Convert Phone Numbers Into Real Business Intelligence with EveryoneAPI

Posted: January 18th, 2017Author:

old_telephone

EveryoneAPI by Telo allows to convert a phone number into real business intelligence with a simple API request. The complete reverse phone append product is simple to use, yet powerful and built for developers by developers. As you probably already know, integrating with any 3rd party REST API using the Appery.io Server Code is also simple. In this blog post, I will show you how to invoke a test a script that calls the Everyone API.

To start, create a new Server Code script with the following code:

The only thing you need to do, is to replace the auth_token and account_sid with values from your account. Sign up for an account here. It’s fast and simple.

The phone number for which you want to get information is passed as a parameter to the script (line 1). To test the script, switch to Script parameter tab (on the right side), enter a parameter called telephone and then set it to a test value. Here is an example testing the API using the Appery.io telephone number:

Testing EveryoneAPI

Testing EveryoneAPI

Once you finished and tested the script, you easily import into your app. This video shows how to do that.

Looking for more APIs by Telo? Check out the CallerID Server Code plug-in:

callerid_servercode_plugin

OpenCNAM plug-in

This plug-in creates a Server Code script that integrates with OpenCNAM API. The OpenCNAM API allows you to get caller ID information for phone number provided.

Appery.io Newsletter (December 2016)

Posted: January 17th, 2017Author:

Happy New Year!

Platform News

Our Apache Cordova library update with iOS 10 support is coming by the end of January. Please check if you need to update the jQuery Mobile App Library version in your app before this update.

Appery.io Mobile Resources You Should Know in 2017

To help you build mobile apps faster in 2017, we have published all the Appery.io resources you should know about and use. Check out the list here.

A Quick Guide to Using Geolocation in Your Mobile App

We published two short videos that show you how to set up and the use Geolocation API in jQuery Mobile and Ionic apps.

GoCodes Extends Asset Tracking Solution to Android Devices with the Help of the Appery.io Platform

GoCodes provides a complete patented asset and inventory tracking solution that harnesses the power of cloud-based software, smartphones, and QR codes. When GoCodes launched in 2012, their mobile apps were limited to HTML5 browser technology and lacked the power and ease-of-use of true mobile apps. Learn how GeoCodes built a native app with Appery.io.

Appery.io Platform Overview: A Guide for Mobile Developers

Learn about Appery.io platform features and benefits from this short video. This is a great guide for mobile developers, whether they are existing Appery.io developers or just starting out. Watch the video now.

Appery.io Videos

We have close to 200 short videos conveniently organized into playlists. Check them out.

Learn How to Use Server Code Snippets

Learn how to use Server Code Snippets for faster server-side JavaScript development and learn about the new FullContact API integration.

Appery.io Mobile Resources You Should Know in 2017

Posted: January 16th, 2017Author:

happy2017

Happy New Year!

As we are starting 2017, we want to let you know about all the Appery.io resources available to you, to help you build you app faster and easier. These resources are being updated with new content all the time, so we definitely recommend subscribing to updates or following them. This way you will be always up to date with what is happening. Let’s get to the resources.

Developer Documentation and Portal (http://docs.appery.io)

The docs site is the most important resources (obviously). The docs site contains the platform documentation, tutorials, and API reference section. We regularly update the content on this site. If you find a typo or an error, please use the Suggest Edits feature to tell us about it.

The docs site has a blog section (http://docs.appery.io/blog) where we usually post technical information such as API updates or library updates. The information is usually very technical and specific so it doesn’t go on the main blog. We will also post links to tutorials and videos.

The Appery.io blog (http://blog.appery.io)

The blog is one of the most important resources you should read. This is where we post platform updates, announcements, new videos, new tutorials, case studies and anything else. We definitely recommend you follow the blog to stay up to date. Following the blog is very simple. You can subscribe via the RSS feed or subscribe via email (you will get an email every time a new post is published).

YouTube Channel (http://youtube.com/apperyio)

This is our most popular resource. Our YouTube channel has over 200 short videos on various topics to help you build apps faster. Definitely subscribe to get updates when we publish new videos. The videos are organized into playlists:

Most of our videos are no longer than 15 minutes. This allows you to learn about a topic, feature or benefit very fast and you won’t be bored through an hour long example.

Community Forum (http://appery.io/forum)

Our community forum is the place to get help, ask questions and help your fellow Appery.io developers.

Platform Status Page (http://status.appery.io)

Appery.io platform status page shows each platform component and its current status. It’s important to bookmark or follow this page via RSS to always know the status of each component.

Twitter (http://twitter.com/apperyio)

Twitter is where we post important announcements, platform updates, new tutorials, case studies, new videos and anything else. We recommend to follow up on Twitter to always stay up to date.

Facebook Page (http://facebook.com/apperyio)

Facebook is very similar to Twitter. On Facebook we post important announcements, platform updates, new tutorials, case studies, and new videos. We recommend to Like us Facebook to always stay up to date.

LinkedIn Company Page (https://www.linkedin.com/company/appery-io)

On our LinkedIn Company Page we post announcements, new tutorials, case studies, and new videos.

Google+ Page (https://plus.google.com/u/0/104276681162289155352)

Yes, we are still on Google+ :).

Instagram (https://www.instagram.com/apperyio/)

This is a new resource and we will be posting a lot more in 2017.

What’s New Panel

And a bonus resource is our What’s New panel. The What’s New panel can be opened from any platform page from the header. The panel shows you the most recent updates, tutorials, and videos. Check this resource often to learn what’s new.

whatsnew-panel

 

GoCodes Extends Asset Tracking Solution to Android Devices With the Help of Appery.io Platform

Posted: January 12th, 2017Author:

GoCodes provides a complete patented asset and inventory tracking solution that harnesses the power of cloud-based software, smartphones and QR codes. When GoCodes launched in 2012, their mobile apps were limited to HTML5 browser technology and lacked the power and ease-of-use of true mobile apps.

geocodes1

Moving From HTML5 to True Mobile App

Fast forward to 2015 when GoCodes was looking to develop the next generation of mobile asset tracking apps. They turned to Appery.io to provide a powerful and easy-to-use development tool that could cut development time in half and enable existing team members to quickly get up-to-speed without any special training.

Read the rest of this entry »