CODEWITHSUNDEEP
javascriptarraysgoogle-apps-scriptmultidimensional-array
racker
racker

Reputation: 29

2D Arrays in Google Apps Script

I am self taught with Apps Script, so generally approach one problem at a time, as it comes up. Arrays are confusing!

I am using an API to get the number of social followers for Facebook, Twitter and Instagram accounts. Here is the code so far. Note I have removed the API call specifics for privacy, I have also used fake profile ID's in the above, for example 1111 = Facebook, 2222 = Twitter, etc...

  var response = UrlFetchApp.fetch(endpointUrl, params);
  var jsonss = JSON.parse(response.getContentText());
  var dataset = jsonss.data;
  Logger.log(dataset);

[{dimensions={customer_profile_id=1111, reporting_period.by(day)=2021-10-31}, metrics={lifetime_snapshot.followers_count=407919.0}}, {dimensions={reporting_period.by(day)=2021-10-31, customer_profile_id=2222}, metrics={lifetime_snapshot.followers_count=1037310.0}}, {dimensions={reporting_period.by(day)=2021-10-31, customer_profile_id=3333}, metrics={lifetime_snapshot.followers_count=806522.0}}]

then map the array -

  var followers = dataset.map(function(ex){return [ex.dimensions,ex.metrics]});
  Logger.log(followers);

[[{reporting_period.by(day)=2021-10-31, customer_profile_id=1111}, {lifetime_snapshot.followers_count=407919.0}], [{reporting_period.by(day)=2021-10-31, customer_profile_id=2222}, {lifetime_snapshot.followers_count=1037310.0}], [{customer_profile_id=3333, reporting_period.by(day)=2021-10-31}, {lifetime_snapshot.followers_count=806522.0}]]

Now I get stuck, I am not sure how to get 'followers_count' when 'profile_id=1111', can someone please help? I have tried using another map function ( var followers = dataset.map(function(ex){return [ex.dimensions.map(function(ex2){return [ex2.followers_count]}]}); ) however this doesn't work...

Any suggestions to push me in the right direction is very much appreciated!

Upvotes: 0

Views: 311

Answers (1)

Tanaike
Tanaike

Reputation: 201358

If Logger.log(followers); is [[{reporting_period.by(day)=2021-10-31, customer_profile_id=1111}, {lifetime_snapshot.followers_count=407919.0}], [{reporting_period.by(day)=2021-10-31, customer_profile_id=2222}, {lifetime_snapshot.followers_count=1037310.0}], [{customer_profile_id=3333, reporting_period.by(day)=2021-10-31}, {lifetime_snapshot.followers_count=806522.0}]] and you want to retrieve the value of lifetime_snapshot.followers_count: 407919 by using customer_profile_id: 1111, how about the following sample script?

Sample script:

In this sample script, your values of followers is used.

const profile_id = 1111; // Please set customer_profile_id you want to use.

const res = followers.reduce((ar, [a, b]) => {
  if (a["customer_profile_id"] == profile_id) {
    ar.push(b["lifetime_snapshot.followers_count"]);
  }
  return ar;
}, []);
if (res.length == 0) return;
const followers_count = res[0];
console.log(followers_count);
  • When this script is used for your values of followers, I thought that 407919 is retrieved.
  • If the same IDs are existing, you can retrieve them using console.log(res).

Reference:

Upvotes: 2

Related Questions