4 weeks ago
Hello. I am evaluating the Google Sheets API, and have managed to use the Blue Prism Object to validate that I can interact with Google successfully. I have a few questions that will help identify whether it makes sense to adopt this tool, however.
1. If my google user policy indicates that a user must authenticate weekly, does that mean that I have to also prepare automations to complete the chrome browser confirm authentication steps? Domain wide auth is not an option, as it is a substantial security risk.
2. If the manual authentication is not complete, the code stage will stall out infinitely. Can I throw an exception on timeout without re-writing the code stages?
3. Can a single google account work across multiple Blue Prism VMs, or does each bot require it's own account?
2 weeks ago
I guess these details you can get from the Google Sheets detailed API documentation.
If you are using API you don't need a browser and UI for the authentication, right? From the API key itself, you can validate and make the API calls.