How to get Json format data in WebApi

Omprakash Amarwal

11y1.2k.NET

I want to get Json Data from WebApi when i call apiController it can return Xml data.

here is ShowDataController = ApiController

Sp_GetAllData() = Storeprocedure which contains simple select query

public class ShowDataController : ApiController

{

public IEnumerable Get()

{

AngulerEntities db = new AngulerEntities();

List res = db.Sp_GetAllData().ToList();

return res;

}

when i run this http://localhost:10127/api/ShowData it will return xml data

if i use string type of method in ApiController and which is using JavaScriptSerializer().Serialize()

string output = new JavaScriptSerializer().Serialize(res);

return output;

it will return xml in json data.

now i want to get Only json data while calling apiController.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nilesh Jadav11y ago
Accepted answer
By default, Web API produces XML but if there is need for JSON, given syntax will do it.

Open WebApiConfig.cs file in solution and add mentioned line in it as shown in example.

public static void Register(HttpConfiguration config)
{
config.Routes.MapHttpRoute(
name: "DefaultApi",
routeTemplate: "api/{controller}/{id}",
defaults: new { id = RouteParameter.Optional }
);
//To produce JSON format add this line of code
config.Formatters.JsonFormatter.SupportedMediaTypes.Add(newMediaTypeHeaderValue("text/html"));
}

Source taken from :

http://www.c-sharpcorner.com/Blogs/15973/get-Asp-Net-web-api-to-return-json-instead-of-xml.aspx

Check these link too :

1) http://stackoverflow.com/questions/9847564/how-do-i-get-asp-net-web-api-to-return-json-instead-of-xml-using-chrome

2) http://stackoverflow.com/questions/18266952/asp-net-web-api-returning-xml-instead-of-json
Nilesh Jadav11y ago
If you find my answer helpful, Please kindly approve my answer.

Thank you !
Omprakash Amarwal11y ago
Thanks :-)