Hi there,
We are exporting some data out of Tulip tables via API, and found that the user field appears as the user’s ID in the record. We’d really like to access the name associated with the user, and some possible ways are:
Get records from the ssers table (doesn’t seem possible with the current API, as the users table doesn’t show up in the list of tables)
Query against a Users api using the id (like a GetUserById)
GetRecords API returns user using the name (probably bad for backwards compatibility)
For now, we can workaround by downloading the Users table CSV, but would love to have this available via API. Thanks!
Hi Fifi, I am the product manager for our governance features. Happy to help with this. What release are you on? We recently released an improvement where you can export the user and userID data in one export, and I wanted to see if it is already available on your instance.
I think Fifis intention is to access the user name via tulip table API and not the user ID when the column is of type user. Currently the API returns the user ID as a string which is not helpfull.
Agreed, Oliver. I think the long-term approach we will take here is to create a proper Users API (beyond the current Operators API). I dont have a delivery date yet, but a Users API would help in multiple places, and we are currently planning this out.
Hello Fifi and others- I am doing research in this area with the intention of launching a Users API in the next few months. Would you be interested in speaking to me to tell me a little more about your needs?
Hi Kevin. I am developing a Tulip app for one of our customers. I am new to Tulip development, but I stumble into the post, because currently our customer needed some API calls to Tulip tables and an excel integration as part of the full development we are doing for them. We ran into the same issue with the user name retrieval vs the user ID. I was able to somehow get around this via downloading the user csv (as mentioned above) and doing some query merging, replacement, etc. However, this process seems a little to overwhelming to present to my customer. We are using, with this solution as the only option available for the moment, but with all the recent tulip updates I have seen over the past week weeks and months. Hopefully, there is a little more of information in this User API. Would love to get notify or at least get some insight in how this is going, so i could brief and plan future upgrades once this is release. Thanks and have a wonderful week.
Hi all! As part of the launch for Ops Calling 2024, we did indeed launch a Users API with GET and LIST endpoints. It comes with r289 and later. For an example of the docs, see our API docs here: /api/users/v1/users - users
If you enjoy this, or have other endpoints you are looking for, let us know in the comments here!