getDocuments doesn't retrieve timestamp data about firestoregoogleappsscript HOT 6 CLOSED

Thanks for pointing this out — this is an issue specifically with the latest versions. I neglected to include all the document data in the return of the getDocuments function. It only returns the fields.

I'll add the timestamps back in soon, but in the meantime here's a workaround using the older version of the library:

If you use Version 8, the get function (when given a document path) will return all the document information, including its timestamp data and fields. The fields will be typed (e.g. a mapping to a string name: "Name" will show up in the object as name: { stringValue: "Name" } .

To unwrap the value document you get from calling FirestoreApp.get("your/document/path/here", email, key, projectid), call FirestoreApp.getFieldsFromFirestoreDocument(document).

from firestoregoogleappsscript.

@soitecOpensources In the latest library version (15), that functionality is now available! Added in this commit: eceb6de

from firestoregoogleappsscript.

I'm still not seeing timestamp data. That field returns null when using getDocuments().

from firestoregoogleappsscript.

@LaughDonor Are you using version 15 of the library? I just ran my tests again and saw a timestamp. Here's the code I used:

function test_readDocumentsWithTimestamp() {
  const collectionName = "timestamp_test_collection";
  
  const document1 = {
    "name": "test one!",
    "number": 1
  }
  
  const document2 = {
    "name": "test two!",
    "number": 2
  }
  
  firestore.createDocumentWithId("document1", collectionName, document1);
  firestore.createDocumentWithId("document2", collectionName, document2);
  
  const docs = firestore.getDocuments(collectionName);
  Logger.log(docs);
}

And it logged:

[
   {
      createTime=2018-05-15T00:04:56.340842Z,
      name=projects/xxxxxxxx/databases/(default)/documents/timestamp_test_collection/document1,
      updateTime=2018-05-15T00:04:56.340842Z,
      fields={
         number=1,
         name=test one!
      }
   },
   {
      createTime=2018-05-15T00:04:56.484303Z,
      name=projects/xxxxxxxx/databases/(default)/documents/timestamp_test_collection/document2,
      updateTime=2018-05-15T00:04:56.484303Z,
      fields={
         number=2,
         name=test two!
      }
   }
]

If you are using version 15 of the library, could you send the logs of the returned object from the getDocuments call?

from firestoregoogleappsscript.

@grahamearley Sorry, I meant the field timestamp typed data was not showing.

from firestoregoogleappsscript.

@LaughDonor Oh, I see what you're saying. Yes, there are still some unimplemented data types. I'll file an issue for getting those implemented.

from firestoregoogleappsscript.