下面的脚本将instagram站点称为“ data1”,并将其打印UserCount
到电子表格中。但我想用不同的instagramAccountName
我想再设置3个数据。
该工具var instagramAccountName = "data1"&&"data2";
不起作用,所以您有什么建议?
var sheetName = "Tabellenblatt1";
var instagramAccountName = "data1";
function insertFollowerCount() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName(this.sheetName);
accountdata = getInstagramData(this.instagramAccountName);
sheet.appendRow([instagramAccountName, Utilities.formatDate(new Date(), "GMT", "yyyy-MM-dd"), accountdata.followerCount]);
};
function getInstagramData(username) {
var r = new RegExp('<script type="text\/javascript">' +
'([^{]+?({.*profile_pic_url.*})[^}]+?)' +
'<\/script>');
var url = "https://www.instagram.com/" + username
var source = UrlFetchApp.fetch(url).getContentText();
var jsonStr = source.match(r)[2];
var data = JSON.parse(jsonStr);
console.log('data', data);
var oldVariantOfData = data['entry_data']['ProfilePage'][0];
console.log('oldVariantOfData', oldVariantOfData);
return {
followerCount : oldVariantOfData.graphql.user.edge_followed_by.count,
followCount : oldVariantOfData.graphql.user.edge_follow.count,
mediaCount : oldVariantOfData.graphql.user.edge_owner_to_timeline_media.count
};
}
this
。"data1" && "data2"
等于“ data1 AND data2”(Google Apps脚本是JavaScript的子集),该变量始终存储true
在instagramAccountName
变量中。instagramAccountName
变量Array
name写入变量= ['n1','n2']
,然后getInstagramData(username)
使用for
,for...of
循环或forEach
方法进行调用。最后,您的函数应如下所示(顺便说一句,accountdata
应在外部范围中定义,否则将获得ReferenceError
):
var instagramAccountName = ['data1','data2'];
function insertFollowerCount() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName(sheetName);
instagramAccountName.forEach(function(username){
accountdata = getInstagramData(username);
sheet.appendRow([username, Utilities.formatDate(new Date(),
"GMT", "yyyy-MM-dd"), accountdata.followerCount]);
});
};
参考文献
forEach
MDN上的方法参考本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句