merge array of objects from fetched API with pagination with Google Apps Script

Question

I'm fetching a URL. The full response is spread over five pages.

I'm looping through each pages which returns me an array of object (please correct me if I'm wrong):

[{item_1=foo, item_2=bar, item_3=foobar, value_1=XX}, {item_1=bar, item_2=foo, item_3=barfoo, value_1=XX},etc...]

I want to consolidate all the response like if it was one big array of objects.

So far, I wrote this:

   for (i = 1; i <= total_pages; i++) {

    var rawResponse = UrlFetchApp.fetch(
    'url',
    {
      method: 'GET'
    })

   response[i] = JSON.parse(rawResponse);

    }

  var g = response[1].concat(response[2], response[3],response[4],response[5]);

g contains the desired output; however, as you can see, this is not dynamic. How can I solve this? I could you the push method, but I would return me a new array with each response.

Does this answer your question? List more than 30 students in a class in Google Classroom API query — tehhowch
– tehhowch, Commented Jan 7, 2020 at 19:00
I provide an example pattern to do this in the linked answer stackoverflow.com/a/49338510/9337071 — tehhowch
– tehhowch, Commented Jan 7, 2020 at 19:00

carlesgg97 · Accepted Answer · 2020-01-08 11:51:28Z

1

In order to make your code "dynamic" you could use the concat function inside the for-loop, for each of the pages. A possible modification of your code could look like the following, where the result variable would contain all the results:

var result = [];

for (var i = 1; i <= total_pages; i++) {
  var rawResponse = UrlFetchApp.fetch(
    'url',
    {
      method: 'GET'
    }
  );

  var current = JSON.parse(rawResponse);
  result = result.concat(current);
}

answered Jan 8, 2020 at 11:51

carlesgg97

4,4961 gold badge11 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

merge array of objects from fetched API with pagination with Google Apps Script

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related