integration through flow designer

[shivanitana]

get the user department,location,manager deatils from one servicenow instance and store is in annother servicenow instance

[Rabah2]

Hi Shiva,

Not sure if I understand your question clearly, you might be able to achieve this through Remote instance spoke, you can create a connection and child connection for each remote instance and update sys_user fields like department, location, manager.

[Tanushree Maiti]

Hi @shivanitana 

(High level architecture)

Option1: Using Flow Rest PI

Step 1: Create a Credential and Connection

Before building the flow, establish a secure connection to your Target instance.

• In the Source instance, navigate to Connections & Credentials > Credentials.
• Click New and select Basic Auth Credentials.
• Provide the username and password of a system integration user in the Target instance.
• Navigate to Connections & Credentials > Connection and create a new HTTP Connection pointing to your Target instance (e.g., https://<your_target_instance>.service-now.com).

Step 2: Build a Custom Flow Action

• Open Flow Designer on the Source instance, click New, and select Action.
• Define the Action Inputs:
• User_Sys_ID (String) - The unique identifier of the user to search.
• Add a REST Step:
• Connection: Define Connection Inline. Select the HTTP connection created in Step 1.
• Resource Path: /api/now/table/sys_user/{User_Sys_ID}
• HTTP Method: GET
• Headers: Accept : application/json
• Parse the Response: Add a JSON Parser or directly map the response output fields (department, location, manager) to the Action Outputs.
• Define the Action Outputs: Department, Location, Manager.
• Click Save and Publish the Action

Step 3: Create the Flow

• In Flow Designer, create a new Flow.
• Define your Trigger (e.g., when a user record is created, or a catalog item is requested).
• Add an Action:
• Select your Custom Action created in Step 2.
• Drag and drop the User_Sys_ID Data Pill into the action input.
• Add a second action: Update Record.
• Set the Record to the Target record on the Source instance.
• Update the Department, Location, and Manager fields using the Data Pills outputted by the REST action.
• Click Activate

Option2 : Using the ServiceNow Remote Instance Spoke:

[ashleyharve]

The REST step approach via Flow Designer is solid, but personally I'd go straight for the Remote Instance Spoke if both instances are on the same version — way less custom code to maintain. Just make sure your integration user on the target instance has the right roles, otherwise department and manager fields come back empty and debugging that is a real headache.