Create Custom / User Defined Web API GET Method And Test In Talend API

Loading

Create Custom / User Defined Web API GET Method And Test In Talend API

You will learn two major things in this article:

Create GET Custom Method Web API using .Net Framework.
Testing Web API GET Method using Talend Chrome Browser Extension.

We are going acheive the above two major things with the help of the followings steps,

Create SQL Table and Insert Data using Query
Asp.Net Web API Application Creation
Linq to Sql Class
Write GET Custom Method of Web API
Test Asp.Net Web API GET Method in Browser
Install Talend Extension in Chrome Browser
Test Asp.Net Web API GET Method for XML and JSON output.

Create SQL Table and Insert Data using Query

Connect to your SQL Server,

Create Custom / User Defined Web API GET Method And Test In Talend API

Table Creation SQL Script,

USE [MbkTest]
go
/****** Object: Table [dbo].[tblFriends] Script Date: 07-Jan-20 12:53:31 PM ******/
SET ansi_nulls ON
go
SET quoted_identifier ON
go
SET ansi_padding ON
go
CREATE TABLE [dbo].[tblfriends]
(
[friendid] [INT] IDENTITY(1, 1) NOT NULL,
[friendname] [VARCHAR](100) NULL,
[phonenumber] [VARCHAR](50) NULL,
[emailid] [VARCHAR](100) NULL,
[country] [VARCHAR](100) NULL,
[dob] [DATETIME] NULL,
[ismarried] [BIT] NULL,
[salaryperannum] [NUMERIC](10) NULL,
PRIMARY KEY CLUSTERED ( [friendid] ASC )WITH (pad_index = OFF,
statistics_norecompute = OFF, ignore_dup_key = OFF, allow_row_locks = on,
allow_page_locks = on) ON [PRIMARY]
)
ON [PRIMARY]
go
SET ansi_padding OFF
go

Insert Table Data Using SQL Script,

insert into tblFriends values ('Suresh Vyas','98612134512','[email protected]','India',1990/01/01,1,450000)
insert into tblFriends values ('Manoj Kalla','9869166077','[email protected]','India',1980/02/05,1,950000)
insert into tblFriends values ('Kamlesh Goenka','981916607','[email protected]','India',1970/02/06,1,750000)
insert into tblFriends values ('Prashant Bansal','781214607','[email protected]','US',1989/01/04,01,250000)
insert into tblFriends values ('Nitin Tiwari','811012607','[email protected]','US',1992/01/04,0,350000)
insert into tblFriends values ('Mahesh Jadhav','921052607','[email protected]','US',1998/01/06,0,42000)

Select Query to Check the Records,

select * from [dbo].[tblFriends]

Create Custom / User Defined Web API GET Method And Test In Talend API

Create ASP.NET Web Application project called “LearnWebApi”

Create Custom / User Defined Web API GET Method And Test In Talend API

Create Custom / User Defined Web API GET Method And Test In Talend API

Create Custom / User Defined Web API GET Method And Test In Talend API

Create Custom / User Defined Web API GET Method And Test In Talend API

You can check in the above screen shot that the MVC and Web API checkboxes are selected by default.

Create Custom / User Defined Web API GET Method And Test In Talend API

Create Custom / User Defined Web API GET Method And Test In Talend API

Project is created successfully.

Connecting to MBKTEST database

For Server Explorer click on VIEW --->Server Explorer

Create Custom / User Defined Web API GET Method And Test In Talend API

Create Custom / User Defined Web API GET Method And Test In Talend API

Create Custom / User Defined Web API GET Method And Test In Talend API

Create Custom / User Defined Web API GET Method And Test In Talend API

Create Custom / User Defined Web API GET Method And Test In Talend API

Now insert LINQ TO SQL,

Right click on Project Select ADD--> NEW ITEM

Create Custom / User Defined Web API GET Method And Test In Talend API

Select Data then select “LINQ TO SQL CLASSES”.

Create Custom / User Defined Web API GET Method And Test In Talend API

Drag tblFriends table on (MbkTestDataClasses.dbml) Linq To SQL class.

Create Custom / User Defined Web API GET Method And Test In Talend API

Switch to default controller that is ValuesController (ValueController.cs file) which is located inside root’s Controller folder.

Code

[HttpGet]
[Route("api/FriendListMsg")]
public HttpResponseMessage GetFriendList()
{
MbkTestDataClassesDataContext db = new MbkTestDataClassesDataContext();
var FriendList = (from a in db.tblFriends select a).ToList();
return Request.CreateResponse(HttpStatusCode.OK, FriendList);
}

Create Custom / User Defined Web API GET Method And Test In Talend API

Press F5 and Check on browser.

Just type ADDRESS

http://localhost:50297/api/FriendListMsg

Create Custom / User Defined Web API GET Method And Test In Talend API

How to install Talend API Tester?

Open Chorme browser, click on the top left side and there is a button called APPS

Create Custom / User Defined Web API GET Method And Test In Talend API

Or

Type on Address Bar:chrome://apps/

Select WEB STORE

Create Custom / User Defined Web API GET Method And Test In Talend API

Search Text Box type ---> “Talend API Tester”

Create Custom / User Defined Web API GET Method And Test In Talend API

After extension installation

Create Custom / User Defined Web API GET Method And Test In Talend API

Now run the Talend API Tester by clicking on the right top side.

Create Custom / User Defined Web API GET Method And Test In Talend API

Sending application/xml request to server to get output in XML format.

Create Custom / User Defined Web API GET Method And Test In Talend API

XML OUTPUT RECEIVED FROM SERVER,

Create Custom / User Defined Web API GET Method And Test In Talend API

Sending application/json request to server to get output in JSON format.

Create Custom / User Defined Web API GET Method And Test In Talend API

JSON OUTPUT RECEIVED FROM SERVER,

Create Custom / User Defined Web API GET Method And Test In Talend API

Happy Coding. . . !