Create Album with SmugMug API on New or Updated Row from PostgreSQL API

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

Trigger workflow on

New or Updated Row from the PostgreSQL API

Next, do this

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

Select this integration
Configure the New or Updated Row trigger
1. Connect your PostgreSQL account
2. Configure Polling Interval
3. Select a Schema
4. Select a Table
5. Select a Identifier Column
6. Select a Timestamp Column
Configure the Create Album action
1. Connect your SmugMug account
2. Select a Folder
3. Configure Title
4. Configure Nice Name
5. Optional- Configure URL Name
6. Optional- Select a Privacy
7. Optional- Configure Printmark URI
8. Optional- Configure Watermark URI
9. Optional- Configure Theme URI
10. Optional- Configure Template URI
11. Optional- Configure Allow Downloads
12. Optional- Configure Backprinting
13. Optional- Select a Boutique Packaging
14. Optional- Configure Can Rank
15. Optional- Configure Clean
16. Optional- Configure Comments
17. Optional- Configure Description
18. Optional- Configure Download Password
19. Optional- Configure EXIF
20. Optional- Configure Family Edit
21. Optional- Configure Filenames
22. Optional- Configure Friend Edit
23. Optional- Configure Geography
24. Optional- Select a Header
25. Optional- Configure Hide Owner
26. Optional- Configure Intercept Shipping
27. Optional- Configure Keywords
28. Optional- Configure Largest Size
29. Optional- Configure Packaging Branding
30. Optional- Configure Password
31. Optional- Configure Password Hint
32. Optional- Configure Printable
33. Optional- Configure Proof Days
34. Optional- Configure Protected
35. Optional- Configure Share
36. Optional- Configure Slideshow
37. Optional- Select a Sort Direction
38. Optional- Select a Sort Method
39. Optional- Configure Square Thumbs
40. Optional- Configure Upload Key
41. Optional- Configure Watermark
42. Optional- Select a World Searchable
43. Optional- Configure Auto Rename
44. Optional- Configure SecurityType
45. Optional- Configure Highlight Album Image URI
46. Optional- Configure Album Template URI
47. Optional- Select a Smug Searchable
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 or Updated Row on PostgreSQL

Description:Emit new event when a row is added or modified. [See the documentation](https://node-postgres.com/features/queries)

Version:2.0.6

Key:postgresql-new-or-updated-row

View on GitHub

PostgreSQL Overview#

On Pipedream, you can leverage the PostgreSQL app to create workflows that automate database operations, synchronize data across platforms, and react to database events in real-time. Think handling new row entries, updating records from webhooks, or even compiling reports on a set schedule. Pipedream's serverless platform provides a powerful way to connect PostgreSQL with a variety of apps, enabling you to create tailored automation that fits your specific needs.

Trigger Code#

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

export default {
  ...common,
  name: "New or Updated Row",
  key: "postgresql-new-or-updated-row",
  description: "Emit new event when a row is added or modified. [See the documentation](https://node-postgres.com/features/queries)",
  version: "2.0.6",
  type: "source",
  dedupe: "unique",
  props: {
    ...common.props,
    schema: {
      propDefinition: [
        common.props.postgresql,
        "schema",
      ],
    },
    table: {
      propDefinition: [
        common.props.postgresql,
        "table",
        (c) => ({
          schema: c.schema,
        }),
      ],
    },
    identifierColumn: {
      label: "Identifier Column",
      propDefinition: [
        common.props.postgresql,
        "column",
        (c) => ({
          table: c.table,
          schema: c.schema,
        }),
      ],
      description: "The column to identify an unique row, commonly it's `id` or `uuid`.",
    },
    timestampColumn: {
      label: "Timestamp Column",
      propDefinition: [
        common.props.postgresql,
        "column",
        (c) => ({
          table: c.table,
          schema: c.schema,
        }),
      ],
      description: "A datetime column, such as 'date_updated' or 'last_modified' that is set to the current datetime when a row is updated.",
    },
  },
  hooks: {
    async deploy() {
      await this.initialRows(
        this.schema,
        this.table,
        this.timestampColumn,
        this.limit,
      );
    },
  },
  methods: {
    ...common.methods,
    generateMeta(row, column) {
      return {
        id: `${row[this.identifierColumn]}-${row[column]}`,
        summary: "Row Added/Updated",
        ts: row[column],
      };
    },
  },
  async run() {
    await this.newRows(this.schema, this.table, this.timestampColumn);
  },
};

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
PostgreSQL	`postgresql`	`app`	This component uses the PostgreSQL app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
Polling Interval	`timer`	`$.interface.timer`	Pipedream will poll the API on this schedule
Schema	`schema`	`string`	Select a value from the drop down menu.
Table	`table`	`string`	Select a value from the drop down menu.
Identifier Column	`identifierColumn`	`string`	Select a value from the drop down menu.
Timestamp Column	`timestampColumn`	`string`	Select a value from the drop down menu.

Trigger Authentication#

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

Connecting to Restricted Databases

Either enable the shared static IP for this account below, or configure a VPC to deploy any workflow in your workspace to a private network with a dedicated static IP. Learn more in our docs.

SSL Setup

Configure SSL on your PostgreSQL database by providing the CA (Certificate Authority), and choosing between Full Verification, Verify Certificate Authority (CA), or Skip Verification. Skipping verification is not recommended as this has serious security implications.

About PostgreSQL#

PostgreSQL is a free and open-source relational database management system emphasizing extensibility and SQL compliance.

Action#

Create Album on SmugMug

Description:Creates an album. [See the docs here](https://api.smugmug.com/api/v2/doc/reference/album.html)

Version:2.0.1

Key:smugmug-create-album

View on GitHub

SmugMug Overview#

The SmugMug API provides programmatic access to a user's SmugMug account, allowing them to manage photos, albums, and account settings. With Pipedream, you can automate tasks such as uploading new images, synchronizing photo galleries with other platforms, or triggering actions based on account activity. The API's capabilities paired with Pipedream's serverless platform enable you to craft custom workflows that react to events in SmugMug or orchestrate tasks across multiple apps.

Action Code#

import smugmug from "../../smugmug.app.mjs";
import constants from "../../common/constants.mjs";

export default {
  key: "smugmug-create-album",
  name: "Create Album",
  description: "Creates an album. [See the docs here](https://api.smugmug.com/api/v2/doc/reference/album.html)",
  version: "2.0.1",
  type: "action",
  props: {
    smugmug,
    folder: {
      propDefinition: [
        smugmug,
        "folder",
      ],
    },
    title: {
      type: "string",
      label: "Title",
      description: "The human-readable title.",
    },
    niceName: {
      type: "string",
      label: "Nice Name",
      description: "The user-configurable component of the album's webUri. Must begin with a capital letter.",
    },
    urlName: {
      type: "string",
      label: "URL Name",
      description: "The user-configurable component of the album's webUri.",
      optional: true,
    },
    privacy: {
      type: "string",
      label: "Privacy",
      description: "Private is not supported on legacy accounts.\nIt can be Private, Unlisted, or Public.",
      optional: true,
      options: constants.PRIVACY_OPTIONS,
    },
    printmarkUri: {
      type: "string",
      label: "Printmark URI",
      description: "Uri of an image to use in print orders of your photos, usually, a team, company logo, your signature.",
      optional: true,
    },
    watermarkUri: {
      type: "string",
      label: "Watermark URI",
      description: "Uri of an image to be applied on your photos as a watermark for protection.",
      optional: true,
    },
    themeUri: {
      type: "string",
      label: "Theme URI",
      description: "Only applies to legacy accounts.",
      optional: true,
    },
    templateUri: {
      type: "string",
      label: "Template URI",
      description: "Uri of template, preset settings to be applied on the album.",
      optional: true,
    },
    allowDownloads: {
      type: "boolean",
      label: "Allow Downloads",
      description: "Allow downloads of this album?",
      optional: true,
    },
    backprinting: {
      type: "string",
      label: "Backprinting",
      description: "Text to appear in the back of print orders of your photos.",
      optional: true,
    },
    boutiquePackaging: {
      type: "string",
      label: "Boutique Packaging",
      description: "Is this album available for Boutique Packaging in your customers orders?",
      optional: true,
      options: constants.BOUTIQUE_PACKAGING_OPTIONS,
    },
    canRank: {
      type: "boolean",
      label: "Can Rank",
      description: "Enable Canrank property of the album.",
      optional: true,
    },
    clean: {
      type: "boolean",
      label: "Clean",
      description: "Enable Clean property of the album.",
      optional: true,
    },
    comments: {
      type: "boolean",
      label: "Comments",
      description: "Allow other users leave comments in the album?",
      optional: true,
    },
    description: {
      type: "string",
      label: "Description",
      description: "The human-readable description",
      optional: true,
    },
    downloadPassword: {
      type: "string",
      label: "Download Password",
      description: "The password used for protecting album download.",
      optional: true,
    },
    EXIF: {
      type: "string",
      label: "EXIF",
      description: "Display a photo's EXIF information.",
      optional: true,
    },
    familyEdit: {
      type: "boolean",
      label: "Family Edit",
      description: "Enable FamilyEdit property of the album.",
      optional: true,
    },
    filenames: {
      type: "boolean",
      label: "Filenames",
      description: "Enable Filenames property of the album.",
      optional: true,
    },
    friendEdit: {
      type: "string",
      label: "Friend Edit",
      description: "Allow this album available for granting special privileges to friends and family with an Smugmug account?",
      optional: true,
    },
    geography: {
      type: "boolean",
      label: "Geography",
      description: "Enable Geography property of the album.",
      optional: true,
    },
    header: {
      type: "string",
      label: "Header",
      description: "Use a customer header for the album appearance?",
      optional: true,
      options: constants.HEADER_OPTIONS,
    },
    hideOwner: {
      type: "boolean",
      label: "Hide Owner",
      description: "Hide owner information from the album?",
      optional: true,
    },
    interceptShipping: {
      type: "string",
      label: "Intercept Shipping",
      description: "Personal Delivery.",
      optional: true,
    },
    keywords: {
      type: "string",
      label: "Keywords",
      description: "A semicolon-separated list of keywords.",
      optional: true,
    },
    largestSize: {
      type: "string",
      label: "Largest Size",
      description: "Largest display sizes for images in the album.",
      optional: true,
    },
    packagingBranding: {
      type: "boolean",
      label: "Packaging Branding",
      description: "Enable PackagingBranding property of the album.",
      optional: true,
    },
    password: {
      type: "string",
      label: "Password",
      description: "The password used for protecting album access.",
      optional: true,
    },
    passwordHint: {
      type: "string",
      label: "Password Hint",
      description: "The hint for the album-access password.",
      optional: true,
    },
    printable: {
      type: "string",
      label: "Printable",
      description: "Allow images of this album to be available for printing?",
      optional: true,
    },
    proofDays: {
      type: "string",
      label: "Proof Days",
      description: "A proof-delay between 1 and 7 business days for customer orders.",
      optional: true,
    },
    protected: {
      type: "boolean",
      label: "Protected",
      description: "Enable right-click protection?",
      optional: true,
    },
    share: {
      type: "boolean",
      label: "Share",
      description: "Allow this album to be shared?",
      optional: true,
    },
    slideshow: {
      type: "boolean",
      label: "Slideshow",
      description: "Enable the slideshow content block on this album?",
      optional: true,
    },
    sortDirection: {
      type: "string",
      label: "Sort Direction",
      description: "Specifies the direction in which to sort album images.",
      optional: true,
      options: constants.SORT_DIRECTION_OPTIONS,
    },
    sortMethod: {
      type: "string",
      label: "Sort Method",
      description: "Album's image property to use for sorting?",
      optional: true,
      options: constants.SORT_METHOD_OPTIONS,
    },
    squareThumbs: {
      type: "boolean",
      label: "Square Thumbs",
      description: "Enable thumbnails in album's images (only available in SmugMug style).",
      optional: true,
    },
    uploadKey: {
      type: "string",
      label: "Upload Key",
      description: "A key for your guests to upload images to the album.",
      optional: true,
    },
    watermark: {
      type: "boolean",
      label: "Watermark",
      description: "Automatically apply watermark to uploaded images?",
      optional: true,
    },
    worldSearchable: {
      type: "string",
      label: "World Searchable",
      description: "Allow this album to appear in external search results? Can be \"No\" or \"Inherit from User\".",
      optional: true,
      options: constants.SEARCHABLE_OPTIONS,
    },
    autoRename: {
      type: "boolean",
      label: "Auto Rename",
      description: "Auto-rename conflicting album NiceNames?",
      optional: true,
    },
    securityType: {
      type: "string",
      label: "SecurityType",
      description: "Access protection method for the folder.",
      optional: true,
    },
    highlightAlbumImageUri: {
      type: "string",
      label: "Highlight Album Image URI",
      description: "Uri of an image which can be used as a representative of the entire album.",
      optional: true,
    },
    albumTemplateUri: {
      type: "string",
      label: "Album Template URI",
      description: "Specify default album presets by providing an AlbumTemplateUri.",
      optional: true,
    },
    smugSearchable: {
      type: "string",
      label: "Smug Searchable",
      description: "Allow this album to appear in SmugMug search results? Can be \"No\" or \"Inherit from User\".",
      optional: true,
      options: constants.SEARCHABLE_OPTIONS,
    },
  },
  async run({ $ }) {
    const data = {
      NiceName: this.niceName,
      UrlName: this.urlName,
      Title: this.title,
      Privacy: this.privacy,
      PrintmarkUri: this.printmarkUri,
      WatermarkUri: this.watermarkUri,
      ThemeUri: this.themeUri,
      TemplateUri: this.templateUri,
      AllowDownloads: this.allowDownloads,
      Backprinting: this.backprinting,
      BoutiquePackaging: this.boutiquePackaging,
      CanRank: this.canRank,
      Clean: this.clean,
      Comments: this.comments,
      Description: this.description,
      DownloadPassword: this.downloadPassword,
      EXIF: this.EXIF,
      FamilyEdit: this.familyEdit,
      Filenames: this.filenames,
      FriendEdit: this.friendEdit,
      Geography: this.geography,
      Header: this.header,
      HideOwner: this.hideOwner,
      InterceptShipping: this.interceptShipping,
      Keywords: this.keywords,
      LargestSize: this.largestSize,
      PackagingBranding: this.packagingBranding,
      Password: this.password,
      PasswordHint: this.passwordHint,
      Printable: this.printable,
      ProofDays: this.proofDays,
      Protected: this.protected,
      Share: this.share,
      Slideshow: this.slideshow,
      SortDirection: this.sortDirection,
      SortMethod: this.sortMethod,
      SquareThumbs: this.squareThumbs,
      UploadKey: this.uploadKey,
      Watermark: this.watermark,
      WorldSearchable: this.worldSearchable,
      AutoRename: this.AatoRename,
      SecurityType: this.securityType,
      HighlightAlbumImageUri: this.highlightAlbumImageUri,
      AlbumTemplateUri: this.albumTemplateUri,
      SmugSearchable: this.smugSearchable,
    };

    const nickname = await this.smugmug.getAuthenticatedUserNickname();
    const response = await this.smugmug.createAlbum(nickname, this.folder, {
      $,
      data,
    });
    if (response) {
      $.export("$summary", `Created album with key ${response.Response.Album.AlbumKey}`);
    }
    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
SmugMug	`smugmug`	`app`	This component uses the SmugMug app.
Folder	`folder`	`string`	Select a value from the drop down menu.
Title	`title`	`string`	The human-readable title.
Nice Name	`niceName`	`string`	The user-configurable component of the album's webUri. Must begin with a capital letter.
URL Name	`urlName`	`string`	The user-configurable component of the album's webUri.
Privacy	`privacy`	`string`	Select a value from the drop down menu:`PublicUnlistedPrivate`
Printmark URI	`printmarkUri`	`string`	Uri of an image to use in print orders of your photos, usually, a team, company logo, your signature.
Watermark URI	`watermarkUri`	`string`	Uri of an image to be applied on your photos as a watermark for protection.
Theme URI	`themeUri`	`string`	Only applies to legacy accounts.
Template URI	`templateUri`	`string`	Uri of template, preset settings to be applied on the album.
Allow Downloads	`allowDownloads`	`boolean`	Allow downloads of this album?
Backprinting	`backprinting`	`string`	Text to appear in the back of print orders of your photos.
Boutique Packaging	`boutiquePackaging`	`string`	Select a value from the drop down menu:`NoYesInherit from User`
Can Rank	`canRank`	`boolean`	Enable Canrank property of the album.
Clean	`clean`	`boolean`	Enable Clean property of the album.
Comments	`comments`	`boolean`	Allow other users leave comments in the album?
Description	`description`	`string`	The human-readable description
Download Password	`downloadPassword`	`string`	The password used for protecting album download.
EXIF	`EXIF`	`string`	Display a photo's EXIF information.
Family Edit	`familyEdit`	`boolean`	Enable FamilyEdit property of the album.
Filenames	`filenames`	`boolean`	Enable Filenames property of the album.
Friend Edit	`friendEdit`	`string`	Allow this album available for granting special privileges to friends and family with an Smugmug account?
Geography	`geography`	`boolean`	Enable Geography property of the album.
Header	`header`	`string`	Select a value from the drop down menu:`CustomSmugMug`
Hide Owner	`hideOwner`	`boolean`	Hide owner information from the album?
Intercept Shipping	`interceptShipping`	`string`	Personal Delivery.
Keywords	`keywords`	`string`	A semicolon-separated list of keywords.
Largest Size	`largestSize`	`string`	Largest display sizes for images in the album.
Packaging Branding	`packagingBranding`	`boolean`	Enable PackagingBranding property of the album.
Password	`password`	`string`	The password used for protecting album access.
Password Hint	`passwordHint`	`string`	The hint for the album-access password.
Printable	`printable`	`string`	Allow images of this album to be available for printing?
Proof Days	`proofDays`	`string`	A proof-delay between 1 and 7 business days for customer orders.
Protected	`protected`	`boolean`	Enable right-click protection?
Share	`share`	`boolean`	Allow this album to be shared?
Slideshow	`slideshow`	`boolean`	Enable the slideshow content block on this album?
Sort Direction	`sortDirection`	`string`	Select a value from the drop down menu:`AscendingDescending`
Sort Method	`sortMethod`	`string`	Select a value from the drop down menu:`PositionCaptionFilenameDate UploadedDate ModifiedDate Taken`
Square Thumbs	`squareThumbs`	`boolean`	Enable thumbnails in album's images (only available in SmugMug style).
Upload Key	`uploadKey`	`string`	A key for your guests to upload images to the album.
Watermark	`watermark`	`boolean`	Automatically apply watermark to uploaded images?
World Searchable	`worldSearchable`	`string`	Select a value from the drop down menu:`NoInherit from User`
Auto Rename	`autoRename`	`boolean`	Auto-rename conflicting album NiceNames?
SecurityType	`securityType`	`string`	Access protection method for the folder.
Highlight Album Image URI	`highlightAlbumImageUri`	`string`	Uri of an image which can be used as a representative of the entire album.
Album Template URI	`albumTemplateUri`	`string`	Specify default album presets by providing an AlbumTemplateUri.
Smug Searchable	`smugSearchable`	`string`	Select a value from the drop down menu:`NoInherit from User`

Action Authentication#

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

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