Export users - Add the unique user ID to the export

Also voting on this and adding our use case. 

Because the Salesforce integration only creates Community Members if there is an existing Contact in Salesforce, our Salesforce reporting will essentially be incomplete if not all Community Members and Activity are in Salesforce. 

As such, we decided to do a weekly export of users from inSided, and use that to create the Contacts in Salesforce and thus their Community Members as well. Part of what is needed to create the Community Members is the UserId. When I went to do the User export from Control today, though, I noticed that UserId is missing. This would be very helpful to add as a column in the report. 

FWIW, I just added two support tickets that could have been solved self-service via the API if I had UserId was in the user export. 

This seems like it would be an easy quick-win. 

Just seeing this use case. My tech team figured out a solve for creating contacts for those that weren’t already in Salesforce. I believe it happens right away so that the records start syncing from the beginning. If your team wants to talk to mine, send me a message and we can get it scheduled. 

Thanks for documenting for all Cmgrs @Folkert Ziggo 

Getting just the username is still pretty unusable if we wo not have the add on userID:

anirbandutta is no good unless I get the full /anirbandutta-1549 so absolutely need that.

Also in general an overall... 

FWIW, almost had to open a support ticket for something related to this again. 

We solved thanks to having our SFDC integration with user ID, but it’s adding quite a bit of hassle. 

With some much self-service capabilities taht can be done with the API and the API requiring user_id for a lot of things, I’m hoping this gets added soon along with my latest idea and total points: 
 

Bumping this idea again. 

I encountered another use case where I would be able to solve something on my own via the API, but cannot because the user export doesn’t provide userId (required by the API). 

Hi, I am bumping this again. 

I need the User ID to run all my User-related Zaps (e.g. assign custom role in bulk via a google sheet) but I can’t do it unless I have the User IDs. (I use a complicated workaround to get the User ID via VLOOKUP and a  Gainsight list, but I have to do that manually every single time)

Sorry but can you tell more about this, how this can be done?

Sure thing! 

First of all, I create a list of all User IDs that need to be granted a certain role.

I generate this list using several steps and VLookup, but it would be awsome if I could just find out the User ID through the user export

Then I create the following Zap:

When I press “play” on the zap, it assigns all the user IDs in bulk. Worked with 1000s of users in a few minutes :)