Update Row with AppDrag API on New Download Counts from npm API

Pipedream makes it easy to connect APIs for AppDrag, npm and 2,900+ other apps remarkably fast.

Trigger workflow on

New Download Counts from the npm API

Next, do this

Update Row with the AppDrag 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 npm trigger and AppDrag action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the New Download Counts trigger
1. Connect your npm account
2. Configure timer
3. Select a Period
4. Optional- Configure Package
Configure the Update Row action
1. Connect your AppDrag account
2. Select a Table Name
3. Select one or more Columns
4. Configure Values
5. Configure Where Condition
6. Configure Where Values
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 Download Counts on npm

Description:Emit new event with the latest count of downloads for an npm package. [See the documentation](https://github.com/npm/registry/blob/main/docs/download-counts.md).

Version:0.1.0

Key:npm-download-counts

View on GitHub

Trigger Code#

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

export default {
  key: "npm-download-counts",
  name: "New Download Counts",
  description: "Emit new event with the latest count of downloads for an npm package. [See the documentation](https://github.com/npm/registry/blob/main/docs/download-counts.md).",
  version: "0.1.0",
  type: "source",
  props: {
    app,
    db: "$.service.db",
    timer: {
      type: "$.interface.timer",
      description: "One day interval time is recommended because NPM only update metrics once a day. [See the documentation](https://github.com/npm/registry/blob/main/docs/download-counts.md#data-source).",
      default: {
        intervalSeconds: 60 * 60 * 24,
      },
    },
    period: {
      type: "string",
      label: "Period",
      description: "Select last-day, last-week or last-month.",
      optional: false,
      default: "last-day",
      options: [
        "last-day",
        "last-week",
        "last-month",
      ],
    },
    packageName: {
      type: "string",
      label: "Package",
      description: "Enter an npm package name. Leave blank for all",
      optional: true,
    },
  },
  methods: {
    getDownloadCounts({
      period, packageName, ...args
    } = {}) {
      const basePath = `/downloads/point/${encodeURIComponent(period)}`;
      return this.app.makeRequest({
        path: packageName
          ? `${basePath}/${encodeURIComponent(packageName)}`
          : basePath,
        ...args,
      });
    },
  },
  async run({ timestamp: ts }) {
    const {
      getDownloadCounts,
      period,
      packageName,
    } = this;

    const response = await getDownloadCounts({
      period,
      packageName,
    });

    this.$emit(response, {
      id: ts,
      summary: `New Download Count ${response.downloads}`,
      ts,
    });
  },
};

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
npm	`app`	`app`	This component uses the npm app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
	`timer`	`$.interface.timer`	One day interval time is recommended because NPM only update metrics once a day. See the documentation
Period	`period`	`string`	Select a value from the drop down menu:`last-daylast-weeklast-month`
Package	`packageName`	`string`	Enter an npm package name. Leave blank for all

Trigger Authentication#

The npm API does not require authentication.

About npm#

Node package manager

Action#

Update Row on AppDrag

Description:Updates a row in a cloud database table. [See the documentation](https://support.appdrag.com/doc/Appdrag-Cloudbackend-npm)

Version:0.0.2

Key:appdrag-update-row

View on GitHub

AppDrag Overview#

The AppDrag API lets you manage cloud functions, databases, and mail sending features within your AppDrag projects. With Pipedream, you can harness these capabilities to automate workflows such as syncing data between different platforms, processing form submissions, or triggering communication sequences. By connecting AppDrag’s API to Pipedream, you gain the ability to create serverless workflows that can respond to various triggers like webhooks, schedules, or even actions from other apps.

Action Code#

import app from "../../appdrag.app.mjs";
import utils from "../../common/utils.mjs";

export default {
  key: "appdrag-update-row",
  name: "Update Row",
  description: "Updates a row in a cloud database table. [See the documentation](https://support.appdrag.com/doc/Appdrag-Cloudbackend-npm)",
  version: "0.0.2",
  annotations: {
    destructiveHint: true,
    openWorldHint: true,
    readOnlyHint: false,
  },
  type: "action",
  props: {
    app,
    table: {
      propDefinition: [
        app,
        "table",
      ],
    },
    columnsToUpdate: {
      description: "The name of the columns to update in the table. Eg. `[\"column1\", \"column2\"]`",
      propDefinition: [
        app,
        "columns",
        ({ table }) => ({
          table,
        }),
      ],
    },
    values: {
      type: "string[]",
      label: "Values",
      description: "The values to update in the table for each **Column**. Eg. `[\"value1\", \"value2\"]`",
    },
    whereCondition: {
      type: "string",
      label: "Where Condition",
      description: "In this expression you can write your own conditions (eg. `column1 = ? or column2 = ?`). Depending on the number of `?` symbols likewise you need to add the same number of **Where Values**.",
    },
    whereValues: {
      type: "string[]",
      label: "Where Values",
      description: "This is the list of **values** that will match every `?` symbol in the **Where Condition** expression. Eg. `[\"value1\", \"value2\"]`",
    },
  },
  methods: {
    updateRow({
      table, columnsToUpdate, values, whereCondition, whereValues, ...args
    } = {}) {
      return this.app.executeRawQuery({
        query: `
          UPDATE ${table}
            SET ${utils.parseArray(columnsToUpdate).map((column) => `${column} = ?`)}
            WHERE ${whereCondition}
        `,
        values: [
          ...utils.parseArray(values),
          ...utils.parseArray(whereValues),
        ],
        ...args,
      });
    },
  },
  async run({ $: step }) {
    const {
      updateRow,
      table,
      columnsToUpdate,
      values,
      whereCondition,
      whereValues,
    } = this;

    const response = await updateRow({
      step,
      table,
      columnsToUpdate,
      values,
      whereCondition,
      whereValues,
    });

    step.export("$summary", `Successfully updated row in table \`${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
AppDrag	`app`	`app`	This component uses the AppDrag app.
Table Name	`table`	`string`	Select a value from the drop down menu.
Columns	`columnsToUpdate`	`string[]`	Select a value from the drop down menu.
Values	`values`	`string[]`	The values to update in the table for each Column. Eg. `["value1", "value2"]`
Where Condition	`whereCondition`	`string`	In this expression you can write your own conditions (eg. `column1 = ? or column2 = ?`). Depending on the number of `?` symbols likewise you need to add the same number of Where Values.
Where Values	`whereValues`	`string[]`	This is the list of values that will match every `?` symbol in the Where Condition expression. Eg. `["value1", "value2"]`

Action Authentication#

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