How to map data in related list via integration hub

[Mayur Patil2]

Hello Developers,

I am trying to import excel sheet data in ServiceNow via Integration hub. Below is screenshot of excel sheet. I am trying to import data in Groups table.

Source Table - Servicenow Field

Group Name  - Name 

description - description

Members - Related list (members)

Here I am not able to add member mention in related list of Groups table.

Thank you

Mayur

[Mark Manders]

How did you set this up? The 'members' aren't part of the sys_user_group table, but need to be added into the sys_user_grmember table.

[pverni]

I'm with the same problem. I'm trying to import an excel that contains the risk ID and another with the control ID. 

Both, risks and controls, are already create, but now I need to create a relationship between then. How can I do this in bulk?

[Mark Manders]

It's always better to create your own question instead of replying to an almost year old question that only has one reply, containing questions to get better understanding of what's going on.
You need to find the way these tables are usually related to each other and connect them there. If it's a direct relationship (like parent/child) you need to add the parent value on the child record (like with incident/incident task: add the incident record on the incident task record).
If it's a relationship through a m2m table, you need to create those records (like with groups/users). The m2m table exists of a 'user' field and a 'group' field and both records are referenced on the m2m record.

[pverni]

Thanks for your help Mark.

I was able to find the correct table, in my case was sn_risk_m2m_risk_definition_policy_statement.