Trying to iterate over JSON array of objects but its empty?

Question

I am using papa parse to get fields from a google csv sheet and parses that information into JSON array. Here is an image of what my code currently returns: https://i.stack.imgur.com/toHlJ.jpg

Here's the code:

parseSites = () => {
  var url = "https://docs.google.com/spreadsheets/fakelinklol";
  var ForumCSVResults = Papa.parse(url, {
    download: true,
    header: true,
    complete: results => {
      results.data.forEach(result => {
        ForumData.push(result);
      })
    }
  })

}
console.log('Data without JSON.stringify()')
console.log(ForumData);
console.log('Data with JSON.stringify()')
console.log(JSON.stringify(ForumData))

function validate() {
  var newArr = [];
  var email = document.getElementById('email').value;
  var password = document.getElementById('password').value;
  var creds = [email, password];
  console.log(creds);
  ForumData.forEach(function(element) {
    console.log(JSON.stringify(element.email))
  })
}

ForumData.forEach doesn't even execute because apparently it is empty? I want to be able too iterate over each JSON object and compare email and password to creds. Appreciate any insight.

`Papa.parse()` is asynchronous. Put everything that uses `ForumData` inside the `complete:` function. — Barmar, Nov 07 '19 at 02:20

oreopot · Answer 1 · 2019-11-07T02:36:05.007

0

Within complete write the following code:

console.log(JSON.parse(results))

edited Nov 07 '19 at 02:36

answered Nov 07 '19 at 02:21

oreopot

3,392
2
19
28

Uncaught SyntaxError: Unexpected end of JSON input – Omi in a hellcat Nov 07 '19 at 02:28

Trying to iterate over JSON array of objects but its empty?

1 Answers1