User List not matching from API and User type report
We wanted to report a discrepancy we had observed in the list of users we are obtaining from the Smartsheet List users API and the User type report generated in Smartsheet. We observed that a lot of users that were being coming in the API response were not in the User type report and also Vice Versa. We are using OAuth authentication to generate a token authorized by the Admin user and we are seeing a large number of users not showing in the API response. We require some help or guidance over how to handle this data discrepancy and why the API is not reporting all the users from the generated report. Any sort of guidance will be greatly appreciated.
Answers
-
Hi @ce_integrations, I found a comment in this thread, where Srinivasan (Employee) mentions that the User Type Report only includes active users. This could help explain why the API returns users that aren't being shown in the User Type Report.
However, you also mentioned that the User Type Report is showing some users that the API is not?
The "List Users" API mentions this:
Gets a list of users in the organization account. To filter by email, use the optional email query string parameter to specify a list of users' email addresses.
Which makes me think that it excludes users that are not directly on the organization account (external users). I haven't personally confirmed this using the API, but you might want to compare the results between the API response and the User Type Report.
Does the User Type Report include external users, whereas the API excludes external users? Does the API include "DEACTIVATED" users, whereas the User Type Report does not.
I hope this helps!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com) (LinkedIn)
SSFeatures makes Smartsheet way easier to use and it saves you hours of work every week. It adds essential features into Smartsheet to save you time. For example: β Auto Sorting β Sorting with Filters β Report PDF Generation β Copy and Paste Conditional Formats β Copy and Paste Automation Workflows β Column Manager β and so many more.
-
Thank you for the response.
We compared both the API response and the User Type Report. We found that the Users coming from the API response are being shown in the User Type report. But many users coming in the User Type Report are not being shown in API response. There are multiple types of users in the User Type report (Admin, Viewer, Provisioned Member) that we did not find in the API response that is leading to one of our clients question what is the logic behind API not fetching these users
