How to Get SharePoint 2013 ODATA/REST in JSON Format Using Fiddler

In this article you will see how to get SharePoint 2013 ODATA/REST in JSON format using Fiddler.

Introduction

SharePoint 2013 introduces a Representational State Transfer (REST) service that is comparable to the existing SharePoint client object models. This allows the developers to interact remotely with SharePoint data using any technology that supports REST web requests. This means that developers can perform Create, Read, Update and Delete (CRUD) operations from their apps for SharePoint, solutions, and client applications, using REST web technologies and standard Open Data Protocol (OData) syntax. HTTP Request will return the result in ATOM/XML format. In this article you will see how to get SharePoint 2013 ODATA/REST in JSON format using Fiddler.

Example

Using the following REST HTTP Request you could get all the content types.

https://siteName/_api/web/lists/getbytitle('Custom%20List')/contenttypes

This returns all the content types in ATOM/XML format.

Get the REST/ODATA in JSON Format

1. Open Fiddler.
2. Click on the Filters tab.
3. Select Use Filters.
4. In the Request Headers section, select Set request header and enter the header as application/json;odata=verbose
   
   
   
   
5. Refresh the page and open the JSON format in the JSONViewer (Download the JSONViewer (JSON Viewer).
6. You will see the JSON format in JSONViewer as shown below:
   
   
   

Summary

Thus in this article you saw how to get SharePoint REST/ODATA in JSON format using Fiddler.