angularjs - YouTube 分析 - 创建请求

Question

我正在尝试向 youtube 分析 API 发出请求。我在形成请求时遇到一些困难，因此它们被接受。我正在使用 Google API Node.js 客户端

https://github.com/google/google-api-nodejs-client

我的代码如下

import { Meteor } from 'meteor/meteor';
import google from 'googleapis';
import KEY_FILE from './keyFile.json';
import { CHANNEL_ID } from './channelId.js';

//api's
const analytics = google.youtubeAnalytics('v1');

//fetch youtube analytics
export function youtubeAnalytics(start, end){
  //initalise request data
  const startDate = `${start.getFullYear()}-${('0'+(start.getMonth()+1)).slice(-2)}-${('0'+(start.getDate())).slice(-2)}`;
  const endDate = `${end.getFullYear()}-${('0'+(end.getMonth()+1)).slice(-2)}-${('0'+(end.getDate())).slice(-2)}`;
  const scopes = [
    'https://www.googleapis.com/auth/youtube',
    'https://www.googleapis.com/auth/youtube.readonly',
    'https://www.googleapis.com/auth/yt-analytics-monetary.readonly',
    'https://www.googleapis.com/auth/yt-analytics-monetary.readonly'
  ];

  //generate authorisation token
  var AUTH = new google.auth.JWT(
    KEY_FILE.client_email,
    null,
    KEY_FILE.private_key,
    scopes,
    null
   );

  //authorize request
  AUTH.authorize(function (err, tokens) {
    if (err) {
      console.log(err);
      return;
    }

    //create request
    const analyticsRequest = {
      auth: AUTH,
      'start-date': startDate,
      'end-date': endDate,
      ids: `channel==${CHANNEL_ID}`,
      metrics: 'views',
    };

    //make request
    analytics.reports.query(analyticsRequest, function (err, data) {
      if (err) {
        console.error('Error: ' + err);
        return false;
      }
      if (data) {
        console.log(data);
        return data;
      }
    });
  });
  return false;
}

Meteor.methods({youtubeAnalytics});

我不断收到以下错误

Error: Error: Invalid query. Query did not conform to the expectations.

我认为这与我的请求对象有关

const analyticsRequest = {
  auth: AUTH,
  'start-date': startDate,
  'end-date': endDate,
  ids: `channel==${CHANNEL_ID}`,
  metrics: 'views',
};

但我发现的所有示例都表明此请求对象应该有效。我已经尽可能地简化了它。我最初的请求(我真正想要的)如下。

const analyticsRequest = {
   auth: AUTH,
   'start-date': startDate,
   'end-date': endDate,
   ids: `channel==${CHANNEL_ID}`,
   metrics: 'views',
   dimensions: 'video',
   sort: '-views',
   'max-results': '200'
}

之后，我需要执行另一个请求来获取使用不同 API 端点的列出视频的所有相关信息。

//api's
const youtube = google.youtube('v3');

/*
  do processing of analytics data to create batchRequest
  which is a string of comma separated video ids
*/

videoRequest = {
   auth: AUTH,
   part: 'id,snippet',
   id: batchRequest;
}

youtubeApiData.search.list(videosRequest, function (err, data) {
   if (err) {
      console.error('Error: ' + err);
      return false;
   }
   if (data) {
      console.log(data);
      return data;
   }
});

总结一下

我需要向各种 google api 发出请求，但在形成请求时遇到问题，因此它们被接受(我还没有通过 youtube 分析的第一个请求)。

有人能指出我正确的方向吗？

Answer 1

想通了。无法为此 API 执行服务帐户请求。我通过 account-google 设置帐户验证

https://guide.meteor.com/accounts.html

使用帐户合并将其合并到基本帐户

https://atmospherejs.com/splendido/accounts-meld

这为我提供了附加到用户的访问 token ，然后进行了 OAuth 2.0 调用。 Facebook 也做了类似的事情。

我仍然遇到的一个问题是“视频的获取保留”部分效率非常低。每个视频调用一次电话。 google api 有可用的批量请求，但我似乎无法找到使用“googleapis”包的正确示例。如果有人有一个例子，将不胜感激。

这是新代码。

import { Meteor } from 'meteor/meteor';
import google from 'googleapis';
import { CHANNEL_ID, USER_ID, KEY_FILE, API_KEY, CLIENT_ID, CLIENT_SECRET } from './keys.js';

//api's
const fetchAnalytics = google.youtubeAnalytics('v1');
const fetchYoutube = google.youtube('v3');
const OAuth2 = google.auth.OAuth2;

export function youtubeAnalytics(start, end){
  //requires login to generate authorisation
  const user = Meteor.user();
  if(user && user.services && user.services.google && user.services.google.accessToken){
    //-------------------- general setup -------------------- //

    //convert async functions to sync functions
    const fetchYoutubeSync = Meteor.wrapAsync(fetchYoutube.search.list);
    const fetchAnalyticsSync = Meteor.wrapAsync(fetchAnalytics.reports.query);

    // set up default values
    const analytics = {views: [], retention: []};
    const videos = [];

    const startDate = `${start.getFullYear()}-${('0'+(start.getMonth()+1)).slice(-2)}-${('0'+(start.getDate())).slice(-2)}`;
    const endDate = `${end.getFullYear()}-${('0'+(end.getMonth()+1)).slice(-2)}-${('0'+(end.getDate())).slice(-2)}`;
    const startDateLong = `${start.getFullYear()}-${('0'+(start.getMonth()+1)).slice(-2)}-${('0'+(start.getDate())).slice(-2)}T00:00:00.0+00:00`;
    const endDateLong = `${end.getFullYear()}-${('0'+(end.getMonth()+1)).slice(-2)}-${('0'+(end.getDate())).slice(-2)}T00:00:00.0+00:00`;

    // generate authorisation tokens
    const oauth2Client = new OAuth2(CLIENT_ID, CLIENT_SECRET,'');
    oauth2Client.setCredentials({access_token: user.services.google.accessToken});
    google.options({
      auth: oauth2Client
    });

    //-------------------- fetch videos between dates -------------------- //

    let fetch = true;
    let next = '';
    while (fetch) {
      //create video request
      let videosRequest = {
        auth: oauth2Client,
        part: 'id,snippet',
        type: 'video',
        channelId: CHANNEL_ID,
        publishedAfter: startDateLong,
        publishedBefore: endDateLong,
        maxResults: 50,
        pageToken: next,
      }
      //make video request
      let response = fetchYoutubeSync(videosRequest);
      //store video request
      videos.push.apply(videos, response.items);
      //check if more data is available
      if(response.nextPageToken){ next = response.nextPageToken; }
      else{ fetch = false;}
    }

    //-------------------- create batch request objects -------------------- //
    if(videos.length > 0){
      //process videos
      let batchRequestViews = '';
      let batchRequestRetention = [];
      let first = true;
      for(let i = 0; i < videos.length; i += 1){
        let id = false;
        if(videos[i].id.kind === 'youtube#video'){ id = videos[i].id.videoId;}
        if(id){
          //views processing
          if(first){ first = false; batchRequestViews = id;}
          else{ batchRequestViews = `${batchRequestViews},${id}`}
          //retention processing
          let request = {
            auth: oauth2Client,
            'start-date': startDate,
            'end-date': endDate,
            ids: `channel==${CHANNEL_ID}`,
            metrics: 'audienceWatchRatio',
            dimensions: 'elapsedVideoTimeRatio',
            filters: `video==${id}`
          };
          batchRequestRetention.push(request);
        }
      }

      //-------------------- fetch views for videos  -------------------- //

      // create views request
      const analyticsRequestViews = {
        auth: oauth2Client,
        'start-date': startDate,
        'end-date': endDate,
        ids: `channel==${CHANNEL_ID}`,
        metrics: 'views',
        dimensions: 'video',
        filters: `video==${batchRequestViews}`
      };
      // make and store views request
      analytics.views = fetchAnalyticsSync(analyticsRequestViews).rows;

      //-------------------- fetch retention for videos  -------------------- //

      //make retention batch request
      if(batchRequestRetention && batchRequestRetention.length > 0){
        for(let i = 0; i < batchRequestRetention.length; i += 1){
          //fetch retention request
          let request = batchRequestRetention[i];
          //make retention request
          let response = fetchAnalyticsSync(request);
          //store response
          analytics.retention.push({id: request.filters.substring(7), response});
        }
      }

      //-------------------- return results  -------------------- //
      return {videos, analytics};
    }
  }
  return false;
}

Meteor.methods({youtubeAnalytics});