Order by PublishedAt

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

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

Hi

  Written this but still nor ordering

request.AddParameter("order", "date");

Thanks

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 

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

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

Hi Naimish

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

Thanks

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

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("");
    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("");
            htmlTable.Append("");
            htmlTable.Append("");
            htmlTable.Append("");
            htmlTable.Append("");
            htmlTable.Append("");

            htmlTable.Append("");
            htmlTable.Append("");
        }
    }
    htmlTable.Append("");
    htmlTable.Append("
Video Id
Video Title
Description
Views
Like
Comment
Category
Published
" + data.snippet.title + "
" + item.snippet.title + "
" + item.snippet.description + "
" + item.statistics.viewCount + "
" + item.statistics.likeCount + "
" + item.statistics.commentCount + "
" + Convert.ToDateTime(item.snippet.publishedAt).ToString("dd-MM-yyyy") + "
");
    PlaceHolderTable.Controls.Add(new Literal { Text = htmlTable.ToString() });
}

Thanks

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