Order by PublishedAt

Question

Hi

In below code i want data to be ordered by PublishedAT

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", 50);
request.AddParameter("order", "viewCount");
request.AddParameter("videoDuration", "short");
var today = DateTime.Now.Date;
var sevenDaysAgo = today.AddDays(-1).ToString("yyyy-MM-ddTHH:mm:ssZ");
request.AddParameter("publishedAfter", sevenDaysAgo);
request.AddParameter("key", "API_KEY");

var response = client.Execute<YoutubeSearchListResponse>(request);

List<VideoListResponse.Item> listVideo = new List<VideoListResponse.Item>();

foreach (var data in response.Data?.items)
{
    var clientTag = new RestClient("googleapis.com/youtube/v3/");
    var tagRequest = new RestRequest("videos", Method.Get);
    tagRequest.AddParameter("key", "API_KEY");
    tagRequest.AddParameter("part", "snippet,statistics");
    tagRequest.AddParameter("maxResults", 100);
    request.AddParameter("order", "viewCount");
    tagRequest.AddParameter("id", data.id.videoId);
    var tagResponse = clientTag.Execute<VideoListResponse>(tagRequest);

    foreach (var item in tagResponse.Data.items)
    {
        Console.WriteLine("viewCount" + item.statistics.viewCount);
        Console.WriteLine("likeCount" + item.statistics.likeCount);
        Console.WriteLine("commentCount" + item.statistics.commentCount);

        var categoryId = item.snippet.categoryId;
        var clientCategory = new RestClient("googleapis.com/youtube/v3/");
        var categoryRequest = new RestRequest("videoCategories", Method.Get);
        categoryRequest.AddParameter("key", "ApiKey8");
        categoryRequest.AddParameter("part", "snippet");
        categoryRequest.AddParameter("id", categoryId);
        var categoryResponse = clientCategory.Execute<VideoCategoryListResponse>(categoryRequest);
        if (categoryResponse.Data?.Items != null)
        {
            Console.WriteLine("CtegoryName " + categoryResponse.Data.Items[0].Snippet.Title);
        }
    }
}

Thanks

Naimish Makwana · Answer

Hello Ramco, Refer this link. https://www.c-sharpcorner.com/forums/views-by-descending-order Here we have done order by Views. Try to implement similar and change the Order by listVideo.OrderByDescending(x => x.statistics.viewCount); to listVideo . OrderBy(x => x.snippet.publishedAt); Thanks Naimish Makwana

Naimish Makwana · Answer

Hello Ramco, Add order by in parameter. 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("order", "viewCount"); //Need to remove this. as only one order by is accepted request.AddParameter("order", "date"); // order by published date : Add this request.AddParameter("videoDuration", "short"); request.AddParameter("channelId", "ChannelId"); Thanks Naimish

Naimish Makwana · Answer

Hello Ramco, What is the datatype of publishedAt field in your model? if it is string then change it to. public DateTime publishedAt { get; set; } Thanks Naimish Makwana

Naimish Makwana · Answer

Hello Ramco, Also add order by in tagResponse var tagResponse = clientTag.Execute (tagRequest); var orderByTagResponsePublishAt = tagResponse.Data?.items.OrderBy(x => x.snippet.publishedAt); foreach (var searchResult in orderByTagResponsePublishAt) { . . . Thanks Naimish Makwana

Naimish Makwana · Answer

Hello Ramco, try below code: var response = client.Execute (request); var orderBtPublishAt = response.Data?.items.OrderBy(x => x.snippet.publishedAt); foreach (var data in orderBtPublishAt) { . . . //Rest of your code Thanks Naimish Makwana

Ramco Ramco · Answer

Hi Naimish Till this line data is o.k . It shows in ascending order in orderByPublishAt. Why in actual output it shows awkward results In orderByPublishAt it shows correctly. foreach (var data in orderByPublishAt) { Thanks

Ramco Ramco · Answer

Hi Written this but still nor ordering request.AddParameter("order", "date"); Thanks

Ramco Ramco · Answer

it is Datetime Below r the Classes public class Thumbnail { public string url { get; set; } public int width { get; set; } public int height { 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 Thumbnail thumbnails { get; set; } public string channelTitle { get; set; } public string liveBroadcastContent { get; set; } public DateTime publishTime { get; set; } } public class Id { public string kind { get; set; } public string videoId { get; set; } } public class Item { public string kind { get; set; } public string etag { get; set; } public Id id { get; set; } public Snippet snippet { get; set; } } public class PageInfo { public int totalResults { get; set; } public int resultsPerPage { get; set; } } public class YoutubeSearchListResponse { public string kind { get; set; } public string etag { get; set; } public string nextPageToken { get; set; } public string regionCode { get; set; } public PageInfo pageInfo { get; set; } public List items { get; set; } } public class TagItem { public string Id { get; set; } public TagSnippet Snippet { get; set; } } public class TagSnippet { public List Tags { get; set; } public string categoryId { get; set; } } public class VideoListResponse { public string kind { get; set; } public string etag { get; set; } public List items { get; set; } public PageInfo pageInfo { get; set; } public class Item { public string kind { get; set; } public string etag { get; set; } public string id { get; set; } public Snippet snippet { get; set; } public Statistics statistics { 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 List tags { get; set; } public string categoryId { get; set; } public string liveBroadcastContent { get; set; } public string defaultLanguage { get; set; } public Localized localized { get; set; } public string defaultAudioLanguage { get; set; } } public class Statistics { public int viewCount { get; set; } public string likeCount { get; set; } public string favoriteCount { get; set; } public string commentCount { get; set; } } public class Thumbnails { public Thumbnail defaultThumb { get; set; } public Thumbnail medium { get; set; } public Thumbnail high { get; set; } public Thumbnail standard { get; set; } public Thumbnail maxres { get; set; } } public class Thumbnail { public string url { get; set; } public int width { get; set; } public int height { get; set; } } public class Localized { public string title { get; set; } public string description { get; set; } } public class PageInfo { public int totalResults { get; set; } public int resultsPerPage { get; set; } } } public class VideoCategoryListResponse { public string Kind { get; set; } public string Etag { get; set; } public List Items { get; set; } } public class VideoCategory { public string Id { get; set; } public VideoCategorySnippet Snippet { get; set; } } public class VideoCategorySnippet { public string Title { get; set; } public bool Assignable { get; set; } public string ChannelId { get; set; } } public class YouTubeSearchResponse { public List Items { get; set; } } Thanks

Ramco Ramco · Answer

Hi Naimish Still not working. Secondly since we have orderby in beginning then why we need second time Thanks

Ramco Ramco · Answer

Hi Naimish It is not working. protected void MyOwnVideos() { 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("q", "sports shorts"); request.AddParameter("type", "video"); request.AddParameter("order", "viewCount"); request.AddParameter("videoDuration", "short"); request.AddParameter("channelId", "ChannelId"); request.AddParameter("key", "ApiKey"); var response = client.Execute (request); var orderByPublishAt = response.Data.items.OrderBy(x => x.snippet.publishedAt); List listVideo = new List (); htmlTable.Append(" "); htmlTable.Append(" Video Id Video Title Description Views Like Comment Category Published "); htmlTable.Append(" "); //response.Data.items foreach (var data in orderByPublishAt) { var clientTag = new RestClient("googleapis.com/youtube/v3/"); var tagRequest = new RestRequest("videos", Method.GET); tagRequest.AddParameter("key", "Apikey"); tagRequest.AddParameter("part", "snippet,statistics"); //tagRequest.AddParameter("maxResults", 100); request.AddParameter("order", "viewCount"); tagRequest.AddParameter("id", data.id.videoId); var tagResponse = clientTag.Execute (tagRequest); foreach (var item in tagResponse.Data.items) { htmlTable.Append(" " + data.snippet.title + " "); htmlTable.Append(" " + item.snippet.title + " "); htmlTable.Append(" " + item.snippet.description + " "); htmlTable.Append(" " + item.statistics.viewCount + " "); htmlTable.Append(" " + item.statistics.likeCount + " "); htmlTable.Append(" " + item.statistics.commentCount + " "); htmlTable.Append(" " + Convert.ToDateTime(item.snippet.publishedAt).ToString("dd-MM-yyyy") + " "); htmlTable.Append(" "); } } htmlTable.Append(" "); htmlTable.Append(" "); PlaceHolderTable.Controls.Add(new Literal { Text = htmlTable.ToString() }); } Thanks