Search Places with Google Maps (Places API) API on New Deleted Record (Instant, of Selectable Type) from Salesforce API

Pipedream makes it easy to connect APIs for Google Maps (Places API), Salesforce and 2,500+ other apps remarkably fast.

Trigger workflow on

New Deleted Record (Instant, of Selectable Type) from the Salesforce API

Next, do this

Search Places with the Google Maps (Places API) 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 Salesforce trigger and Google Maps (Places API) action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the New Deleted Record (Instant, of Selectable Type) trigger
1. Connect your Salesforce account
2. Configure timer
3. Select a Object Type
Configure the Search Places action
1. Connect your Google Maps (Places API) account
2. Configure Text Query
3. Optional- Configure Included Type
4. Optional- Configure Include Pure Service Area Businesses
5. Optional- Select a Language Code
6. Optional- Configure Location Bias
7. Optional- Configure Location Restriction
8. Optional- Configure EV Options
9. Optional- Configure Min Rating
10. Optional- Configure Open Now
11. Optional- Select one or more Price Levels
12. Optional- Select a Rank Preference
13. Optional- Configure Region Code
14. Optional- Configure Strict Type Filtering
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 Deleted Record (Instant, of Selectable Type) on Salesforce

Description:Emit new event when a record of the selected object type is deleted. [See the documentation](https://sforce.co/3msDDEE)

Version:0.1.0

Key:salesforce_rest_api-record-deleted-instant

View on GitHub

Salesforce Overview#

The Salesforce (REST API) provides a powerful platform for creating and managing customer relationships with a wide array of features like data manipulation, querying, and complex automation. With Pipedream's serverless execution, you can create workflows that automate your sales processes, sync data with other platforms, enhance customer engagement, and trigger actions based on specific events. Dive into Salesforce data, streamline lead management, track customer interactions, and push or pull data to or from Salesforce seamlessly.

Trigger Code#

import startCase from "lodash/startCase.js";
import common from "../common.mjs";

export default {
  ...common,
  type: "source",
  name: "New Deleted Record (Instant, of Selectable Type)",
  key: "salesforce_rest_api-record-deleted-instant",
  description: "Emit new event when a record of the selected object type is deleted. [See the documentation](https://sforce.co/3msDDEE)",
  version: "0.1.0",
  methods: {
    ...common.methods,
    generateWebhookMeta(data) {
      const nameField = this.getNameField();
      const { Old: oldObject } = data.body;
      const {
        LastModifiedDate: lastModifiedDate,
        Id: id,
        [nameField]: name,
      } = oldObject;
      const entityType = startCase(this.objectType);
      const summary = `${entityType} deleted: ${name}`;
      const ts = Date.parse(lastModifiedDate);
      const compositeId = `${id}-${ts}`;
      return {
        id: compositeId,
        summary,
        ts,
      };
    },
    generateTimerMeta(item) {
      const {
        id,
        deletedDate,
      } = item;
      const entityType = startCase(this.objectType);
      const summary = `${entityType} deleted: ${id}`;
      const ts = Date.parse(deletedDate);
      return {
        id,
        summary,
        ts,
      };
    },
    getEventType() {
      return "deleted";
    },
    async processTimerEvent(eventData) {
      const {
        startTimestamp,
        endTimestamp,
      } = eventData;
      const {
        deletedRecords,
        latestDateCovered,
      } = await this.salesforce.getDeletedForObjectType(
        this.objectType,
        startTimestamp,
        endTimestamp,
      );
      this.setLatestDateCovered(latestDateCovered);

      // When a record is deleted, the `getDeleted` API only shows the ID of the
      // deleted item and the date in which it was deleted.
      deletedRecords.forEach((item) => {
        const meta = this.generateTimerMeta(item);
        this.$emit(item, meta);
      });
    },
  },
};

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
Salesforce	`salesforce`	`app`	This component uses the Salesforce app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
N/A	`http`	`$.interface.http`	This component uses `$.interface.http` to generate a unique URL when the component is first instantiated. Each request to the URL will trigger the `run()` method of the component.
	`timer`	`$.interface.timer`	The timer is only used as a fallback if instant event delivery (webhook) is not available.
Object Type	`objectType`	`string`	Select a value from the drop down menu.

Trigger Authentication#

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

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

About Salesforce#

Web services API for interacting with Salesforce

Action#

Search Places on Google Maps (Places API)

Description:Searches for places based on location, radius, and optional filters like keywords, place type, or name. [See the documentation](https://developers.google.com/maps/documentation/places/web-service/text-search)

Version:0.0.1

Key:google_maps_platform-search-places

View on GitHub

Google Maps (Places API) Overview#

The Google Maps (Places API) offers detailed information about physical locations, including places of interest, reviews, and other metadata. In Pipedream, you can leverage this API to create dynamic workflows that respond to location data. Whether you're building apps that track asset locations, automate location-based alerts, or provide users with local info, integrating with Google Maps can add a powerful spatial context to your services.

Action Code#

import {
  LANGUAGE_CODE_OPTIONS,
  PRICE_LEVEL_OPTIONS,
  RANK_PREFERENCE_OPTIONS,
} from "../../common/constants.mjs";
import { parseObject } from "../../common/utils.mjs";
import app from "../../google_maps_platform.app.mjs";

export default {
  key: "google_maps_platform-search-places",
  name: "Search Places",
  description: "Searches for places based on location, radius, and optional filters like keywords, place type, or name. [See the documentation](https://developers.google.com/maps/documentation/places/web-service/text-search)",
  version: "0.0.1",
  type: "action",
  props: {
    app,
    textQuery: {
      type: "string",
      label: "Text Query",
      description: "The text string on which to search, for example: \"restaurant\", \"123 Main Street\", or \"best place to visit in San Francisco\". The API returns candidate matches based on this string and orders the results based on their perceived relevance.",
    },
    includedType: {
      type: "string",
      label: "Included Type",
      description: "Restricts the results to places matching the specified type defined by [Table A](https://developers.google.com/maps/documentation/places/web-service/place-types#table-a). Only one type may be specified.",
      optional: true,
    },
    includePureServiceAreaBusinesses: {
      type: "boolean",
      label: "Include Pure Service Area Businesses",
      description: "If set to `true`, the response includes businesses that visit or deliver to customers directly, but don't have a physical business location. If set to `false`, the API returns only businesses with a physical business location.",
      optional: true,
    },
    languageCode: {
      type: "string",
      label: "Language Code",
      description: "The language in which to return results.",
      options: LANGUAGE_CODE_OPTIONS,
      optional: true,
    },
    locationBias: {
      type: "object",
      label: "Location Bias",
      description: "Specifies an area to search. This location serves as a bias which means results around the specified location can be returned, including results outside the specified area. [See the documentation](https://developers.google.com/maps/documentation/places/web-service/text-search#location-bias) for further information.",
      optional: true,
    },
    locationRestriction: {
      type: "string",
      label: "Location Restriction",
      description: "Specifies an area to search. Results outside the specified area are not returned.",
      optional: true,
    },
    evOptions: {
      type: "object",
      label: "EV Options",
      description: "Specifies parameters for identifying available electric vehicle (EV) charging connectors and charging rates. [See the documentation](https://developers.google.com/maps/documentation/places/web-service/text-search#evoptions) for further information.",
      optional: true,
    },
    minRating: {
      type: "string",
      label: "Min Rating",
      description: "Restricts results to only those whose average user rating is greater than or equal to this limit. Values must be between 0.0 and 5.0 (inclusive) in increments of 0.5. For example: 0, 0.5, 1.0, ... , 5.0 inclusive. Values are rounded up to the nearest 0.5. For example, a value of 0.6 eliminates all results with a rating less than 1.0.",
      optional: true,
    },
    openNow: {
      type: "boolean",
      label: "Open Now",
      description: "If `true`, return only those places that are open for business at the time the query is sent. If `false`, return all businesses regardless of open status. Places that don't specify opening hours in the Google Places database are returned if you set this parameter to `false`.",
      optional: true,
    },
    priceLevels: {
      type: "string[]",
      label: "Price Levels",
      description: "Restrict the search to places that are marked at certain price levels. The default is to select all price levels.",
      options: PRICE_LEVEL_OPTIONS,
      optional: true,
    },
    rankPreference: {
      type: "string",
      label: "Rank Preference",
      description: "Specifies how the results are ranked in the response based on the type of query: For a categorical query such as \"Restaurants in New York City\", RELEVANCE (rank results by search relevance) is the default. You can set Rank Preference to RELEVANCE or DISTANCE (rank results by distance). For a non-categorical query such as \"Mountain View, CA\", it is recommended that you leave Rank Preference unset.",
      options: RANK_PREFERENCE_OPTIONS,
      optional: true,
    },
    regionCode: {
      type: "string",
      label: "Region Code",
      description: "The region code used to format the response, specified as a [two-character CLDR code](https://www.unicode.org/cldr/charts/46/supplemental/territory_language_information.html) value. This parameter can also have a bias effect on the search results.",
      optional: true,
    },
    strictTypeFiltering: {
      type: "boolean",
      label: "Strict Type Filtering",
      description: "Used with the `Included Type` parameter. When set to `true`, only places that match the specified types specified by includeType are returned. When `false`, the default, the response can contain places that don't match the specified types.",
      optional: true,
    },
  },
  async run({ $ }) {
    const response = await this.app.searchPlaces({
      $,
      data: {
        textQuery: this.textQuery,
        includedType: this.includedType,
        includePureServiceAreaBusinesses: this.includePureServiceAreaBusinesses,
        languageCode: this.languageCode,
        locationBias: parseObject(this.locationBias),
        locationRestriction: this.locationRestriction,
        evOptions: parseObject(this.evOptions),
        minRating: this.minRating,
        openNow: this.openNow,
        priceLevels: parseObject(this.priceLevels),
        rankPreference: this.rankPreference,
        regionCode: this.regionCode,
        strictTypeFiltering: this.strictTypeFiltering,
      },
    });

    const placeCount = response.places?.length || 0;
    $.export("$summary", `Found ${placeCount} place(s)`);

    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
Google Maps (Places API)	`app`	`app`	This component uses the Google Maps (Places API) app.
Text Query	`textQuery`	`string`	The text string on which to search, for example: "restaurant", "123 Main Street", or "best place to visit in San Francisco". The API returns candidate matches based on this string and orders the results based on their perceived relevance.
Included Type	`includedType`	`string`	Restricts the results to places matching the specified type defined by Table A. Only one type may be specified.
Include Pure Service Area Businesses	`includePureServiceAreaBusinesses`	`boolean`	If set to `true`, the response includes businesses that visit or deliver to customers directly, but don't have a physical business location. If set to `false`, the API returns only businesses with a physical business location.
Language Code	`languageCode`	`string`	Select a value from the drop down menu:`{ "label": "Afrikaans", "value": "af" }{ "label": "Albanian", "value": "sq" }{ "label": "Amharic", "value": "am" }{ "label": "Arabic", "value": "ar" }{ "label": "Armenian", "value": "hy" }{ "label": "Azerbaijani", "value": "az" }{ "label": "Basque", "value": "eu" }{ "label": "Belarusian", "value": "be" }{ "label": "Bengali", "value": "bn" }{ "label": "Bosnian", "value": "bs" }{ "label": "Bulgarian", "value": "bg" }{ "label": "Burmese", "value": "my" }{ "label": "Catalan", "value": "ca" }{ "label": "Chinese", "value": "zh" }{ "label": "Chinese (Simplified)", "value": "zh-CN" }{ "label": "Chinese (Hong Kong)", "value": "zh-HK" }{ "label": "Chinese (Traditional)", "value": "zh-TW" }{ "label": "Croatian", "value": "hr" }{ "label": "Czech", "value": "cs" }{ "label": "Danish", "value": "da" }{ "label": "Dutch", "value": "nl" }{ "label": "English", "value": "en" }{ "label": "English (Australian)", "value": "en-AU" }{ "label": "English (Great Britain)", "value": "en-GB" }{ "label": "Estonian", "value": "et" }{ "label": "Farsi", "value": "fa" }{ "label": "Finnish", "value": "fi" }{ "label": "Filipino", "value": "fil" }{ "label": "French", "value": "fr" }{ "label": "French (Canada)", "value": "fr-CA" }{ "label": "Galician", "value": "gl" }{ "label": "Georgian", "value": "ka" }{ "label": "German", "value": "de" }{ "label": "Greek", "value": "el" }{ "label": "Gujarati", "value": "gu" }{ "label": "Hebrew", "value": "iw" }{ "label": "Hindi", "value": "hi" }{ "label": "Hungarian", "value": "hu" }{ "label": "Icelandic", "value": "is" }{ "label": "Indonesian", "value": "id" }{ "label": "Italian", "value": "it" }{ "label": "Japanese", "value": "ja" }{ "label": "Kannada", "value": "kn" }{ "label": "Kazakh", "value": "kk" }{ "label": "Khmer", "value": "km" }{ "label": "Korean", "value": "ko" }{ "label": "Kyrgyz", "value": "ky" }{ "label": "Lao", "value": "lo" }{ "label": "Latvian", "value": "lv" }{ "label": "Lithuanian", "value": "lt" }{ "label": "Macedonian", "value": "mk" }{ "label": "Malay", "value": "ms" }{ "label": "Malayalam", "value": "ml" }{ "label": "Marathi", "value": "mr" }{ "label": "Mongolian", "value": "mn" }{ "label": "Nepali", "value": "ne" }{ "label": "Norwegian", "value": "no" }{ "label": "Polish", "value": "pl" }{ "label": "Portuguese", "value": "pt" }{ "label": "Portuguese (Brazil)", "value": "pt-BR" }{ "label": "Portuguese (Portugal)", "value": "pt-PT" }{ "label": "Punjabi", "value": "pa" }{ "label": "Romanian", "value": "ro" }{ "label": "Russian", "value": "ru" }{ "label": "Serbian", "value": "sr" }{ "label": "Sinhalese", "value": "si" }{ "label": "Slovak", "value": "sk" }{ "label": "Slovenian", "value": "sl" }{ "label": "Spanish", "value": "es" }{ "label": "Spanish (Latin America)", "value": "es-419" }{ "label": "Swahili", "value": "sw" }{ "label": "Swedish", "value": "sv" }{ "label": "Tamil", "value": "ta" }{ "label": "Telugu", "value": "te" }{ "label": "Thai", "value": "th" }{ "label": "Turkish", "value": "tr" }{ "label": "Ukrainian", "value": "uk" }{ "label": "Urdu", "value": "ur" }{ "label": "Uzbek", "value": "uz" }{ "label": "Vietnamese", "value": "vi" }{ "label": "Zulu", "value": "zu" }`
Location Bias	`locationBias`	`object`	Specifies an area to search. This location serves as a bias which means results around the specified location can be returned, including results outside the specified area. See the documentation for further information.
Location Restriction	`locationRestriction`	`string`	Specifies an area to search. Results outside the specified area are not returned.
EV Options	`evOptions`	`object`	Specifies parameters for identifying available electric vehicle (EV) charging connectors and charging rates. See the documentation for further information.
Min Rating	`minRating`	`string`	Restricts results to only those whose average user rating is greater than or equal to this limit. Values must be between 0.0 and 5.0 (inclusive) in increments of 0.5. For example: 0, 0.5, 1.0, ... , 5.0 inclusive. Values are rounded up to the nearest 0.5. For example, a value of 0.6 eliminates all results with a rating less than 1.0.
Open Now	`openNow`	`boolean`	If `true`, return only those places that are open for business at the time the query is sent. If `false`, return all businesses regardless of open status. Places that don't specify opening hours in the Google Places database are returned if you set this parameter to `false`.
Price Levels	`priceLevels`	`string[]`	Select a value from the drop down menu:`{ "label": "Place price level is unspecified or unknown.", "value": "PRICE_LEVEL_UNSPECIFIED" }{ "label": "Place provides free services.", "value": "PRICE_LEVEL_FREE" }{ "label": "Place provides inexpensive services.", "value": "PRICE_LEVEL_INEXPENSIVE" }{ "label": "Place provides moderately priced services.", "value": "PRICE_LEVEL_MODERATE" }{ "label": "Place provides expensive services.", "value": "PRICE_LEVEL_EXPENSIVE" }{ "label": "Place provides very expensive services.", "value": "PRICE_LEVEL_VERY_EXPENSIVE" }`
Rank Preference	`rankPreference`	`string`	Select a value from the drop down menu:`{ "label": "Rank results by search relevance.", "value": "RELEVANCE" }{ "label": "Rank results by distance.", "value": "DISTANCE" }`
Region Code	`regionCode`	`string`	The region code used to format the response, specified as a two-character CLDR code value. This parameter can also have a bias effect on the search results.
Strict Type Filtering	`strictTypeFiltering`	`boolean`	Used with the `Included Type` parameter. When set to `true`, only places that match the specified types specified by includeType are returned. When `false`, the default, the response can contain places that don't match the specified types.

Action Authentication#

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

Create and copy your API key from the Google Maps Platform Credentials page.