Hi,
Do we have an API that returns the "Last Visited" column data of an user? GetUserInfo API does return if a user has registered or not but it doesn't seem to return any more information.
My goal is to know when a user has last visited in QuickBase through API.
Thanks,
Praharsha
Hello Praharsha,
Last time I looked the answer was no or maybe it was too complicated to parse out the data. You have to do a FOR loop for each User for each App and it uses a lot of Integration Reads unless you use Pipelines.
We use the connect tables in the admin console and then put that table into an App where you can access/share the information. Check out the link below.
https://helpv2.quickbase.com/hc/en-us/articles/4570424924052-Connecting-to-Quickbase-Admin-Console
Jim's point is dead on with the suggestion to use the admin console as it will provide the access point of each user and their last visited date. If for some reason you're not able to though - you'll need to leverage the QB API, specifically API_UserRoles and parse out the response. Pipelines can do that pretty easily, there are just some quirks that pop up in the processing if you have users assigned to multiple roles in the same app and how QB returns that JSON data back to you.
Hi Chayce,
Thank you for your response. The API_UserRoles API was all I needed!
Hi Jim,
Thank you for your response.
