Using Javascript how do I find a path to an object nested in empty arrays?

Question

I am guessing my terminology in the following post is wrong. I am generally new to using APIs.

I am using an API from the Census Bureau that returns a list of of objects in JSON format. The issue I am having with this particular API is that it appears the arrays are nested within arrays that don't have names or any way to find a path through to the object.

Here is what the API query returns:

[
[
"DRRALL",
"CRRINT",
"RESP_DATE",
"CRRALL",
"GEO_ID",
"DRRINT",
"state"
],
[
"0.4",
"37.1",
"2020-04-10",
"41.4",
"0400000US36",
"0.4",
"36"
]
]

I am trying to obtain the date the information was queried and the response rate, but I just have never see JSON in this format. I checked to make sure it is valid JSON, and it is. I tried peeling away layer by layer, but I end up with undefined or empty arrays when attempting to push it to another variable.

Here is as close as I've gotten to the desired results:


fetch(url)
  .then((resp) => {
    return resp.json();
  })

  .then((data) => {
    stateArray.push(data[1]);
  });

console.log(stateArray);

Here's the result of my console log:

[]
0: (7) […]
0: "0.4"
1: "37.1"
2: "2020-04-10"
3: "41.4"
4: "0400000US36"
5: "0.4"
6: "36"
length: 7
<prototype>: Array []
length: 1

As you'll see, there is another empty array just before the array with my desired objects.

Any help would be great.

Thanks!

Is that the whole content of your json file?

Saadi Toumi Fouad
– Saadi Toumi Fouad

2020-04-10 19:59:33 +00:00
Commented Apr 10, 2020 at 19:59 — Saadi Toumi Fouad
– Saadi Toumi Fouad, Commented Apr 10, 2020 at 19:59

elvira.genkel · Accepted Answer · 2020-04-10 19:59:40Z

1

fetch function returns Promise which returns data asyncronously. At the moment when you invoke console.log(stateArray) Promise is not returned data yet. Move console.log(stateArray) into then statement:

fetch(url)
  .then((resp) => {
    return resp.json();
  })

  .then((data) => {
    stateArray.push(data[1]);
  })
.then(data => console.log(stateArray));

answered Apr 10, 2020 at 19:59

elvira.genkel

1,3331 gold badge6 silver badges12 bronze badges

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

2 Comments

rguttersohn Over a year ago

I could get that to work locally, but I have to pull multiple API queries for US, City and Counties as well so I was hoping to push them all global. Is that just not possible?

elvira.genkel Over a year ago

If you need several requests executed alltogether you can try to compose an array of requests and use Promise.all the get all the data thogether. And in then block after Promise.all() you can add all the data at once.

twharmon · Accepted Answer · 2020-04-10 20:05:31Z

0

It is valid JSON; its an array of arrays.

Maybe using the spread operator (stateArray.push(...data[1])) will push the JSON's arrays to stateArray.

edited Apr 10, 2020 at 20:05

answered Apr 10, 2020 at 20:00

twharmon

3,7905 gold badges27 silver badges50 bronze badges

Collectives™ on Stack Overflow

Using Javascript how do I find a path to an object nested in empty arrays?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related