Get Related UUIDs with Confection API on New Database from Notion API

Pipedream makes it easy to connect APIs for Confection, Notion and 2,400+ other apps remarkably fast.

Trigger workflow on

New Database from the Notion API

Next, do this

Get Related UUIDs with the Confection 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 Notion trigger and Confection action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the New Database trigger
1. Connect your Notion account
2. Configure timer
Configure the Get Related UUIDs action
1. Connect your Confection account
2. Configure UUID
3. Optional- Configure Likeness Score
4. Optional- Configure Should the execution of this step be stopped if no results are found?
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 Database on Notion

Description:Emit new event when a database is created. Note: Databases must be shared with your Pipedream Integtration to trigger event.

Version:0.0.8

Key:notion-new-database

View on GitHub

Notion Overview#

Notion's API allows for the creation, reading, updating, and deleting of pages, databases, and their contents within Notion. Using Pipedream's platform, you can build workflows that connect Notion with various other services to automate tasks such as content management, task tracking, and data synchronization. With Pipedream's serverless execution, you can trigger these workflows on a schedule, or by external events from other services, without managing any infrastructure.

Trigger Code#

import base from "../common/base.mjs";
import sampleEmit from "./test-event.mjs";
import constants from "../common/constants.mjs";

export default {
  ...base,
  key: "notion-new-database",
  name: "New Database",
  description: "Emit new event when a database is created. Note: Databases must be shared with your Pipedream Integtration to trigger event.",
  version: "0.0.8",
  type: "source",
  async run() {
    const databases = [];
    const params = this.lastCreatedSortParam();
    const lastCreatedTimestamp = this.getLastCreatedTimestamp();

    do {
      const response = await this.notion.listDatabases(params);

      for (const database of response.results) {
        if (!this.isResultNew(database.created_time, lastCreatedTimestamp)) {
          params.start_cursor = null;
          break;
        }
        databases.push(database);
      }

      params.start_cursor = response.next_cursor;
    } while (params.start_cursor);

    databases.reverse().forEach((database) => {
      const meta = this.generateMeta(
        database,
        constants.types.DATABASE,
        constants.timestamps.CREATED_TIME,
        constants.summaries.DATABASE_ADDED,
      );
      this.$emit(database, meta);
    });

    const lastCreatedTime = databases[databases.length - 1]?.created_time;
    if (lastCreatedTime) {
      this.setLastCreatedTimestamp(Date.parse(lastCreatedTime));
    }
  },
  sampleEmit,
};

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
Notion	`notion`	`app`	This component uses the Notion app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
	`timer`	`$.interface.timer`

Trigger Authentication#

Notion uses OAuth authentication. When you connect your Notion account, Pipedream will open a popup window where you can sign into Notion and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any Notion API.

Pipedream requests the following authorization scopes when you connect your account:

About Notion#

Notion is a new tool that blends your everyday work apps into one. It's the all-in-one workspace for you and your team.

Action#

Get Related UUIDs on Confection

Description:This action will retrieve all UUIDs that have a likeness score of at least 50 (default) with the provided UUID. The likeness score can be customized in configuration.

Version:0.1.0

Key:confection-get-related-uuids

View on GitHub

Confection Overview#

Confection API provides a robust solution for collecting, managing, and utilizing user data in compliance with privacy regulations. It helps businesses capture data lost due to ad blockers and privacy tech, ensuring you don't miss out on valuable insights. With Pipedream, you can harness this data in real-time, triggering actions, analyzing trends, or integrating with other services for a comprehensive data strategy.

Action Code#

import confection from "../../confection.app.mjs";

export default {
  key: "confection-get-related-uuids",
  name: "Get Related UUIDs",
  type: "action",
  version: "0.1.0",
  description:
    "This action will retrieve all UUIDs that have a likeness score of at least 50 (default) with the provided UUID. The likeness score can be customized in configuration.",
  props: {
    confection,
    uuid: {
      propDefinition: [
        confection,
        "uuid",
      ],
      description: "Provide the UUID to retrieve related UUIDs of.",
    },
    likeness: {
      propDefinition: [
        confection,
        "likeness",
      ],
      description:
        "Accepts values 50 to 100. 100 meaning only pull back records where we are certain the UUIDs are the same record",
    },
    stopOnNoResults: {
      propDefinition: [
        confection,
        "stopOnNoResults",
      ],
      description:
        "If set to true, action execution will be halted when no related UUIDs are found and any subsequent steps that rely on data from this step will not be run.",
    },
  },
  async run({ $ }) {
    const data = await this.confection.getRelatedUUIDs(
      this.uuid,
      this.likeness,
      $,
    );

    if (data.related.length === 0 && this.stopOnNoResults === true) {
      throw new Error(
        `No related UUIDs with likeness score greater than or equal to ${this.likeness} were found.`,
      );
    }
    return data;
  },
};

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
Confection	`confection`	`app`	This component uses the Confection app.
UUID	`uuid`	`string`	Provide the UUID to retrieve related UUIDs of.
Likeness Score	`likeness`	`integer`	Accepts values 50 to 100. 100 meaning only pull back records where we are certain the UUIDs are the same record
Should the execution of this step be stopped if no results are found?	`stopOnNoResults`	`boolean`	If set to true, action execution will be halted when no related UUIDs are found and any subsequent steps that rely on data from this step will not be run.

Action Authentication#

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

Find your account ID and API keys here: https://dashboard.confection.io/my-keys

Need an account? Using Confection for the first time? Please see our quick-start guide: https://confection.io/quick-start/pipedream

About Confection#

Confection collects, stores, and distributes data in a way that's unaffected by client-side disruptions involving cookies, cross-domain scripts, and device IDs. It's also compliant with global privacy laws so it’s good for people too.

More Ways to Connect Confection + Notion#

Other Popular Integrations#

Get Full Details of UUID with Confection API on New Database from Notion API

Notion + Confection

Get Related UUIDs with Confection API on New Database from Notion API

Pipedream makes it easy to connect APIs for Confection, Notion and 2,400+ other apps remarkably fast.

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

Developers ♥ Pipedream

1-24of2,400+apps by most popular

1
-
24
of
2,400+
apps by most popular