Oauth2 client for scripting, for example to access google drive

Ignition
,
1

I'm trying to load data from some google sheets directly through scripting. I'd like to do this via an oauth2 token that is used to authenticate and get access to the appropriate documents, but I don't think I can use the standard oauth2client + pygsheets (or gspread) schema from within Ignition. I still have hope that I can do it directly using the requests library, but it still requires successfully connecting. I have found Gateway / Config / Security / Oauth2 Clients, generated a client on GCP and given it the required tokens and keys, but it doesn't seem to be happy.

Has anyone ever tried to do something like this and might have some pointers?

2

Last I heard, this feature was only working with email profiles. Eventually to be expanded to scripting, but wasn't a high priority.

3

Ah darn. Any ideas about how to circumvent within Ignition that or should I just set up an unrelated service on our servers for file sync?

4

Not sure. It's probably reachable if you're willing to go spelunking with reflection. Depends how important a unified system is to you.

5

While I feel very comfortable spelunking in python 3+, not so much in jython. Ill probably offload it, we already have a growing cadre of services supporting Ignition perhiperally. I just try to get it in the main system first if I can.