Can I access the user tables with a HTTP GET?

  • 0
  • 1
  • Question
  • Updated 1 week ago
  • In Progress
I can access the other tables with their dbid for Power BI. Is the user table a special table that I cannot access this way ? 
Photo of matthew herb

matthew herb

  • 80 Points 75 badge 2x thumb

Posted 2 weeks ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 57,428 Points 50k badge 2x thumb
The tab you see called User is not actually a Table.  it's just in the same row of buttons as the Tables.
Photo of matthew herb

matthew herb

  • 80 Points 75 badge 2x thumb
Ok. So its not a table but can we access it?  In my case I need to get the First and Last name and my automation --> SQL process seems to only give me the email. .. I guess qunect is the only way
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 9,680 Points 5k badge 2x thumb
Hi Matthew,

There is a Quick Base API call that does pull up user data from an application. It is API_UserRoles. If you run it against an application it will give you the User ID, name, role, and user data for those users who are invited into the application. This will bring you back a lot of the information that is stored within the user table itself. There is a link to the entry for API_UserRoles include below and I hope this information is helpful. 

https://help.quickbase.com/api-guide/userroles.html