In this article, we will go step by step to create Azure Mobile app using Azure portal and test with Fiddler (Web Debugging Tool). Mobile apps come under Azure App Service. Azure App Service is a fully managed Platform as a Service (PaaS) offering for professional developers that brings a rich set of capabilities to web, mobile, and integration scenarios. Mobile Apps offers a highly scalable, globally available mobile application development platform for Enterprise Developers and System Integrators that brings a rich set of capabilities to mobile developers.

Mobile App features,

Prerequisites

You will learn,

Getting Started.

Step 1: Navigate to Azure Portal & Sign in with Azure Credentials.

Step 2: Click on New button -> Web + Mobile -> Mobile App

Mobile App

Step 3: Enter Mobile App Name, choose Azure Subscription, create New or use existing Resource Group.

Create

Click on App Service Plan/Location -> Create New.

Create New

Enter App Service Plan name, Location, Pricing tier.

Enter App Service
Enter App Service
Step 4: Mobile app created successfully. Click on “Easy tables” inside Mobile section. Click on Easy Table Configuration option.

Easy tables

Easy tables

Step 5: First, select “Connect to database“ option. Add new data connection by clicking on “Add” button.

Connect to database

Connect to database

Step 6: Choose Type of Database: SQL Database or Storage. Click on SQL Database & create a new database.

Type of Database

Step 7: Enter Database name, Pricing Tier, Target Server, Collation. No server is created as of now. So, please select Target server & create a new Server. Enter Server name, admin login, password, location.

create

Step 8: Select last option of database “Connection string” option. Just check if all the data filled is correct or not.

Connection string

Wait for a few seconds, database & server is being created.

server

Step 9: Database & Server have been created in Easy Tables. Now, check on “I acknowledge that this will overwrite all site contents” & click on “Initialize App” button.

Initialize App

Step 10: Click on Add button to create table in database.

Add button

Step 11: Enter the table name & all permissions: Insert, Update, Delete, Read, Undelete.

table
For this example, we are considering “Allow anonymous access” but for mobile app, we need to select different permission.

Step 12: Click on Table Name.
Table Name

Next step is to create columns or fields in table. So, click on “Manage Schema”.

Manage Schema
Step 13: Add columns,

Step 14: Start Fiddler Tool for testing.

First, select “Composer”, then change request to “POST”, then enter mobile app URL with table name & with API version.

Syntax : http://mobileappname.azurewebsites.net/tables/tablename?zumo-api-version=2.0.0
Ex. http://azuremobileappdemo1.azurewebsites.net/tables/usertable?zumo-api-version=2.0.0
Note : Azure Mobile App support api version 2.0.0 so after url add ?zumo-api-version=2.0.0

In request body, enter JSON value & click on Execute button.

{“firstname”:”firstnamevalue”,”lastname”:”lastnamevalye”,”city”:”cityvalue”}

body

body

Step 15: Refresh the record in table.

Refresh the record