Import data into M2M table

ipsa · ‎07-04-2023

Can anyone guide me the end to end process of importing data to an M2M table in servicenow?

Anil Lande · ‎07-04-2023

M2M table referes to two tables for which the M2M relationship is configured. If you are importing data using Import Sets then you have to get sys_id of both columns from both tables and set the field values.

Use script to get sys_id of required record if your excel does not contain sys_id.

Also there are many other ways to map data, it depends on your data and tables involved.

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande

View solution in original post

Anil Lande · ‎07-04-2023

Hi,

Can you please explain what is your use case and what you have tried? Where exactly you need help?

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande

Anil Lande · ‎07-04-2023

M2M table referes to two tables for which the M2M relationship is configured. If you are importing data using Import Sets then you have to get sys_id of both columns from both tables and set the field values.

Use script to get sys_id of required record if your excel does not contain sys_id.

Also there are many other ways to map data, it depends on your data and tables involved.

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande