Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Adding Members to External Business Location through Transform Map

Go to solution
Ashuthosh_s_p
Tera Contributor

‎07-08-2024 04:02 AM

I have some set of data which I have in External Business location table. Now when I register a member, A user is created in sys_user table also a record in service organization external staff. Now instead of registering, how can I add the data through import sets and transform map so that the value is mapped in the external Business location and service organization external staff.

Labels:
0 Helpfuls
  • 1,444 Views
1 ACCEPTED SOLUTION

Go to solution
Sharath Chandra
ServiceNow Employee
ServiceNow Employee

‎10-28-2024 01:36 AM

If you are trying to associate Users to an External business location. 

 

It is a 3-step process i.e., you need to import data into 3 tables:

  1. First create the user --> Service Organization external staff (sn_csm_service_organization_external_staff)
  2. Make them a member of the business locaiton --> Service organization member (sn_csm_service_organization_member)
  3. Assign the right responsibility --> Service Organization Member Responsibility (sn_csm_svc_org_member_responsibility)

Regards,

Sharath

 

View solution in original post

5 REPLIES 5

Go to solution
Sharath Chandra
ServiceNow Employee
ServiceNow Employee
In response to dman2969

‎06-05-2025 10:18 PM

Glad it was helpful! Created the article from this thread. 🙂 Thank you for asking.