Views by Descending Order

Question

Hi

I have below code & i want to display Videos by Views in Descending Order . Maximum Views first

var client = new RestClient("googleapis.com/youtube/v3");

var request = new RestRequest("search", Method.GET);
request.AddParameter("part", "snippet");

request.AddParameter("q", "short videos category");
request.AddParameter("type", "video");
request.AddParameter("maxResults", 25);
request.AddParameter("order", "viewCount");
request.AddParameter("key", "ApiKey");

Thanks

Naimish Makwana · Answer

Hello Ramco, You can get all the property in given code as below. if (listVideo.Any()) { var orderByVideosCount = listVideo.OrderByDescending(x => x.statistics.viewCount); foreach (var item in orderByVideosCount) { Console.WriteLine("Video ID => " + item.id); Console.WriteLine("Channel Id => " + item.snippet.channelId); Console.WriteLine("channelTitle => " + item.snippet.channelTitle); Console.WriteLine("Video Title => " + item.snippet.title); Console.WriteLine("Description => " + item.snippet.description); Console.WriteLine("viewCount => " + item.statistics.viewCount); Console.WriteLine("Tags ==>" + String.Join(",", item.snippet.tags)); } } Thanks Naimish

Naimish Makwana · Answer

Hello Ramco, You need to add null condition before join the tag. If(item.snippet.tags != null && item.snippet.tags.Any()) { //Your html code } Thanks Naimish

Ramco Ramco · Answer

Hi I am getting error on this line - Value cannot be null. Tags can be null in some videos, htmlTable.Append(" " + String.Join(",", item.snippet.tags) + " "); Thanks

Ramco Ramco · Answer

Hi Naimish It is not working properly. I want Channel Id,Name,Video Title , Video Description , Tags, ViewCount Int32 Count = 1; StringBuilder htmlTable = new StringBuilder(); List listVideo = new List (); var client = new RestClient("googleapis.com/youtube/v3"); var request = new RestRequest("search", Method.GET); request.AddParameter("part", "snippet"); //request.AddParameter("q", "short videos category"); request.AddParameter("q", "sports shorts"); request.AddParameter("type", "video"); request.AddParameter("maxResults", 5); request.AddParameter("order", "viewCount"); request.AddParameter("sortOrder", "desc"); request.AddParameter("key", "ApiKey"); var response = client.Execute (request); Int32 ViewCount = 0; foreach (var data in response.Data.items) { var clientTag0 = new RestClient("googleapis.com/youtube/v3/"); var tagRequest0 = new RestRequest("videos", Method.GET); tagRequest0.AddParameter("key", "ApiKey"); tagRequest0.AddParameter("part", "snippet,statistics"); tagRequest0.AddParameter("id", data.id.videoId); var tagResponse0 = clientTag0.Execute (tagRequest0); foreach (var searchResult in tagResponse0.Data.items) { listVideo.Add(searchResult); } if (listVideo.Any()) { var orderByVideosCount = listVideo.OrderByDescending(x => x.statistics.viewCount); foreach (var item in orderByVideosCount) { ViewCount = Convert.ToInt32(item.statistics.viewCount); //This is your categoryId. } } var clientTag = new RestClient("https://www.googleapis.com/youtube/v3/"); var tagRequest = new RestRequest("videos", Method.GET); tagRequest.AddParameter("key", "AIzaSyAu9f5blF7idzt6cGul59UQ9b5Ls8ECFG8"); tagRequest.AddParameter("part", "snippet"); //tagRequest.AddParameter("maxResults", 10); tagRequest.AddParameter("fields", "items(id,snippet(tags,categoryId))"); tagRequest.AddParameter("id", data.id.videoId); var tagResponse = clientTag.Execute (tagRequest); string Tags = ""; foreach (var searchResult in tagResponse.Data.Items) { if (searchResult.Snippet != null && searchResult.Snippet.Tags != null) { foreach (var tags in searchResult.Snippet.Tags) { //Console.WriteLine(tags); //here you can get and store tag Tags = Tags + tags + ","; } } Count++; } } }

Naimish Makwana · Answer

Hello Ramco, TO achive this do following things: Make a List fo object of all individual videos from below response. It will give you all the Videos with Videos count. List listVideo = new List (); foreach (var data in response.Data.items) { var clientTag0 = new RestClient("googleapis.com/youtube/v3/"); var tagRequest0 = new RestRequest("videos", Method.GET); tagRequest0.AddParameter("key", "ApiKey"); tagRequest0.AddParameter("part", "snippet,statistics"); tagRequest0.AddParameter("id", data.id.videoId); var tagResponse0 = clientTag0.Execute (tagRequest0); foreach (var searchResult in tagResponse0.Data.items) { listVideo.Add(searchResult); //ViewCount = Convert.ToInt32(searchResult.statistics.viewCount); } } After gather all the videos in list. Sort the list by ViewCount. if (listVideo.Any()) { var orderByVideosCount = listVideo.OrderByDescending(x => x.statistics.viewCount); foreach (var item in orderByVideosCount) { Console.WriteLine("Video ID => " + item.id + " Count ==> " + item.statistics.viewCount); //This is your categoryId. } } Thanks Naimish Makwana

Ramco Ramco · Answer

Hi Naimish I have below data . It is not showing correctly var client = new RestClient("googleapis.com/youtube/v3"); var request = new RestRequest("search", Method.GET); request.AddParameter("part", "snippet"); request.AddParameter("q", "sports shorts"); request.AddParameter("type", "video"); request.AddParameter("maxResults", 15); request.AddParameter("order", "viewCount"); request.AddParameter("sortOrder", "desc"); request.AddParameter("key", "ApiKey"); var response = client.Execute (request); htmlTable.Append(" "); htmlTable.Append(" SN Channel Id Channel Title Video Title Description Tags Views Published "); htmlTable.Append(" "); Int32 ViewCount = 0; //if (response.IsSuccessStatusCode) //{ foreach (var data in response.Data.items) { var clientTag0 = new RestClient("googleapis.com/youtube/v3/"); var tagRequest0 = new RestRequest("videos", Method.GET); tagRequest0.AddParameter("key", "ApiKey"); tagRequest0.AddParameter("part", "snippet,statistics"); tagRequest0.AddParameter("id", data.id.videoId); var tagResponse0 = clientTag0.Execute (tagRequest0); foreach (var searchResult in tagResponse0.Data.items) { ViewCount = Convert.ToInt32(searchResult.statistics.viewCount); } Thanks

Naimish Makwana · Answer

Hello Ramco, Add the below parameter to the API request: request.AddParameter("sortOrder", "desc"); Thanks Naimish Makwana