The CreatorCon Call for Content is officially open! Get started here.

Sync All created users from the past week to lower instance

Cent
Tera Contributor

Hi, 

I have a requirement where i need to sync newly created users together with their roles/groups from the past week (7 days) to lower instance, As of now i am thinking of a scheduled flow using ebonding to achieve the requirement so that it can be automated. Manual export and import of file is out of the picture.

Does anybody done the same thing or anybody has an experience on this? Your feedback will be a great of help

4 REPLIES 4

TejasSN_LogicX
Tera Contributor

Hi @Cent ,,, this  can be achieved efficiently using a scheduled Flow Designer integration with eBonding, and it’s one of the best automated approaches. You can create a scheduled flow that runs once a week to find all users created in the past seven days using a filter on the sys_user table (sys_created_on >= Today - 7 days). For each new user, the flow can look up their assigned roles (from the sys_user_has_role table) and group memberships (from the sys_user_grmember table). Once the related data is gathered, you can format it into a JSON payload containing the user’s details, roles, and groups, and then send this data to the lower instance through a REST step using your existing eBonding integration. On the lower instance, an inbound REST API or Flow can receive the data and either create or update the user along with their associated roles and groups.

This approach removes the need for any manual export or import process and ensures that user data stays in sync across instances automatically.

Thanks for your reply @TejasSN_LogicX , let me try it and see if it works. thanks!

Ankur Bawiskar
Tera Patron
Tera Patron

@Cent 

but why you require this?

Is this a business requirement to bring PROD users to SUB-PROD or DEV etc?

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Yes, i mentioned explicitly that this is a requirement.