What is the difference in inserting/updating a record through REST API using staging table and direct table

nehasr1288
Tera Expert

I created rest services that used to insert or update a record using an inbound service (where I created a staging table for incident) and directly the incident table.

using both ways the operation worked.So what is the difference. Using inbound service is more safe or appropriate ??

1 ACCEPTED SOLUTION

Chuck Tomasi
Tera Patron

Using a staging table allows you to do transformations on the data (mapping and manipulation.) It's much the same as import sets, in fact, the staging tables are referred to as the import set API in REST. This is very powerful stuff. It is safer than inserting/updating directly in the table. If you have the option to use the import set REST API, use it for your data.



Getting Started with REST - ServiceNow Wiki


REST API Explorer - ServiceNow Wiki


REST API  


View solution in original post

1 REPLY 1

Chuck Tomasi
Tera Patron

Using a staging table allows you to do transformations on the data (mapping and manipulation.) It's much the same as import sets, in fact, the staging tables are referred to as the import set API in REST. This is very powerful stuff. It is safer than inserting/updating directly in the table. If you have the option to use the import set REST API, use it for your data.



Getting Started with REST - ServiceNow Wiki


REST API Explorer - ServiceNow Wiki


REST API