title: Reading googledrive contents from R
body: <p>I'm aiming to get a list of all files in a Google Drive folder, as well at the associated metadata for those files. When I use drive_ls, it returns 3 columns {name, id, drive_resource}. drive_resource is a structured like this: list(kind = &quot;drive#file&quot;, id = &quot;abc&quot;,...). However, some of the list is not qualified by quotations, and commas are also occassionally used when not a separator.</p>
  <p>Any ideas how I might properly unlist this? I can't find anywhere in the package that can handle this.</p>
  <p>Using the package 'googledrive', I can get a list of all the files</p>
  <pre><code>a &lt;- drive_ls(path = &quot;abc&quot;, recursive = TRUE) 
  </code></pre>
  <p>The below attempt gets close, but fails to get thee column names and also splits some values at the wrong place based on a comma being contained in the string.</p>
  <pre><code>a$drive_resource &lt;- vapply(a$drive_resource, paste, collapse = &quot;,&quot;, character(1L))
  
  abcd &lt;- a%&gt;% separate(drive_resource, sep = &quot;,&quot;, into = c(&quot;1&quot;,&quot;2&quot;,&quot;3&quot;,&quot;4&quot;,&quot;5&quot;,&quot;6&quot;,&quot;7&quot;,&quot;8&quot;,&quot;9&quot;,&quot;10&quot;,&quot;11&quot;,&quot;12&quot;,&quot;13&quot;,&quot;14&quot;,&quot;15&quot;,&quot;16&quot;,&quot;17&quot;,&quot;18&quot;,&quot;19&quot;,&quot;20&quot;,&quot;21&quot;,&quot;22&quot;,&quot;23&quot;,&quot;24&quot;,&quot;25&quot;,&quot;26&quot;,&quot;27&quot;,&quot;28&quot;,&quot;29&quot;,&quot;30&quot;) )
  </code></pre>