How can I retrieve specific data from ScriptDB database?

Question

As a learning exercise, I'm trying to query ScriptDb and return a person's name when my script has their email address. The function below returns "ScriptDbResult" instead of the correct name (which should be Patrick Farmer - see the list below the function). Can somebody please advise on what I'm doing wrong?

function getNameFromDb() {
var email = "[email protected]";
var db = ScriptDb.getMyDb();
var result = db.query(
    {Names: {Emails: email}});
Logger.log(result);
}

This is what the Logger shows is in the database:

{
  "Emails": "[email protected]",
  "Names": "Luca Jenkins"
}
{
  "Emails": "[email protected]",
  "Names": "Patrick Farmer"
}
{
  "Emails": "[email protected]",
  "Names": "Elizabeth Jennings"
}
{
  "Emails": "[email protected]",
  "Names": "Gabriel Ryan"
}

Srik · Accepted Answer · 2012-08-08 17:50:47Z

2

You are almost there. You indeed get back a ScriptDBResult object. You need to fecth results using the next method

while (result.hasNext()){
  var obj = result.next(); 
  Logger.log(obj.Names);
  Logger.log(obj.Emails);
}

answered Aug 8, 2012 at 17:50

Srik

7,9952 gold badges22 silver badges31 bronze badges

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

1 Comment

fullOfGAS Over a year ago

Thanks for such a rapid response Srik. I got an error message to start with but when I changed my query from 'var result = db.query( {Names: {Emails: email}});' to 'var result = db.query( {Emails: email});' it worked a treat.

Collectives™ on Stack Overflow

How can I retrieve specific data from ScriptDB database?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related