Hey everyone so someone asked a question and I think I have a solution for.
https://powerusers.microsoft.com/t5/Using-Connectors/How-to-list-more-than-100-files-in-Google-Drive-Connector/m-p/2025865#M17516
I would need to run very basic low level R code to create a better connector than the one currently available for google drive.
The function would take into 2 variables:
- the Credentials for a scope-limited google service account password exceeding 4096 to 16384 character long. Either the password or .json are change at regular intervals. Essentially I am setting up the google equivalent of the Managed Instance User that Microsoft uses to connect a local and online Active Directory together.
- Either a search term of for a url
Then output the data needed. This is a pretty typical technique used when a vendor does not provide the proper connector for a given datasource.
Can we run low level R or Python in Power Automate?