Googledrive resources/how to get modified date

[sarah]

I'm getting up and running with the googledrive package and wondering if there are any good resources/writeups out there beyond the package documentation and the googledrive.tidyverse.org site.

In particular I'm having trouble figuring out how to get the last modified date for a file - it doesn't seem to be one of the options for drive_reveal().

[mara]

I believe it's available in drive_find().
http://googledrive.tidyverse.org/articles/articles/file-identification.html#drive_find

[sarah]

Ah, yes, and then it's somewhere in that list that is the third column of the dribble. Thanks!

[jennybryan]

You can dig it -- and much more -- out of the drive_resource list-column.

This should get you started:

library(tidyverse)
x <- googledrive::drive_find(n_max = 3)
x %>% 
  mutate(modified = map_chr(drive_resource, "modifiedTime"))
#> # A tibble: 3 x 4
#>   name                             id            drive_resource modified  
#> * <chr>                            <chr>         <list>         <chr>     
#> 1 googlesheets4-design-exploration 1xTUxWGcFLtD… <list [32]>    2018-03-1…
#> 2 Internship Application           1ZioYgbU1bzS… <list [30]>    2018-03-1…
#> 3 2018 Webinars                    1WIf9VqQdGsB… <list [32]>    2018-03-1…

Created on 2018-03-15 by the reprex package (v0.2.0).

[sarah]

Yes, there's a lot in there - I had just breezed past that list column. Thanks!

[mara]

Hey @sarah,

When you get a chance, would you mind marking the answer to your question? The how-to for that is here:

FAQ: How do I mark a solution?

If your question has been answered, don't forget to mark the solution! How do I mark a solution? Find the reply you want to mark as the solution and look for the row of small gray icons at the bottom of that reply. Click the one that looks like a box with a checkmark in it: [image] Hovering over the mark solution button shows the label, "Select if this reply solves the problem". If you don't see the mark solution button, try clicking the three dots button ( ••• ) to expand the full set of options. When a solution is chosen, the icon turns green and the hover label changes to: "Unselect if this reply no longer solves the problem". Success! [solution_reply_author] …

[sarah]

Huh, you can only pick one? Both were very helpful...

[mara]

Oh, don't worry about that! It's just much easier if you can see that questions have been solved with that little check box!