How to get data from consumer.query()?

Question

I want to develop a simple webpage using HTML, Javascript and Socrata.

I write this page:

    <body>
    <script src="../lib/soda-js.bundle.js"></script>
    <script>
        var consumer = new soda.Consumer('dati.lombardia.it');
        consumer.query()
            .withDataset('mmyz-duph')
            .limit(100)
            .where({ localita : "Suzzara" })
            .getRows()
                .on('success', function(rows) { console.log(rows); alert('Ok'); })
                .on('error', function(error) { console.error(error); alert('Ci sono problemi'); });



        var righe = consumer.query()
                        .withDataset('mmyz-duph')
                        .limit(100)
                        .where({ localita : "Suzzara" })
                        .getRows();

        /*
            --- Don't work! ---
        for (item in righe) {
            document.write("Email: ");
            document.write(item.email);
            document.write('<br>');
        };
        */

        document.write('<br>');
        document.write('Ho finito di elaborare i dati');
    </script>
</body>

There is a list of chemist's shops in Suzzara (a small Italian city) and I want write email addresses (there are 5 shops). From Firefox's consolle: I see 1 array (5 objects) => OK.

How I can display the email's addresses? Example: Email: pippo@email.com ... ... ... ...

score 0 · Answer 1 · edited May 23 '17 at 11:33

First, JavaScript's "for-in" loop iterates through the keys of an array (read more here), not each element of an array.

Second, your JS is performing an AJAX call so your current for loop would be executed before you even got data back from Socrata, so there'd be nothing to loop over. That's why the .on() function is used, so you can execute code once the data is returned.

var consumer = new soda.Consumer('dati.lombardia.it');
consumer.query()
  .withDataset('mmyz-duph')
  .limit(100)
  .where({ localita : "Suzzara" })
  .getRows()
  .on('success', function(rows) {
    // since you're using a for-in loop, this is how it'd work
    for (i in rows) {
      console.log(rows[i]['email']);
    }
  })
  .on('error', function(error) { console.error(error); });

How to get data from consumer.query()?

1 Answers1