Create Table Record with ServiceNow API on New Ticket Created from Lighthouse API

Pipedream makes it easy to connect APIs for ServiceNow, Lighthouse and 3,000+ other apps remarkably fast.

Trigger workflow on

New Ticket Created from the Lighthouse API

Next, do this

Create Table Record with the ServiceNow API

No credit card required

▶

Watch us build a workflow

8 min

Watch now ➜

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

Developers ♥ Pipedream

Getting Started#

This integration creates a workflow with a Lighthouse trigger and ServiceNow action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the New Ticket Created trigger
1. Connect your Lighthouse account
2. Configure timer
3. Select a Project ID
Configure the Create Table Record action
1. Connect your ServiceNow account
2. Select a Table
3. Configure Record Data
4. Optional- Select a Response Data Format
5. Optional- Configure Exclude Reference Links
6. Optional- Configure Response Fields
7. Optional- Configure Input Display Value
8. Optional- Select a Response View
Deploy the workflow
Send a test event to validate your setup
Turn on the trigger

Details#

This integration uses pre-built, source-available components from Pipedream's GitHub repo. These components are developed by Pipedream and the community, and verified and maintained by Pipedream.

To contribute an update to an existing component or create a new component, create a PR on GitHub. If you're new to Pipedream component development, you can start with quickstarts for trigger span and action development, and then review the component API reference.

Trigger#

New Ticket Created on Lighthouse

Description:Emit new event for each new ticket created.

Version:0.0.1

Key:lighthouse-new-ticket-created

View on GitHub

Lighthouse Overview#

The Lighthouse API provides a window into the world of SSL/TLS certificates. It lets you monitor and track certificates issued for specific domains, offering invaluable insights for security and compliance. By leveraging this API within Pipedream, you can automate certificate tracking, set up alerts for new certificates, and integrate this data with other services for a comprehensive view of your domain's security posture.

Trigger Code#

import common from "../common/common.mjs";

export default {
  ...common,
  name: "New Ticket Created",
  version: "0.0.1",
  key: "lighthouse-new-ticket-created",
  description: "Emit new event for each new ticket created.",
  type: "source",
  dedupe: "unique",
  props: {
    ...common.props,
    projectId: {
      propDefinition: [
        common.props.lighthouse,
        "projectId",
      ],
    },
  },
  methods: {
    ...common.methods,
    emitEvent({ ticket }) {
      this.$emit(ticket, {
        id: ticket.number,
        summary: `New ticket created with number ${ticket.number}`,
        ts: Date.parse(ticket.created_at),
      });
    },
    async getResources(args = {}) {
      const { tickets } = await this.lighthouse.getTickets({
        ...args,
        projectId: this.projectId,
      });

      return tickets ?? [];
    },
    resourceKey() {
      return "ticket";
    },
  },
};

Trigger Configuration#

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI and CLI.

Label	Prop	Type	Description
Lighthouse	`lighthouse`	`app`	This component uses the Lighthouse app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
	`timer`	`$.interface.timer`
Project ID	`projectId`	`string`	Select a value from the drop down menu.

Trigger Authentication#

Lighthouse uses API keys for authentication. When you connect your Lighthouse account, Pipedream securely stores the keys so you can easily authenticate to Lighthouse APIs in both code and no-code steps.

Your API Token is located in your Lighthouse Profile at the top right, below the projects area in the sidebar.
Your domain is 12345678 if your Lighthouse URL is https://12345678.lighthouseapp.com/

About Lighthouse#

Lighthouse is a beautifully simple issue tracker changing the way thousands manage their issues.

Action#

Create Table Record on ServiceNow

Description:Inserts one record in the specified table. [See the documentation](https://www.servicenow.com/docs/bundle/zurich-api-reference/page/integrate/inbound-rest/concept/c_TableAPI.html#title_table-POST)

Version:1.0.1

Key:servicenow-create-table-record

View on GitHub

ServiceNow Overview#

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.

Action Code#

import servicenow from "../../servicenow.app.mjs";
import { parseObject } from "../../common/utils.mjs";

export default {
  key: "servicenow-create-table-record",
  name: "Create Table Record",
  description: "Inserts one record in the specified table. [See the documentation](https://www.servicenow.com/docs/bundle/zurich-api-reference/page/integrate/inbound-rest/concept/c_TableAPI.html#title_table-POST)",
  version: "1.0.1",
  annotations: {
    destructiveHint: false,
    openWorldHint: true,
    readOnlyHint: false,
  },
  type: "action",
  props: {
    servicenow,
    table: {
      propDefinition: [
        servicenow,
        "table",
      ],
    },
    recordData: {
      label: "Record Data",
      type: "object",
      description: "The data to create the record with, as key-value pairs (e.g. `{ \"name\": \"John Doe\", \"email\": \"john.doe@example.com\" }`)",
    },
    responseDataFormat: {
      propDefinition: [
        servicenow,
        "responseDataFormat",
      ],
    },
    excludeReferenceLinks: {
      propDefinition: [
        servicenow,
        "excludeReferenceLinks",
      ],
    },
    responseFields: {
      propDefinition: [
        servicenow,
        "responseFields",
      ],
    },
    inputDisplayValue: {
      propDefinition: [
        servicenow,
        "inputDisplayValue",
      ],
    },
    responseView: {
      propDefinition: [
        servicenow,
        "responseView",
      ],
    },
  },
  async run({ $ }) {
    const response = await this.servicenow.createTableRecord({
      $,
      table: this.table,
      data: parseObject(this.recordData),
      params: {
        sysparm_display_value: this.responseDataFormat,
        sysparm_exclude_reference_link: this.excludeReferenceLinks,
        sysparm_fields: this.responseFields?.join?.() || this.responseFields,
        sysparm_input_display_value: this.inputDisplayValue,
        sysparm_view: this.responseView,
      },
    });

    $.export("$summary", `Successfully created record in table "${this.table}"`);

    return response;
  },
};

Action Configuration#

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI.

Label	Prop	Type	Description
ServiceNow	`servicenow`	`app`	This component uses the ServiceNow app.
Table	`table`	`string`	Select a value from the drop down menu.
Record Data	`recordData`	`object`	The data to create the record with, as key-value pairs (e.g. `{ "name": "John Doe", "email": "john.doe@example.com" }`)
Response Data Format	`responseDataFormat`	`string`	Select a value from the drop down menu:`{ "value": "true", "label": "Returns the display values for all fields" }{ "value": "false", "label": "Returns the actual values from the database" }{ "value": "all", "label": "Returns both actual and display values" }`
Exclude Reference Links	`excludeReferenceLinks`	`boolean`	If true, the response excludes Table API links for reference fields
Response Fields	`responseFields`	`string[]`	The fields to return in the response. By default, all fields are returned
Input Display Value	`inputDisplayValue`	`boolean`	If true, the input values are treated as display values (and are manipulated so they can be stored properly in the database)
Response View	`responseView`	`string`	Select a value from the drop down menu:`desktopmobileboth`

Action Authentication#

ServiceNow uses API keys for authentication. When you connect your ServiceNow account, Pipedream securely stores the keys so you can easily authenticate to ServiceNow APIs in both code and no-code steps.

Please follow the steps in this doc to configure a client application on your ServiceNow instance that will allow Pipedream access to your instance's REST API.

Once you're done, enter the client ID and secret you configured in Step 2, along with your instance name. The instance name is the host portion of your instance's URL: that is, the dev123 in https://dev123.service-now.com/.