question What is difference b/w Table API and Scripted API ? in Developer forum

What is difference b/w Table API and Scripted API ?

SANJEEV4 — Mon, 06 Mar 2023 15:36:58 GMT

why are we not using use Table API's in Inbound integrations?

Thanks in advance😊

Re: What is difference b/w Table API and Scripted API ?

Sai Shravan — Tue, 07 Mar 2023 09:45:42 GMT

Table API and Scripted API are two different approaches for interacting with ServiceNow data. Here are the main differences between the two:

Table API	Scripted API
Uses pre-defined methods to read, create, update and delete records in ServiceNow tables	Provides more flexibility and control over the data manipulation process
Easier to use and requires less coding	Requires more coding and technical expertise
Provides automatic audit trail and security checks	Does not provide automatic audit trail and security checks
Suitable for most use cases and standard integrations	Suitable for complex integrations, data transformations and custom business logic

Regarding the use of Table API in inbound integrations, it is not recommended to use Table API in inbound integrations due to security reasons. When inbound integrations use Table API, it exposes the instance to the risk of SQL injection attacks. Instead, Scripted REST APIs or custom scripts should be used, which allows for more granular control over the data being accessed and provides more security against such attacks.

In summary, Table API is a simpler and easier to use approach for most integrations, while Scripted API provides more flexibility and control over data manipulation, but requires more coding and technical expertise. It is not recommended to use Table API in inbound integrations due to security risks, and Scripted REST APIs or custom scripts should be used instead.

Regards,

Shravan.

Re: What is difference b/w Table API and Scripted API ?

Ankur Bawiskar — Tue, 07 Mar 2023 09:49:46 GMT

@SANJEEV4

difference is shared by Sai.

Re: What is difference b/w Table API and Scripted API ?

SANJEEV4 — Tue, 07 Mar 2023 12:10:58 GMT

What data base is using ServiceNow backed ?

@Sai Shravan

@Ankur Bawiskar

Re: What is difference b/w Table API and Scripted API ?

Sai Shravan — Wed, 08 Mar 2023 10:28:06 GMT

Hi @SANJEEV4 ,

The MySQL database is used underneath. The ServiceNow software uses the MariaDB Java driver.
More information can be found in the stats.do page and click "Open Source Software".

That PDF has lots of cool information about what's going on "under the covers".

Regards,

Shravan

Re: What is difference b/w Table API and Scripted API ?

Rajesh kumar931 — Mon, 22 Apr 2024 11:32:02 GMT

MariaDB