Google Sheet Integration failing with file not found

[manmeetkaur-kin]

Same sheet was getting pulled earlier; now it is giving this error; Tried to create a new sheet and pulled it but the same error.

INFO HTTP request to "file_metadata" endpoint took 0.203s, returned status code 404 2020-03-03 08:45:46,070Z tap - CRITICAL {'code': 404, 'message': 'File not found: xxxxxxxxxxxx.', 'errors': [{'location': 'fileId', 'message': 'File not found: xxxxxxxxxxx.', 'locationType': 'parameter', 'reason': 'notFound', 'domain': 'global'}]}: Unknown Error

[ghost]

I encountered this problem too with a sheet in a shared Google Drive. Works fine if I moved to to my own drive, but consistently gets this error if it's in a shared drive:

{'message': 'File not found: XXX.', 'errors': [{'locationType': 'parameter', 'message': 'File not found: XXX.', 'reason': 'notFound', 'domain': 'global', 'location': 'fileId'}], 'code': 404}: Unknown Error

[shedd]

I encountered this problem too with a sheet in a shared Google Drive. Works fine if I moved to to my own drive, but consistently gets this error if it's in a shared drive:

This was exactly the issue that we ran into. Moving the file out of a shared drive fixed the problem.

I've suggested a note to the Stitch docs on this point: https://github.com/stitchdata/docs/pull/532