Adding Members to External Business Location through Transform Map

Ashuthosh_s_p
Tera Contributor

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.

1 ACCEPTED SOLUTION

Sharath Chandra
ServiceNow Employee
ServiceNow Employee

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

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