The built-in user management has some great features, but there doesn’t appear to be any way to export user accounts. To communicate with registered users, we have been selecting a record and copying the email address row by row. We now have hundreds of users and hope to have 000’s. These user accounts represent valuable business data that we need to work with in other systems. How can we export information about our users. We don’t need to violate security in any way – don’t need login credentials – just names, email address and some other user info. The user management has some fairly deep features, so I can't imagine that exporting users is missing.. am I missing something obvious?
5 Answers, 1 is accepted
You can easily fetch the user accounts data in JSON format by making a GET request to the Users system type with any tool or framework of your preference. You can refer to the REST API about more details of the request or choose any of the client SDKs to do so. You may need to use the Master Key of your app (do not disclose it to third parties) so that you can read all user accounts in your app and all their properties ( of course, without sensitive data). Let us know if you need further assistance with this.
While we are on the subject - it is interesting to share your use case on this and how you plan to utilize these accounts, perhaps the data you need should be obtainable from Telerik Platform in the future. Also, we have a similar feature request here - can you please share if this is your case or you have further considerations?
Let me know if you would like to share details on your use case in a private channel and not in the public forums.
Regards,
Anton Dobrev
Telerik by Progress
Rank 1
Hi Anton,
We use the platform because it is a very efficient tool-set for building, releasing and managing hybrid mobile apps. There is a simple, yet effective "Export" button for every data type except Users!?
I think you're suggesting that there is no way to backup or export user account data from the platform without building a separate app and making API calls? Keep in mind that our license does not permit building windows or web apps, so we would have to build an app outside of the Telerik platform using a different toolset just to get access to our customer data.
Thanks for your reply, Randy.
I appreciate your feedback, definitely, it is a good idea to have a meaningful way to export the user accounts and other data. Your comment is taken under consideration and will be further communicated to the team. At the current stage what you would like to achieve, however, is only available through using programmatically the web services API.
Actually, there is a simple way to do this with a simple request made with an HTTP tool like Postman, Paw, Fiddler and fetch the user account data with a GET request to the /Users endpoint. Then save the JSON data in a suitable format for further use. I am also attaching a screenshot of the way to do this illustrated in Postman.
This said building a different tooling to do so is not needed while it may be convenient if you would like to continuously sync data programmatically between the source and the tool that makes further processing.
Continuing on this, your point and comments are noted. We will appreciate if you are comfortable with providing more details about your use case as asked in my previous email so that we can think for the best way for integration with such external systems or eventually a way to do this in Telerik Platform.
Let me know if this works for you.
Regards,
Anton Dobrev
Telerik by Progress
Rank 1
Thanks Anton, this is very helpful.
I was able to get the data we need from Postman as you suggested. This will suffice for our immediate needs, although an export button like the one for all the other data types seem's like a logical feature to add.
Re. our use case...
"Users" in the database are our customers. So, like any business, we need to track, understand and communicate with them. The user area of the browser interface is focused mainly on access control, thus our need to periodically extract the raw data. At greater scale, a real-time approach may be needed.
Thanks for writing back. Indeed, my point was also that a real-time or programmatic integration seems to be more adequate than having an export button that exports the user data manually and then importing it manually.
This said, I was wondering if you have some particular integration in mind or ideas for additional features in Telerik Platform. Let me know if you would like to share such information in private.
Please do not hesitate to submit any feedback or feature request here or in our user voice portal.
Regards,
Anton Dobrev
Telerik by Progress