Use Column names instead of Labels in tranformation mapping when inserting multiple rows
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-01-2024 10:20 AM
You can modify mapping settings by adding an entry in the Rest Insert Multiples [sys_rest_insert_multiple] table and changing the Column mapping from Label to Column name. What entry should I add in sys_rest_insert_multiple table? Need some details of the record that I need to add.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-02-2024 04:08 AM
Hi @kgummuluri ,
I am not getting your question completely, Can you please elaborate more on this.
Also if related to transform map, Please refer below.
https://www.servicenow.com/community/developer-blog/transform-map-best-practices/ba-p/2276233
Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.
Thanks
AJ
Linkedin Profile:- https://www.linkedin.com/in/ajay-kumar-66a91385/
ServiceNow Community Rising Star 2024
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-02-2024 04:24 AM
I believe you just need to create column mapping entry (change label to column name) UNDER CORRECT REST INSERT MULTIPLES table. You just need to make sure of selecting correct Source table (staging table) from Rest Insert Multiple table and under which from Column mapping define your new transformation setting.
Regards,Sushant Malsure
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-04-2024 11:01 AM
Import Set API | ServiceNow Developers If you look at this you will see the section from which my question arises. I am new to ServiceNow. I am trying to insert multiple rows into cmdb_ci_printer table using a web service called my_test_printer. I am building an application using the servicenow rest api.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-04-2024 10:56 AM
I am new to ServiceNow integration - I still don't understand what you are saying. I am inserting multiple rows into cmdb_ci_printer table using a web service called my_test1_printer.
Refer to this Import Set API | ServiceNow Developers.
In there there is a section that relates to my question. I am not sure what entry to make in that table to use names instead of labels.