Directory Tool Compatibility with Google Drive?

[alevin]

Hello,

I have a use case where I need to extract the most recent file from a Google Drive folder. I understand this can be done with a Directory tool to extract file metadata; however, this workflow needs to be ran from Server. I need a way to allow the Directory tool to access my credentials in DCM to get to the files in the Google Drive when the workflow is ran on server, but I do not see a solution for this. Has anyone encountered a similar issue?

[Raj]

have you checked  Google Drive Input Tool (alteryx.com)
i think this can help you.

[alevin]

Hey Raj,

Yes I have that tool as well, but it doesn't allow for a dynamic input - meaning, if I want to import the most recent file in a folder where new files are being added each month, I have to tell the Google Drive Input tool explicitly what file to import. For this use case, I need it to be dynamic and pull the most recent one added rather than a static file.