Search
  • Ravi Sharma

Browse OData 4.0 Service Using Postman Client

Updated: Sep 1

Hey there folks!

You must be here for a reason, We know you have created an OData Service with Ignite and now you can't wait to see it in action. If you haven't created one yet, learn how to create an OData Service here.


Well, fasten you seat-belts because now we are going to get a live tour of our service.

Open Postman on your system and lets get started.


We will take an Table Users with columns (ID, FullName, Username) for example and perform CRUD on that Table using our service.


Note: Replace ServiceRoot with your Service URL.

Requesting Data

To perform CRUD operations, Let's start with a GET call.

Requesting Entity Collections

The call below will fetch us data from users Table.

GET serviceRoot/Users


Requesting an Individual Entity by ID

The call below call will fetch us data from users Table with specified key(primary key).

GET serviceRoot/Users(1)


Requesting an Individual Entity by ID

The call below will fetch FullName property from users Table with specified key(primary key).

GET serviceRoot/Users(1)/FullName


Querying Data

System Query Option $filter

The call below will fetch records where the filter matches the specified criteria.

GET serviceRoot/Users?$filter=FullName eq 'Ravi'

--options

you can add multiple filters by separating them with 'AND' & 'OR' keywords


System Query Option $top

The call below will fetch top 5 records.

GET serviceRoot/Users?$top=5


System Query Option $skip

The call below will skip top 5 records.

GET serviceRoot/Users?$skip=5


System Query Option $select.

The call below will get us FullName and username for all records.

GET serviceRoot/Users?$select=FullName, Username


System Query Option $count.

The call below will get us all the matching records with @Odata.count property with record count.

GET serviceRoot/Users?$count=true


System Query Option $orderby

The call below will fetch us all records in ascending order

GET serviceRoot/Users?$orderby= Id

--options

  • $orderby= Id asc (default)

  • $orderby= Id desc


Data Modification

Create an Entity

The request below will create a new resource in users table.

POST serviceRoot/Users

NOTE: Request body must contain the data to POST.

{
 "Id": 8,
 "FullName": "Vishal",
 "Username": "Vishal-Ranjan"
}

Remove an Entity

The call below will delete the record with Id 6.

DELETE serviceRoot/Users(6)

Note: The primary key for the matching record must be provided.


Update an Entity

PATCH serviceRoot/Users(8)

Note: The request body must contain the data to UPDATE.

{
 "FullName": "Kumar",
 "Username": "Kumar-Navneet"
}

These are the features our OData Nodes supports in its early version.


While you keep doing magic with our tools, we are here working to make things even better for you. *Fist Bump*





13 views

Recent Posts

See All

Privacy Policy

Protecting your private information is our priority. This Statement of Privacy applies to http://cygrp.com and Cyber Group Inc and governs data collection and usage. For the purposes of this Privacy P

Acceptable Use Policy

Your use of the Service is subject to this Acceptable Use Policy. If you are found to be in violation of our policies at any time, as determined by Cyber Group Inc in its sole discretion, we may warn

© Cyber Group Inc, 2020