Use Column names instead of Labels in tranformation mapping when inserting multiple rows

kgummuluri
Tera Contributor

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.

5 REPLIES 5

AJ-TechTrek
Giga Sage
Giga Sage

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

sushantmalsure
Mega Sage
Mega Sage

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. 

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Regards,Sushant Malsure

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.

kgummuluri
Tera Contributor

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.