Create Limo Booking with LimoExpress API on New Records Returned by CloudWatch Logs Insights Query from AWS API

Pipedream makes it easy to connect APIs for LimoExpress, AWS and 2,700+ other apps remarkably fast.

Trigger workflow on

New Records Returned by CloudWatch Logs Insights Query from the AWS API

Next, do this

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

Select this integration
Configure the New Records Returned by CloudWatch Logs Insights Query trigger
1. Connect your AWS account
2. Select a AWS Region
3. Select one or more CloudWatch Log Groups
4. Configure Logs Insights Query
5. Optional- Configure Emit query results as a single event
6. Configure Polling schedule
Configure the Create Limo Booking action
1. Connect your LimoExpress account
2. Select a Booking Type ID
3. Optional- Select a Booking Status ID
4. Configure From Location Name
5. Configure From Location Full Address
6. Optional- Configure From Location Latitude
7. Optional- Configure From Location Longitude
8. Configure To Location Name
9. Configure To Location Full Address
10. Optional- Configure To Location Latitude
11. Optional- Configure To Location Longitude
12. Configure Pickup Time
13. Optional- Configure Expected Drop Off Time
14. Optional- Configure Expected Comeback Time
15. Optional- Select a Vehicle Class ID
16. Optional- Select a Vehicle ID
17. Optional- Configure Price
18. Optional- Select a Price Type
19. Optional- Configure Commission Amount
20. Optional- Select a Currency ID
21. Optional- Configure VAT Percentage
22. Optional- Select a Payment Method ID
23. Optional- Configure Distance
24. Optional- Configure Duration
25. Optional- Configure Paid
26. Optional- Configure Confirmed
27. Optional- Configure Round Trip
28. Optional- Configure Note
29. Optional- Configure Note for Driver
30. Optional- Configure Flight Number
31. Optional- Configure Number of Waiting Hours
32. Optional- Select a Client ID
33. Optional- Configure Waiting Board Text
34. Optional- Configure Baby Seat Count
35. Optional- Configure Suitcase Count
36. Optional- Configure Checkpoints
37. Optional- Configure Passengers
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 Records Returned by CloudWatch Logs Insights Query on AWS

Description:Executes a CloudWatch Logs Insights query on a schedule, and emits the records as invidual events (default) or in batch

Version:0.2.2

Key:aws-new-records-returned-by-cloudwatch-logs-insights-query

View on GitHub

AWS Overview#

The AWS API unlocks endless possibilities for automation with Pipedream. With this powerful combo, you can manage your AWS services and resources, automate deployment workflows, process data, and react to events across your AWS infrastructure. Pipedream offers a serverless platform for creating workflows triggered by various events that can execute AWS SDK functions, making it an efficient tool to integrate, automate, and orchestrate tasks across AWS services and other apps.

Trigger Code#

import common from "../../common/common-cloudwatch-logs.mjs";
import { DEFAULT_POLLING_SOURCE_TIMER_INTERVAL } from "@pipedream/platform";

export default {
  ...common,
  key: "aws-new-records-returned-by-cloudwatch-logs-insights-query",
  name: "New Records Returned by CloudWatch Logs Insights Query",
  // eslint-disable-next-line pipedream/source-description
  description: "Executes a CloudWatch Logs Insights query on a schedule, and emits the records as invidual events (default) or in batch",
  version: "0.2.2",
  type: "source",
  props: {
    aws: common.props.aws,
    region: common.props.region,
    db: "$.service.db",
    // eslint-disable-next-line pipedream/props-label
    logGroupNames: {
      ...common.props.logGroupName,
      type: "string[]",
      description: "The log groups you'd like to query",
    },
    queryString: {
      label: "Logs Insights Query",
      description: "The query you'd like to run. See [this AWS doc](https://docs.aws.amazon.com/AmazonCloudWatch/latest/logs/CWL_QuerySyntax.html) for help with query syntax",
      type: "string",
    },
    emitResultsInBatch: {
      type: "boolean",
      label: "Emit query results as a single event",
      description: "If `true`, all events are emitted as an array, within a single Pipedream event. If `false`, each row of results is emitted as its own event. Defaults to `true`",
      optional: true,
      default: true,
    },
    timer: {
      label: "Polling schedule",
      description: "How often you want to query CloudWatch Logs Insights for results",
      type: "$.interface.timer",
      default: {
        intervalSeconds: DEFAULT_POLLING_SOURCE_TIMER_INTERVAL,
      },
    },
  },
  async run() {
    const now = +new Date();
    const startTime = this.db.get("startTime") || now - 1000 * 60 * 60;

    // First, start the query
    const params = {
      queryString: this.queryString,
      startTime,
      endTime: now,
      logGroupNames: this.logGroupNames,
    };

    const { queryId } = await this.startQuery(params);

    // Then poll for its status, emitting each record as its own event when completed
    async function sleep(ms) {
      return new Promise((r) => setTimeout(r, ms));
    }

    let result, res;
    do {
      await sleep(1000);
      res = await this.getQueryResults({
        queryId,
      });
      result = res.status;
    } while (result === "Running" || result === "Scheduled");

    if (result !== "Complete") {
      throw new Error(`Query ${queryId} failed with status ${result}`);
    }

    console.log(JSON.stringify(res, null, 2));
    const { results } = res;

    if (!results || !results.length) {
      console.log("No results, exiting");
      this.db.set("startTime", now);
      return;
    }

    if (this.emitResultsInBatch === true) {
      this.$emit(results, {
        summary: JSON.stringify(results),
      });
    } else {
      for (const item of results) {
        this.$emit(item, {
          summary: JSON.stringify(item),
        });
      }
    }

    // The next time this source runs, query for data starting now
    this.db.set("startTime", now);
  },
};

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
AWS	`aws`	`app`	This component uses the AWS app.
AWS Region	`region`	`string`	Select a value from the drop down menu.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
CloudWatch Log Groups	`logGroupNames`	`string[]`	Select a value from the drop down menu.
Logs Insights Query	`queryString`	`string`	The query you'd like to run. See this AWS doc for help with query syntax
Emit query results as a single event	`emitResultsInBatch`	`boolean`	If `true`, all events are emitted as an array, within a single Pipedream event. If `false`, each row of results is emitted as its own event. Defaults to `true`
Polling schedule	`timer`	`$.interface.timer`	How often you want to query CloudWatch Logs Insights for results

Trigger Authentication#

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

Follow the AWS Instructions for creating an IAM user with an associated access and secret key.

As a best practice, attach the minimum set of IAM permissions necessary to perform the specific task in Pipedream. If your workflow only needs to perform a single API call, you should create a user and associate an IAM group / policy with permission to do only that task. You can create as many linked AWS accounts in Pipedream as you'd like.

Enter your access and secret key below.

About AWS#

Amazon Web Services (AWS) offers reliable, scalable, and inexpensive cloud computing services.

Action#

Create Limo Booking on LimoExpress

Description:Creates a new limo booking with specified details. [See the documentation](https://api.limoexpress.me/api/docs/v1#/Bookings/createBooking)

Version:0.0.1

Key:limoexpress-create-booking

View on GitHub

Action Code#

import { PRICE_TYPE_OPTIONS } from "../../common/constants.mjs";
import { throwError } from "../../common/utils.mjs";
import limoexpress from "../../limoexpress.app.mjs";

export default {
  key: "limoexpress-create-booking",
  name: "Create Limo Booking",
  description: "Creates a new limo booking with specified details. [See the documentation](https://api.limoexpress.me/api/docs/v1#/Bookings/createBooking)",
  version: "0.0.1",
  type: "action",
  props: {
    limoexpress,
    bookingTypeId: {
      propDefinition: [
        limoexpress,
        "bookingTypeId",
      ],
    },
    bookingStatusId: {
      propDefinition: [
        limoexpress,
        "bookingStatusId",
      ],
      optional: true,
    },
    fromLocationName: {
      type: "string",
      label: "From Location Name",
      description: "The pickup location name.",
    },
    fromLocationFullAddress: {
      type: "string",
      label: "From Location Full Address",
      description: "The pickup location full address.",
    },
    fromLocationLatitude: {
      type: "string",
      label: "From Location Latitude",
      description: "The pickup location latitude.",
      optional: true,
    },
    fromLocationLongitude: {
      type: "string",
      label: "From Location Longitude",
      description: "The pickup location longitude.",
      optional: true,
    },
    toLocationName: {
      type: "string",
      label: "To Location Name",
      description: "The dropoff location name.",
    },
    toLocationFullAddress: {
      type: "string",
      label: "To Location Full Address",
      description: "The dropoff location full address.",
    },
    toLocationLatitude: {
      type: "string",
      label: "To Location Latitude",
      description: "The dropoff location latitude.",
      optional: true,
    },
    toLocationLongitude: {
      type: "string",
      label: "To Location Longitude",
      description: "The dropoff location longitude.",
      optional: true,
    },
    pickupTime: {
      type: "string",
      label: "Pickup Time",
      description: "The time scheduled for pickup. **Format: YYYY-MM-DD HH:MM:SS**",
    },
    expectedDropOffTime: {
      type: "string",
      label: "Expected Drop Off Time",
      description: "The expected drop off time. **Format: YYYY-MM-DD HH:MM:SS**",
      optional: true,
    },
    expectedComebackTime: {
      type: "string",
      label: "Expected Comeback Time",
      description: "The expected comeback time. **Format: YYYY-MM-DD HH:MM:SS**",
      optional: true,
    },
    vehicleClassId: {
      propDefinition: [
        limoexpress,
        "vehicleClassId",
      ],
      withLabel: true,
      optional: true,
    },
    vehicleId: {
      propDefinition: [
        limoexpress,
        "vehicleId",
        ({ vehicleClassId }) => ({
          vehicleClassId: vehicleClassId.label,
        }),
      ],
      optional: true,
    },
    price: {
      type: "string",
      label: "Price",
      description: "The price of the booking.",
      optional: true,
    },
    priceType: {
      type: "string",
      label: "Price Type",
      description: "The type of price for the booking.",
      options: PRICE_TYPE_OPTIONS,
      optional: true,
    },
    commissionAmount: {
      type: "string",
      label: "Commission Amount",
      description: "The commission amount for the booking.",
      optional: true,
    },
    currencyId: {
      propDefinition: [
        limoexpress,
        "currencyId",
      ],
      optional: true,
    },
    vatPercentage: {
      type: "string",
      label: "VAT Percentage",
      description: "The VAT percentage for the booking.",
      optional: true,
    },
    paymentMethodId: {
      propDefinition: [
        limoexpress,
        "paymentMethodId",
      ],
      optional: true,
    },
    distance: {
      type: "integer",
      label: "Distance",
      description: "Number of kilometers/miles that booking will take.",
      optional: true,
    },
    duration: {
      type: "string",
      label: "Duration",
      description: "Number of hours and minutes that booking will take. **Format: HH:MM**",
      optional: true,
    },
    paid: {
      type: "boolean",
      label: "Paid",
      description: "Flag that says is the booking paid or not.",
      optional: true,
    },
    confirmed: {
      type: "boolean",
      label: "Confirmed",
      description: "Flag that says is the booking confirmed or not.",
      optional: true,
    },
    roundTrip: {
      type: "boolean",
      label: "Round Trip",
      description: "Flag that says is the booking a round trip or not.",
      optional: true,
    },
    note: {
      type: "string",
      label: "Note",
      description: "Note for the dispatcher.",
      optional: true,
    },
    noteForDriver: {
      type: "string",
      label: "Note for Driver",
      description: "Note for the driver.",
      optional: true,
    },
    flightNumber: {
      type: "string",
      label: "Flight Number",
      description: "Flight number for the booking.",
      optional: true,
    },
    numOfWaitingHours: {
      type: "integer",
      label: "Number of Waiting Hours",
      description: "Number of waiting hours.",
      optional: true,
    },
    clientId: {
      propDefinition: [
        limoexpress,
        "clientId",
      ],
      optional: true,
    },
    waitingBoardText: {
      type: "string",
      label: "Waiting Board Text",
      description: "Text that will be places on the waiting board.",
      optional: true,
    },
    babySeatCount: {
      type: "integer",
      label: "Baby Seat Count",
      description: "Number of baby seats that will be used for the booking.",
      optional: true,
    },
    suitcaseCount: {
      type: "integer",
      label: "Suitcase Count",
      description: "Number of suitcases that will be used for the booking.",
      optional: true,
    },
    checkpoints: {
      type: "string[]",
      label: "Checkpoints",
      description: "List of objects of checkpoints location and time. **Format: [{\"location\": { \"name\": string, \"full_address\": string, \"coordinates\": { \"lat\": number, \"lng\": number } }, \"time\": \"01:14\"}]**",
      optional: true,
    },
    passengers: {
      type: "string[]",
      label: "Passengers",
      description: "List of objects of passengers. **Format: [{\"first_name\": string, \"last_name\": string, \"phone\": string, \"email\": string, \"nationality\": string, \"passport\": string, \"country_id\": UUID }]",
      optional: true,
    },
  },
  async run({ $ }) {
    try {
      const response = await this.limoexpress.createBooking({
        $,
        data: {
          booking_type_id: this.bookingTypeId,
          booking_status_id: this.bookingStatusId,
          from_location: {
            name: this.fromLocationName,
            full_address: this.fromLocationFullAddress,
            coordinates: {
              lat: this.fromLocationLatitude,
              lng: this.fromLocationLongitude,
            },
          },
          to_location: {
            name: this.toLocationName,
            full_address: this.toLocationFullAddress,
            coordinates: {
              lat: this.toLocationLatitude,
              lng: this.toLocationLongitude,
            },
          },
          pickup_time: this.pickupTime,
          expected_drop_off_time: this.expectedDropOffTime,
          expected_comeback_time: this.expectedComebackTime,
          vehicle_class_id: this.vehicleClassId.value,
          vehicle_id: this.vehicleId,
          price: this.price && parseFloat(this.price),
          price_type: this.priceType,
          commission_amount: this.commissionAmount && parseFloat(this.commissionAmount),
          currency_id: this.currencyId,
          vat_percentage: this.vatPercentage && parseFloat(this.vatPercentage),
          payment_method_id: this.paymentMethodId,
          distance: this.distance,
          duration: this.duration,
          paid: this.paid,
          confirmed: this.confirmed,
          round_trip: this.roundTrip,
          note: this.note,
          note_for_driver: this.noteForDriver,
          flight_number: this.flightNumber,
          num_of_waiting_hours: this.numOfWaitingHours,
          client_id: this.clientId,
          waiting_board_text: this.waitingBoardText,
          baby_seat_count: this.babySeatCount,
          suitcase_count: this.suitcaseCount,
          checkpoints: this.checkpoints,
          passengers: this.passengers,
        },
      });

      $.export("$summary", `Successfully created booking with ID ${response.data.id}`);
      return response;
    } catch ({ response }) {
      throwError(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
LimoExpress	`limoexpress`	`app`	This component uses the LimoExpress app.
Booking Type ID	`bookingTypeId`	`string`	Select a value from the drop down menu.
Booking Status ID	`bookingStatusId`	`string`	Select a value from the drop down menu.
From Location Name	`fromLocationName`	`string`	The pickup location name.
From Location Full Address	`fromLocationFullAddress`	`string`	The pickup location full address.
From Location Latitude	`fromLocationLatitude`	`string`	The pickup location latitude.
From Location Longitude	`fromLocationLongitude`	`string`	The pickup location longitude.
To Location Name	`toLocationName`	`string`	The dropoff location name.
To Location Full Address	`toLocationFullAddress`	`string`	The dropoff location full address.
To Location Latitude	`toLocationLatitude`	`string`	The dropoff location latitude.
To Location Longitude	`toLocationLongitude`	`string`	The dropoff location longitude.
Pickup Time	`pickupTime`	`string`	The time scheduled for pickup. Format: YYYY-MM-DD HH:MM:SS
Expected Drop Off Time	`expectedDropOffTime`	`string`	The expected drop off time. Format: YYYY-MM-DD HH:MM:SS
Expected Comeback Time	`expectedComebackTime`	`string`	The expected comeback time. Format: YYYY-MM-DD HH:MM:SS
Vehicle Class ID	`vehicleClassId`	`string`	Select a value from the drop down menu.
Vehicle ID	`vehicleId`	`string`	Select a value from the drop down menu.
Price	`price`	`string`	The price of the booking.
Price Type	`priceType`	`string`	Select a value from the drop down menu:`NETGROSS`
Commission Amount	`commissionAmount`	`string`	The commission amount for the booking.
Currency ID	`currencyId`	`string`	Select a value from the drop down menu.
VAT Percentage	`vatPercentage`	`string`	The VAT percentage for the booking.
Payment Method ID	`paymentMethodId`	`string`	Select a value from the drop down menu.
Distance	`distance`	`integer`	Number of kilometers/miles that booking will take.
Duration	`duration`	`string`	Number of hours and minutes that booking will take. Format: HH:MM
Paid	`paid`	`boolean`	Flag that says is the booking paid or not.
Confirmed	`confirmed`	`boolean`	Flag that says is the booking confirmed or not.
Round Trip	`roundTrip`	`boolean`	Flag that says is the booking a round trip or not.
Note	`note`	`string`	Note for the dispatcher.
Note for Driver	`noteForDriver`	`string`	Note for the driver.
Flight Number	`flightNumber`	`string`	Flight number for the booking.
Number of Waiting Hours	`numOfWaitingHours`	`integer`	Number of waiting hours.
Client ID	`clientId`	`string`	Select a value from the drop down menu.
Waiting Board Text	`waitingBoardText`	`string`	Text that will be places on the waiting board.
Baby Seat Count	`babySeatCount`	`integer`	Number of baby seats that will be used for the booking.
Suitcase Count	`suitcaseCount`	`integer`	Number of suitcases that will be used for the booking.
Checkpoints	`checkpoints`	`string[]`	List of objects of checkpoints location and time. Format: [{"location": { "name": string, "full_address": string, "coordinates": { "lat": number, "lng": number } }, "time": "01:14"}]
Passengers	`passengers`	`string[]`	List of objects of passengers. **Format: [{"first_name": string, "last_name": string, "phone": string, "email": string, "nationality": string, "passport": string, "country_id": UUID }]

Action Authentication#

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

About LimoExpress#

Livery Dispatch & Management Software

More Ways to Connect LimoExpress + AWS#

Other Popular Integrations#

Create Limo Booking with LimoExpress API on New Scheduled Tasks from AWS API

AWS + LimoExpress

Create Limo Booking with LimoExpress API on New Records Returned by CloudWatch Logs Insights Query from AWS API

Pipedream makes it easy to connect APIs for LimoExpress, AWS and 2,700+ other apps remarkably fast.

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

Developers ♥ Pipedream

1-24of2,700+apps by most popular

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