In this article I will explain with an example, how to read (parse) JSON string returned from Web API using C#.
The
WebClient class will be used to call the Web API 2 Controller method which will fetch records from database using
Entity Framework and return the records in JSON format.
The JSON string will be read, parsed and de-serialized into a Generic List collection of Class objects.
Database
Here I am making use of Microsoft’s Northwind Database. You can download it from here.
Entity Framework Model
Once the
Entity Framework is configured and connected to the database table, the Model will look as shown below.
Model
The CustomerModel class consists of the following property.
public class CustomerModel
{
///<summary>
/// Gets or sets Name.
///</summary>
public string Name { get; set; }
}
Web API Controller
In order to add a Web API Controller you will need to Right Click the Controllers folder in the Solution Explorer and click on Add and then Controller.
Now from the Add Scaffold window, choose the Web API 2 Controller – Empty option as shown below.
Then give it a suitable name and click OK.
The next task is to register the Configuration for Web API in the Global.asax file so that the Web API is available for accessing on Web.
In order to do so open Global.asax file and add the following line.
System.Web.Http.GlobalConfiguration.Configure(WebApiConfig.Register);
Make sure you add it in the same order as shown below.
public class MvcApplication : System.Web.HttpApplication
{
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
System.Web.Http.GlobalConfiguration.Configure(WebApiConfig.Register);
RouteConfig.RegisterRoutes(RouteTable.Routes);
}
}
The next step is to code the Web API Controller. The Web API Controller consists of a method named GetCustomers which accepts an object of CustomerModel.
The records of the Customers are fetched using
Entity Framework and are filtered using the
StartsWith function based on the value of the
Name property.
Finally the records are returned as Generic List Collection.
This method is decorated with Route attribute which defines its Route for calling the Web API method and HttpPost attribute which signifies that the method will accept Http Post requests.
static void Main(string[] args)
{
Start:
Console.Write("Enter Name: ");
string name = Console.ReadLine();
string apiUrl = "http://localhost:26404/api/CustomerAPI";
var input = new
{
Name = name
};
string inputJson = (new JavaScriptSerializer()).Serialize(input);
WebClient client = new WebClient();
client.Headers["Content-type"] = "application/json";
client.Encoding = Encoding.UTF8;
string json = client.UploadString(apiUrl + "/GetCustomers", inputJson);
List<Customer> customers = (new JavaScriptSerializer()).Deserialize<List<Customer>>(json);
if (customers.Count > 0)
{
foreach (Customer customer in customers)
{
Console.WriteLine(customer.ContactName);
}
}
else
{
Console.WriteLine("No records found.");
}
Console.WriteLine();
goto Start;
}
public class Customer
{
public string CustomerID { get; set; }
public string ContactName { get; set; }
public string City { get; set; }
}
Namespaces
You will need to import the following namespaces.
using System.Net;
using System.Text;
using System.Web.Script.Serialization;
Note: In order to use the
System.Web.Script.Serialization namespace, you will need to add reference of
System.Web.Extensions assembly to your project, for more details refer
here.
Read (Parse) JSON string returned from Web API using C#
Inside the Main method, the captured value of Name is wrapped into a JSON object which is then serialized into a JSON string.
The URL of the Web API along with its Controller method and the serialized JSON string is passed to the UploadString method of the WebClient class.
The UploadString method of the WebClient class calls the Web API’s Controller method i.e. the GetCustomers method and returns the JSON string which is then de-serialized to Generic List of Customer class objects.
Finally the names of all matching Customers are displayed as Output in the Console Application.
public class CustomerAPIController : ApiController
{
[Route("api/CustomerAPI/GetCustomers")]
[HttpPost]
public List<Customer> GetCustomers(CustomerModel customer)
{
NorthwindEntities entities = new NorthwindEntities();
return (from c in entities.Customers.Take(10)
where c.ContactName.StartsWith(customer.Name) || string.IsNullOrEmpty(customer.Name)
select c).ToList();
}
}
Screenshot
Downloads