Flow through integration

[shivanitana]

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

[Dr Atul G- LNG]

Hi @shivanitana 

It’s easy to do since both are ServiceNow instances. You just need table mapping, which can be done easily using an API or a Flow.

https://www.servicenow.com/community/itsm-forum/integration-with-flow-designer/td-p/2986187

[Ankur Bawiskar]

@shivanitana 

what's the business requirement here?

Why are you transferring the data of User such as Department, Location, Manager to other instance?

Users are usually brought in via LDAP AD or via Microsoft AD

Are you doing this for your POC?

[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: