YouTube Analytics API- Only recognizing the first row

[steven.h.liu.1]

Hi- I’m setting up the YouTube Analytics API, but it is only recognizing the first row item. How do I set it up, so it would recognize the other data points as well?

Here’s the raw output (+image of the API setup below):

{
“kind”: “youtubeAnalytics#resultTable”,
“columnHeaders”: [
{
“name”: “ageGroup”,
“columnType”: “DIMENSION”,
“dataType”: “STRING”
},
{
“name”: “gender”,
“columnType”: “DIMENSION”,
“dataType”: “STRING”
},
{
“name”: “viewerPercentage”,
“columnType”: “METRIC”,
“dataType”: “FLOAT”
}
],
“rows”: [
[
“age13-17”,
“male”,
0.3
],
[
“age18-24”,
“female”,
0.1
],
[
“age18-24”,
“male”,
42
],
[
“age25-34”,
“female”,
0.2
],
[
“age25-34”,
“male”,
45.9
],
[
“age35-44”,
“female”,
0.1
],
[
“age35-44”,
“male”,
9.9
],
[
“age45-54”,
“female”,
0
],
[
“age45-54”,
“male”,
1.4
]
]
}

[steven.h.liu.1]

I set up a backend + frontend workflows to process the nested array. Could someone verify I’ve set it up correctly? (It’s my first time ).

I’m trying to capture the API call and put all the entries into the database.

Backend

Frontend