API & Developers
API & Developers
Connect with other developers from around the world and collaborate on ideas using the Smartsheet API.
What cause a user/project id to change?
Hello,
My team is using Smartsheet's data of my organization to one of our application. We reuse UserID and ProjectID from Smartsheet and store them as primary key in our database. However, occasionally, I saw the ID of a same user or project is changed when pulling data from Smartsheet. May I ask what might cause this to happen?
Thanks.
Answers
-
I think that I have seen UserID's get changed in the process of merging user accounts. We have to do this more than I like because of the way we update accounts in Active Directory tied to email addresses. When people change their names, their email address gets changed. When they login to Smartsheet with our AD integration, they often end up with a new Smartsheet account which I then have to merge with their original Smartsheet account.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.3K Get Help
- 462 Global Discussions
- 156 Industry Talk
- 508 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 517 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Trending in API & Developers
- I am running into an error when connecting Smartsheet to Power BI (Power Query). I am trying to refresh my PBIX file, but I run into the following error when trying to connect my Smartsheets: The issu…
- Hello all, I am relatively familiar with Smartsheet and VBA. From my understanding I will need to API access to achieve this, but am I able to write a VBA script that pulls my excel file into a Smarts…
- Hello everyone, I have a function that I run via API that helps me replicate improvements across all the spreadsheets for projects I work on. I tried to insert a new formula field into my spreadsheet …