Forum Discussion

matthewherb's avatar
matthewherb
Qrew Member
6 years ago

Can I access the user tables with a HTTP GET?

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 ? 

3 Replies

  • The tab you see called User is not actually a Table.  it's just in the same row of buttons as the Tables.
    • matthewherb's avatar
      matthewherb
      Qrew Member
      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
    • EvanMartinez's avatar
      EvanMartinez
      Qrew Elite
      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