Few Videos are repeating again

After applying the fixes, the output should:

• Display 428 unique videos without any duplicates.
• Include all required columns (Sr., Video Id, Video Title, Description).

Part 3:

Explanation of Changes

1. Duplicate Filtering :

   • A HashSet named uniqueVideoIds is used to store unique video IDs. Before processing a video, its ID is checked against the HashSet. If the ID already exists, the video is skipped.

2. Pagination Logic :

   • The do-while loop ensures that all pages are processed until nextPageToken becomes null.
   • The nextPageToken is updated after each iteration, and the loop fetches the next page of videos.

3. HTML Table Structure :

   • Fixed the missing tag in the HTML table rows.
   • Added the Video Id column to display the unique video ID.

Part 2:
Below is the corrected version of your code with the necessary fixes:

protected void MyOwnVideos11()
{
    StringBuilder htmlTable = new StringBuilder();
    string nextPageToken = string.Empty;
    Int32 Sr = 1;

    // HashSet to track unique video IDs
    HashSet uniqueVideoIds = new HashSet();

    // Fetch the first page of videos
    var data0 = GetVideosList(nextPageToken);
    var orderByPublishAt = data0.items.OrderBy(x => x.snippet.publishedAt);

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

    do
    {
        foreach (var data in orderByPublishAt)
        {
            // Skip duplicate video IDs
            if (!uniqueVideoIds.Add(data.id.videoId))
                continue;

            var clientTag = new RestClient("https://googleapis.com/youtube/v3/");
            var tagRequest = new RestRequest("videos", Method.GET);
            tagRequest.AddParameter("key", "AG8");
            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("");
                htmlTable.Append("");
                htmlTable.Append("");
                htmlTable.Append("");
                htmlTable.Append("");

                Sr++;
            }
        }

        // Update nextPageToken and fetch the next page
        nextPageToken = data0.nextPageToken;
        if (!string.IsNullOrEmpty(nextPageToken))
        {
            data0 = GetVideosList(nextPageToken);
            orderByPublishAt = data0.items.OrderBy(x => x.snippet.publishedAt);
        }
    } while (!string.IsNullOrEmpty(nextPageToken));

    htmlTable.Append("");
    htmlTable.Append("
Sr.
Video Id
Video Title
Description
" + Sr + "
" + item.id + "
" + item.snippet.title + "
" + item.snippet.description + "
");
    PlaceHolderTable.Controls.Add(new Literal { Text = htmlTable.ToString() });
}

Part 1:

Root Causes and Solutions

1. Repeating Videos

The YouTube API's search.list endpoint may return duplicate video entries across different pages if the query parameters are not properly constrained. To address this:

• Filter Duplicates : Use a HashSet to track unique video IDs and ensure no duplicates are added to the table.
• Check Data Source : Verify that the data0.items collection does not already contain duplicates before processing.

2. Incorrect Video Count

The pagination logic might not be iterating through all pages correctly. This could happen if:

• The nextPageToken is not updated properly.
• The loop terminates prematurely due to an empty or null nextPageToken.

To fix this:

• Ensure the while loop continues until nextPageToken becomes null.
• Validate the API response to confirm that all pages are being fetched.