Integrate the Database API with the ServiceNow API

Setup the Database API trigger to run a workflow which integrates with the ServiceNow API. Pipedream's integration platform allows you to integrate Database and ServiceNow remarkably fast. Free for developers.

Start for free — no credit card required

Watch a demo

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Popular Database and ServiceNow Actions#

Query SQL Database with the Database API

Execute a SQL Query. See our docs to learn more about working with SQL in Pipedream.

Try it

Create Table Record with the ServiceNow API

Inserts one record in the specified table.

Try it

Get Table Record By SysId with the ServiceNow API

Retrieves the record identified by the specified sys_id from the specified table.

Try it

Get Table Records with the ServiceNow API

Retrieves multiple records for the specified table.

Try it

Update Table Record with the ServiceNow API

Updates the specified record with the name-value pairs included in the request body.

Try it

Overview of Database#

The Database API on Pipedream allows users to execute SQL commands directly within workflows, enabling rich and dynamic data manipulation and storage. It supports PostgreSQL, MySQL, and SQLite, making it a versatile option for managing data across various database systems. With this API, users can perform tasks such as data insertion, querying, updates, and deletions, directly within their automations, facilitating real-time data processing and integration across multiple platforms.

Connect Database#

import postgresql from "@pipedream/postgresql";

export default {
  props: {
    postgresql,
    sql: {
      type: "sql",
      auth: {
        app: "postgresql",
      },
      label: "PostreSQL Query",
    },
  },
  async run({ $ }) {
    const args = this.postgresql.executeQueryAdapter(this.sql);
    const data = await this.postgresql.executeQuery(args);
    return data;
  },
};

Overview of ServiceNow#

The ServiceNow API lets developers access and manipulate records, manage workflows, and integrate with other services on its IT service management platform. These capabilities support automating tasks, syncing data across platforms, and boosting operational efficiencies.

Connect ServiceNow#

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    servicenow: {
      type: "app",
      app: "servicenow",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://${this.servicenow.$auth.instance_name}.service-now.com/api/now/table/incident`,
      headers: {
        Authorization: `Bearer ${this.servicenow.$auth.oauth_access_token}`,
      },
    })
  },
})

Start for free — no credit card required

Watch a demo