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

Connect to your SQL Server,
Create Custom / User Defined Web API GET Method And Test In Talend API
Table Creation SQL Script,
  1. USE [MbkTest]
  2. go
  3. /****** Object: Table [dbo].[tblFriends] Script Date: 07-Jan-20 12:53:31 PM ******/
  4. SET ansi_nulls ON
  5. go
  6. SET quoted_identifier ON
  7. go
  8. SET ansi_padding ON
  9. go
  10. CREATE TABLE [dbo].[tblfriends]
  11. (
  12. [friendid] [INT] IDENTITY(1, 1) NOT NULL,
  13. [friendname] [VARCHAR](100) NULL,
  14. [phonenumber] [VARCHAR](50) NULL,
  15. [emailid] [VARCHAR](100) NULL,
  16. [country] [VARCHAR](100) NULL,
  17. [dob] [DATETIME] NULL,
  18. [ismarried] [BIT] NULL,
  19. [salaryperannum] [NUMERIC](10) NULL,
  20. PRIMARY KEY CLUSTERED ( [friendid] ASC )WITH (pad_index = OFF,
  21. statistics_norecompute = OFF, ignore_dup_key = OFF, allow_row_locks = on,
  22. allow_page_locks = on) ON [PRIMARY]
  23. )
  24. ON [PRIMARY]
  25. go
  26. SET ansi_padding OFF
  27. go
Insert Table Data Using SQL Script,
  1. insert into tblFriends values ('Suresh Vyas','98612134512','[email protected]','India',1990/01/01,1,450000)
  2. insert into tblFriends values ('Manoj Kalla','9869166077','[email protected]','India',1980/02/05,1,950000)
  3. insert into tblFriends values ('Kamlesh Goenka','981916607','[email protected]','India',1970/02/06,1,750000)
  4. insert into tblFriends values ('Prashant Bansal','781214607','[email protected]','US',1989/01/04,01,250000)
  5. insert into tblFriends values ('Nitin Tiwari','811012607','[email protected]','US',1992/01/04,0,350000)
  6. insert into tblFriends values ('Mahesh Jadhav','921052607','[email protected]','US',1998/01/06,0,42000)
Select Query to Check the Records,
  1. 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
  1. [HttpGet]
  2. [Route("api/FriendListMsg")]
  3. public HttpResponseMessage GetFriendList()
  4. {
  5. MbkTestDataClassesDataContext db = new MbkTestDataClassesDataContext();
  6. var FriendList = (from a in db.tblFriends select a).ToList();
  7. return Request.CreateResponse(HttpStatusCode.OK, FriendList);
  8. }
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. . . !