Views by Descending Order

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

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

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++;
                    }
                }

        }

Hello Ramco,

TO achive this do following things:

1. 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);
	}
}

1. 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

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("");
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 Makwana3y agoPosted Feb 5, 2023, 6:57 AM
Hello Ramco,

Add the below parameter to the API request:

request.AddParameter("sortOrder", "desc");


Thanks

Naimish Makwana
SN
Channel Id
Channel Title
Video Title
Description
Tags
Views
Published