[source-google-drive] return deleted records too

[parthiv11]

Connector Name

souce-google-drive

Connector Version

v0.3.3

What step the error happened?

During the sync

Relevant information

source-google-drive returns deleted records as well from folder.
it is due to the query passed to find the files
current query: f"'{folder_id}' in parents" --> returns all files in folder regardless of whether they are deleted or not
suggested fix: f"'{folder_id}' in parents and trashed = false" --> this will return only files in the folder that are not trashed

refrence:

airbyte/airbyte-integrations/connectors/source-google-drive/source_google_drive/stream_reader.py

Line 139 in a202ced

q=f"'{folder_id}' in parents",

Relevant log output

Contribute

• Yes, I want to contribute