Trouble accessing document content with Google Drive API

Other Questions Google drive
1

Hey everyone! I’m hitting a roadblock with the Google Drive API. I’ve managed to upload files, but downloading is giving me a headache. I’m trying to grab a document and read its text, but I’m running into issues.

Here’s what I’ve tried:

File file = driveService.files().get(fileId).execute();

The problem is that the downloadUrl always turns out to be null. I heard that Google Docs doesn’t provide a downloadUrl and instead suggests using export links. So I attempted the following:

String exportUrl = file.getExportLinks().get("text/plain");
HttpRequest request = driveService.getRequestFactory().buildGetRequest(new GenericUrl(exportUrl));
String content = request.execute().parseAsString();

But instead of the actual document content, I’m receiving some strange HTML that looks like the Google Docs welcome page. Has anyone managed to extract plain text from a Google Doc using the API? I’m really stuck and would appreciate any help. Thanks in advance!

2

hey nate, i’ve dealt with this before. u might wanna try using the files.export method instead. it’s specifically for google docs. something like:

OutputStream outputStream = new ByteArrayOutputStream();
driveService.files().export(fileId, "text/plain").executeMediaAndDownloadTo(outputStream);
String content = outputStream.toString();

this should give u the plain text. good luck!

3

I’ve been down this road before, and it can be frustrating. One thing that worked for me was using the Drive API’s files.export method combined with the Docs API for more complex documents. Here’s a snippet that might help:

String fileId = "your-file-id";
String mimeType = "text/plain";

ByteArrayOutputStream outputStream = new ByteArrayOutputStream();
driveService.files().export(fileId, mimeType).executeMediaAndDownloadTo(outputStream);

String content = new String(outputStream.toByteArray(), StandardCharsets.UTF_8);

This approach should give you the plain text content of Google Docs. For more structured documents, you might need to parse the content further. Remember to handle exceptions and close your streams properly. Also, make sure you have the necessary scopes in your OAuth 2.0 credentials to access and export the files.

4

I’ve encountered similar issues when working with the Google Drive API. One approach that’s worked well for me is using the Google Docs API in conjunction with the Drive API. It provides more granular control over document content.

First, you’ll need to add the Google Docs API to your project. Then, you can use something like this:

Document doc = docsService.documents().get(documentId).execute();
List<StructuralElement> content = doc.getBody().getContent();
StringBuilder text = new StringBuilder();
for (StructuralElement element : content) {
    if (element.getParagraph() != null) {
        for (ParagraphElement pElement : element.getParagraph().getElements()) {
            if (pElement.getTextRun() != null) {
                text.append(pElement.getTextRun().getContent());
            }
        }
    }
}

This method gives you more reliable access to the document’s content. Hope this helps!