How to display list of all Videos

Question

Hi

I have below code and i want that it should display all Videos. It displays only 50 videos

            StringBuilder htmlTable = new StringBuilder();

            var client = new RestClient("googleapis.com/youtube/v3");
            var request = new RestRequest("search", Method.GET);
            request.AddParameter("part", "snippet");
            
            request.AddParameter("type", "video");
            request.AddParameter("channelId", "UCg3-m_nNoaVw");
            request.AddParameter("key", " AIzaSs8ECFG8");

            var response = client.Execute<YoutubeSearchListResponse>(request);
            var orderByPublishAt = response.Data.items.OrderBy(x => x.snippet.publishedAt);
            htmlTable.Append("<table class='table table-bordered table-hover datatable-highlight' id='tbldata'>");
            htmlTable.Append("<thead><tr><th>Video Id</th><th>Video Title</th><th>Description</th><th>Views</th><th>Like</th><th>Comment</th><th>Published</th></tr></thead>");
            htmlTable.Append("<tbody>");
            foreach (var data in orderByPublishAt)
            {
                var clientTag = new RestClient("googleapis.com/youtube/v3/");
                var tagRequest = new RestRequest("videos", Method.GET);
                tagRequest.AddParameter("key", "AIzaSs8ECFG8");
                tagRequest.AddParameter("part", "snippet,statistics");
                tagRequest.AddParameter("id", data.id.videoId);
                var tagResponse = clientTag.Execute<VideoListResponse>(tagRequest);

                foreach (var item in tagResponse.Data.items)
                {
 
                    htmlTable.Append("<td >" + item.snippet.title + "</td>");
                    htmlTable.Append("<td >" + item.snippet.description + "</td>");
                    
                    htmlTable.Append("</tr>");
                }
            }
            htmlTable.Append("</tbody>");
});
        }

Thanks

Jignesh Kumar · Answer

you need to create one class to hold all result. public class YoutubeSearchItem { public string kind { get; set; } public string etag { get; set; } public Id id { get; set; } public Snippet snippet { get; set; } } public class Id { public string kind { get; set; } public string videoId { get; set; } } public class Snippet { public DateTime publishedAt { get; set; } public string channelId { get; set; } public string title { get; set; } public string description { get; set; } public Thumbnails thumbnails { get; set; } public string channelTitle { get; set; } public string liveBroadcastContent { get; set; } public DateTime publishTime { get; set; } } public class Thumbnails { public Default _default { get; set; } public Medium medium { get; set; } public High high { get; set; } } public class Default { public string url { get; set; } public int width { get; set; } public int height { get; set; } } public class Medium { public string url { get; set; } public int width { get; set; } public int height { get; set; } } public class High { public string url { get; set; } public int width { get; set; } public int height { get; set; } }

Ramco Ramco · Answer

Hi Jignesh I am getting this error - The type or namespace name YoutubeSearchItem could not be found. List allItems = new List (); Thanks

Jignesh Kumar · Answer

Hello Ramco, Please use this one, StringBuilder htmlTable = new StringBuilder(); var client = new RestClient("https://www.googleapis.com/youtube/v3"); var request = new RestRequest("search", Method.GET); request.AddParameter("part", "snippet"); request.AddParameter("type", "video"); request.AddParameter("channelId", "UCg3-m_nNoaVw"); request.AddParameter("key", "YOUR_API_KEY"); // Create list of all videos List allItems = new List (); // Make initial request for youtube endpoint IRestResponse response = client.Execute (request); // Handle pagination to get list of all videos while (response.Data.nextPageToken != null) { allItems.AddRange(response.Data.items); // Make next page request request.Parameters.RemoveAll(p => p.Name.Equals("pageToken")); request.AddParameter("pageToken", response.Data.nextPageToken); response = client.Execute (request); } // Add items from the last page to list of all items allItems.AddRange(response.Data.items); // Build HTML table to bind all videos. htmlTable.Append(" "); htmlTable.Append(" Video Id Video Title Description Views Like Comment Published "); htmlTable.Append(" "); foreach (var data in allItems.OrderBy(x => x.snippet.publishedAt)) { var clientTag = new RestClient("https://www.googleapis.com/youtube/v3/"); var tagRequest = new RestRequest("videos", Method.GET); tagRequest.AddParameter("key", "YOUR_API_KEY"); tagRequest.AddParameter("part", "snippet,statistics"); tagRequest.AddParameter("id", data.id.videoId); var tagResponse = clientTag.Execute (tagRequest); foreach (var item in tagResponse.Data.items) { htmlTable.Append(" "); htmlTable.Append(" " + item.id + " "); htmlTable.Append(" " + item.snippet.title + " "); htmlTable.Append(" " + item.snippet.description + " "); // Add more cells as needed htmlTable.Append(" "); } } htmlTable.Append(" "); htmlTable.Append(" ");

Ramco Ramco · Answer

Hi Jignesh Can u pls help with my code where i should do the changes since i have 2 loops Thanks

Jignesh Kumar · Answer

Hello Ramco, please use this one to get all videos bye removing defaul pagetoken. StringBuilder htmlTable = new StringBuilder(); var client = new RestClient("googleapis.com/youtube/v3"); var request = new RestRequest("search", Method.GET); request.AddParameter("part", "snippet"); request.AddParameter("type", "video"); request.AddParameter("channelId", "UCg3-m_nNoaVw"); request.AddParameter("key", " AIzaSs8ECFG8"); // Keep track of all items List allItems = new List (); // Make initial request IRestResponse response = client.Execute (request); // Handle pagination while (response.Data.nextPageToken != null) { allItems.AddRange(response.Data.items); // Make next page request request.Parameters.RemoveAll(p => p.Name.Equals("pageToken")); request.AddParameter("pageToken", response.Data.nextPageToken); response = client.Execute (request); } // Add items from the last page allItems.AddRange(response.Data.items); var orderByPublishAt = allItems.Data.items.OrderBy(x => x.snippet.publishedAt);

Jithu Thomas · Answer

Add a maxResults parameter to your initial search request. This specifies the number of videos returned per page (default is 50). You can increase this value, but keep it within reasonable limits. Check the response for a nextPageToken property. This token allows you to request the next page of results. In a loop, keep making new requests using the nextPageToken until you reach the desired number of videos or there are no more pages. Here follows a sample sinppet string nextPageToken = null; int maxResults = 100; // Increase this value as needed do { // Existing code for making the search request // Check for next page token if (response.Data.nextPageToken != null) { nextPageToken = response.Data.nextPageToken; request.AddParameter("pageToken", nextPageToken); } else { nextPageToken = null; } // Process retrieved videos (loop through orderByPublishAt) } while (nextPageToken != null);

Ramco Ramco · Answer

Hi Jignesh On below line it is giving error : Cannot convert from system.collection.generic.list to System.Collections.Generic.IEnumerable allItems.AddRange(response.Data.items); public class Item { public string kind { get; set; } public string etag { get; set; } public Id id { get; set; } public Snippet snippet { get; set; } } Thanks