Wrong Data Showing

Hi Ramco,

As I see you are trying to get shorts of last 7 days. Please check below code. 

           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("maxResults", "10");
            request.AddParameter("q", "shorts football");
            request.AddParameter("order", "viewCount");
            request.AddParameter("sortOrder", "desc");
            request.AddParameter("key", "your api key");

            request.AddParameter("publishedAfter", DateTime.Now.AddDays(-7).ToString("yyyy-MM-ddTHH:mm:ss.fffffffZ"));
            request.AddParameter("publishedBefore", DateTime.Now.ToString("yyyy-MM-ddTHH:mm:ss.fffffffZ"));

            var response = client.Execute(request);
            var json = response.Content;

            var obj = JObject.Parse(json);
            var items = obj["items"].ToList();

            var htmlTable = new StringBuilder();

            htmlTable.Append("");
            htmlTable.Append(
                "");
            htmlTable.Append("");


            foreach (var item in items)
            {
                var tagRequest0 = new RestRequest("videos", Method.Get);
                tagRequest0.AddParameter("key", "your api key");
                tagRequest0.AddParameter("part", "snippet,statistics");
                tagRequest0.AddParameter("id", item["id"]["videoId"].ToString());
                var tagResponse0 = client.Execute(tagRequest0);

                foreach (var searchResult in JObject.Parse(tagResponse0.Content)["items"].ToList())
                {
                    htmlTable.Append(
                        $"");
                }

                

            }
            htmlTable.Append("
SN
Channel Id
Channel Title
Video Title
Description
Tags
Views
Published
{item["id"]["videoId"].ToString()}
{item["snippet"]["channelId"].ToString()}
{item["snippet"]["channelTitle"].ToString()}
{item["snippet"]["title"].ToString()}
{item["snippet"]["description"].ToString()}
{searchResult["snippet"]["tags"]}
{searchResult["statistics"]["viewCount"]}
{item["snippet"]["publishedAt"]}
");
            View1.InnerHtml = htmlTable.ToString();

 

Regards,
Pasang

Hi Naimish

  It is not showing short videos. It is displaying Long videos

Thanks

Hi Naimish

  That is o.k . In case i want only sports shorts then what change i have to do

Thanks

Hello Ramco,

For short video. Try belwo code. 

request.AddParameter("videoDuration", "short");
var today = DateTime.Now.Date;
var sevenDaysAgo = today.AddDays(-7).ToString("yyyy-MM-ddTHH:mm:ssZ");
request.AddParameter("publishedAfter", sevenDaysAgo);

Also remove "q" parameter and increase maxresult line. 

//  request.AddParameter("q", "short videos category");
request.AddParameter("maxResults", 50);

Thanks

Naimish

Hi

   I want youtube short views of other not mine. It should not be such figures.

Thanks

So what result you would be expecting? May be your last 7days data has that much views only.

Can you please explain in details?

Thanks 

Hi Naimish

  It is showing videos which have 10,30,70 views which appears to be totally wrong. Sharing complete code

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

            //request.AddParameter("publishedAfter", DateTime.Today.ToString("yyyy-MM-ddTHH:mm:ss.fffffffZ"));
            //request.AddParameter("publishedBefore", DateTime.Today.AddDays(7).ToString("yyyy-MM-ddTHH:mm:ss.fffffffZ"));
            request.AddParameter("q", "short videos category");
            request.AddParameter("type", "video");
            request.AddParameter("maxResults", 10);
            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;
            foreach (var data in response.Data.items)
            {
                var clientTag0 = new RestClient("https://www.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)
                    {
                        htmlTable.Append("");
                        htmlTable.Append("");
                        htmlTable.Append("");
                        //htmlTable.Append("");
                        htmlTable.Append("");
                        //htmlTable.Append("");
                        htmlTable.Append("");
                        if (item.snippet != null && item.snippet.tags != null)
                        {
                            htmlTable.Append("");
                        }
                        else
                            htmlTable.Append("");

                        htmlTable.Append("");
                        htmlTable.Append("");

                        htmlTable.Append("");
                        Count++;
                    }
                }

            htmlTable.Append("");
            htmlTable.Append("
SN
Channel Id
Channel Title
Video Title
Description
Tags
Views
Published
" + Count.ToString() + "
" + item.snippet.channelId + "
" + item.snippet.channelTitle + "
" + item.snippet.title + "
" + item.snippet.title + "
" + data.snippet.title + "
" + item.snippet.description + "
" + String.Join(",", item.snippet.tags) + "
" + "" + "
" + item.statistics.viewCount + "
" + item.snippet.publishedAt + "
");
            PlaceHolderTable.Controls.Add(new Literal { Text = htmlTable.ToString() });
            //}
        }

Thanks

Hello Ramco,

Add parameter like below.

// Set the date range for the latest 7 days
var today = DateTime.Now.Date;
var sevenDaysAgo = today.AddDays(-7).ToString("yyyy-MM-ddTHH:mm:ssZ");
request.AddParameter("publishedAfter", sevenDaysAgo);

Remove 'publishedBefore' param and try.

Thanks

Naimish makwana