Error: "This file is too large to be exported"

[bardo]

Which version of integration_google are you using?

2.2.0

Which version of Nextcloud are you using?

29.0.1.1

Which browser are you using? In case you are using the phone App, specify the Android or iOS version and device please.

N/A

Describe the Bug

Certain files result in the following error:

{                                                                                                                       
  "reqId": "$REQUEST",
  "level": 2,
  "time": "2024-05-27T09:13:44+00:00",
  "remoteAddr": "",
  "user": "$USER",
  "app": "integration_google",
  "method": "",
  "url": "--",
  "message": "Google API error : Client error: `GET https://www.googleapis.com/drive/v3/files/$FILE/export?mimeType=application%2Fvnd.openxmlformats-officedocument.wordprocessingml.document` resulted in a `403 Forbidden` response:\n{\n  \"error\": {\n    \"code\": 403,\n    \"message\": \"This file is too large to be exported.\",\n    \"errors\": [\n      {\n        (truncated...)\n",
  "userAgent": "--",
  "version": "29.0.1.1",
  "data": {
    "app": "integration_google"
  }
}

Expected Behavior

Files are transferred correctly.

To Reproduce

Not sure about repro since I do not know the target file, however I found a few potentially useful references:

• StackOverflow answer proposing to use the exportLinks field.
• JavaScript implementation of the above.
• Python implementation, same technique.

[github-actions[bot]]

Hello :wave:

Thank you for taking the time to open this issue with integration_google. I know it's frustrating when software causes problems. You have made the right choice to come here and open an issue to make sure your problem gets looked at and if possible solved. We try to answer all issues and if possible fix all bugs here, but it sometimes takes a while until we get to it. Until then, please be patient. If you are strugging to set up the app, have a look at this video: https://www.youtube.com/watch?v=h_teJPg2wEk Note also that GitHub is a place where people meet to make software better together. Nobody here is under any obligation to help you, solve your problems or deliver on any expectations or demands you may have, but if enough people come together we can collaborate to make this software better. For everyone. Thus, if you can, you could also look at other issues to see whether you can help other people with your knowledge and experience. If you have coding experience it would also be awesome if you could step up to dive into the code and try to fix the odd bug yourself. Everyone will be thankful for extra helping hands! One last word: If you feel, at any point, like you need to vent, this is not the place for it; you can go to the forum, to twitter or somewhere else. But this is a technical issue tracker, so please make sure to focus on the tech and keep your opinions to yourself. (Also see our Code of Conduct. Really.)

I look forward to working with you on this issue Cheers :blue_heart: