Systematically reference account User Activity table

[dbaum]

Is there some way to systematically reference an AppSheet account's User Activity table? For instance, to streamline preparation of client invoices when I'm billing clients for their users who accessed an app (i.e., retrieve the list of my account's authenticated users and the apps they've each accessed for the purpose of then matching to an individual app's Users table where each user is associated to a client).

I see that I can download a .csv file of the table, which I'm sure I can then process to accomplish what I need--probably even by setting up a .csv import into the app I use to prepare invoices. However, I wonder whether there's a less manual procedure that I could invoke directly from my invoicing app.

[Steve · Accepted solution]

I'm unaware of any other way to access that data. 😞

[Steve · Accepted solution]

I'm unaware of any other way to access that data. 😞

[dbaum]

Thanks. Logged feature request: Make account User Activity data available to apps - Google Cloud Community .

[Koichi_Tsuji]

I m not sure and not able to follow up what you want, while I believe Appsheet could accomodate what you want.

[dbaum]

Thanks very much for taking the time to interpret my question and try to help. As I wrote my post, I worried I wasn't being sufficiently clear. I tried to explain better in the feature idea I posted. If that's also confusing and you're still interested in understanding, I'll certainly attempt to clarify further. The last thing I want to do is confuse someone whose posts have clarified so many things for me.

See  Make account User Activity data available to apps - Google Cloud Community  

[dbaum · Accepted solution]

FYI, it's indeed possible to access this CSV via API: Reference User's Last Access Timestamp.