← Zoho Projects + OANDA integrations

Get Historical Prices with OANDA API on New Log Time from Zoho Projects API

Pipedream makes it easy to connect APIs for OANDA, Zoho Projects and 3,000+ other apps remarkably fast.

Trigger workflow on
New Log Time from the Zoho Projects API
Next, do this
Get Historical Prices with the OANDA API
No credit card required
Intro to Pipedream
Watch us build a workflow
Watch us build a workflow
8 min
Watch now ➜

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

Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo
Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo

Developers Pipedream

Getting Started

This integration creates a workflow with a Zoho Projects trigger and OANDA action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

  1. Select this integration
  2. Configure the New Log Time trigger
    1. Connect your Zoho Projects account
    2. Configure Polling schedule
    3. Select a Portal ID
    4. Select a Project ID
    5. Select a View Type
    6. Configure Date
    7. Select a Bill Status
  3. Configure the Get Historical Prices action
    1. Connect your OANDA account
    2. Configure Is Demo
    3. Select a Account ID
    4. Configure Instrument Name
    5. Configure Start Time
    6. Configure End Time
    7. Optional- Configure Price
    8. Optional- Select a Granularity
    9. Optional- Configure Smooth
    10. Optional- Configure Include First
    11. Optional- Configure Daily Alignment
    12. Optional- Configure Alignment Timezone
    13. Optional- Select a Weekly Alignment
    14. Optional- Configure Units
  4. Deploy the workflow
  5. Send a test event to validate your setup
  6. 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

Description:Emit new event when a log time is created. [See the docs here](https://www.zoho.com/projects/help/rest-api/log-time.html#alink1)
Version:0.0.3
Key:zoho_projects-new-log-time

Zoho Projects Overview

The Zoho Projects API lets you harness the full potential of project management by enabling seamless integration with other tools and automating routine tasks. With it, you can create projects, manage tasks, track time, and customize your workflow. On Pipedream, you can leverage this API to build robust automations that connect Zoho Projects with a plethora of other apps, streamlining project tracking and collaboration workflows, all without writing a single line of code.

Trigger Code

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

export default {
  ...common,
  key: "zoho_projects-new-log-time",
  name: "New Log Time",
  description: "Emit new event when a log time is created. [See the docs here](https://www.zoho.com/projects/help/rest-api/log-time.html#alink1)",
  type: "source",
  version: "0.0.3",
  dedupe: "unique",
  props: {
    ...common.props,
    portalId: {
      propDefinition: [
        common.props.zohoProjects,
        "portalId",
      ],
    },
    projectId: {
      propDefinition: [
        common.props.zohoProjects,
        "projectId",
        ({ portalId }) => ({
          portalId,
        }),
      ],
    },
    viewType: {
      type: "string",
      label: "View Type",
      description: "View type of the timesheet must be provided as day or week or month or custom_date",
      options: [
        {
          label: "Day",
          value: "day",
        },
        {
          label: "Week",
          value: "week",
        },
        {
          label: "Month",
          value: "month",
        },
        {
          label: "Custom Date",
          value: "custom_date",
        },
      ],
    },
    date: {
      type: "string",
      label: "Date",
      description: "Date of the timesheet view type. E.g. (`[MM-DD-YYYY]`)",
    },
    billStatus:	{
      type: "string",
      label: "Bill Status",
      description: "Timesheet billable status must be provided as `All`, `Billable` or `Non Billable`.",
      options: [
        "All",
        "Billable",
        "Non Billable",
      ],
    },
  },
  methods: {
    ...common.methods,
    getResourceName() {
      return "timelogs";
    },
    getResourceFn() {
      return this.zohoProjects.getLogs;
    },
    getResourceFnArgs() {
      const {
        portalId,
        projectId,
        viewType,
        date,
        billStatus,
      } = this;
      return {
        portalId,
        projectId,
        params: {
          users_list: "all",
          view_type: viewType,
          date,
          bill_status: billStatus,
          component_type: "general",
        },
      };
    },
    resourceFilter(resource) {
      const lastCreatedAt = this.getLastCreatedAt() || 0;
      return resource.created_time_long > lastCreatedAt;
    },
    generateMeta(resource) {
      return {
        id: resource.id_string,
        ts: resource.created_time_long,
        summary: `TimeLog ID ${resource.id_string}`,
      };
    },
  },
};

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.
LabelPropTypeDescription
Zoho ProjectszohoProjectsappThis component uses the Zoho Projects app.
N/Adb$.service.dbThis component uses $.service.db to maintain state between executions.
Polling scheduletimer$.interface.timer

How often to poll the Zoho Projects API

Portal IDportalIdstringSelect a value from the drop down menu.
Project IDprojectIdstringSelect a value from the drop down menu.
View TypeviewTypestringSelect a value from the drop down menu:{ "label": "Day", "value": "day" }{ "label": "Week", "value": "week" }{ "label": "Month", "value": "month" }{ "label": "Custom Date", "value": "custom_date" }
Datedatestring

Date of the timesheet view type. E.g. ([MM-DD-YYYY])

Bill StatusbillStatusstringSelect a value from the drop down menu:AllBillableNon Billable

Trigger Authentication

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

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

ZohoProjects.portals.allZohoProjects.projects.allZohoProjects.activities.createZohoProjects.status.readZohoProjects.milestones.allZohoProjects.tasklists.allZohoProjects.tasks.allZohoProjects.timesheets.allZohoProjects.bugs.allZohoProjects.tags.allZohoProjects.events.allZohoProjects.forums.allZohoProjects.users.allZohoProjects.documents.CREATEZohoPC.files.CREATEZohoProjects.search.readZohoProjects.documents.READWorkDrive.team.ALLWorkDrive.workspace.ALLWorkDrive.files.ALL

About Zoho Projects

Online Project Management Software & Tools

Action

Description:Retrieve historical price data for a specified currency pair or instrument within a given time range. [See the documentation](https://developer.oanda.com/rest-live-v20/pricing-ep/)
Version:0.0.3
Key:oanda-get-historical-prices

OANDA Overview

The OANDA API enables you to tap into the world of forex trading, providing real-time currency exchange rates, and the ability to automate trading strategies, manage accounts, access market data, and more. On Pipedream, you can craft workflows that capitalize on OANDA's capabilities, such as reacting to market changes, automating trades based on custom logic, and syncing forex data with other business applications for analysis and decision-making.

Action Code

import oanda from "../../oanda.app.mjs";
import constants from "../../common/constants.mjs";
import { ConfigurationError } from "@pipedream/platform";

export default {
  key: "oanda-get-historical-prices",
  name: "Get Historical Prices",
  description: "Retrieve historical price data for a specified currency pair or instrument within a given time range. [See the documentation](https://developer.oanda.com/rest-live-v20/pricing-ep/)",
  version: "0.0.3",
  annotations: {
    destructiveHint: false,
    openWorldHint: true,
    readOnlyHint: true,
  },
  type: "action",
  props: {
    oanda,
    isDemo: {
      propDefinition: [
        oanda,
        "isDemo",
      ],
    },
    accountId: {
      propDefinition: [
        oanda,
        "accountId",
        (c) => ({
          isDemo: c.isDemo,
        }),
      ],
    },
    instrument: {
      propDefinition: [
        oanda,
        "instrument",
      ],
    },
    startTime: {
      type: "string",
      label: "Start Time",
      description: "The start time for historical price data (ISO 8601 format). E.g. `2025-04-01T04:00:00.000000000Z`",
    },
    endTime: {
      type: "string",
      label: "End Time",
      description: "The end time for historical price data (ISO 8601 format). E.g. `2025-04-01T04:00:00.000000000Z`",
    },
    price: {
      type: "string",
      label: "Price",
      description: "The Price component(s) to get candlestick data for. Can contain any combination of the characters “M” (midpoint candles) “B” (bid candles) and “A” (ask candles).",
      optional: true,
    },
    granularity: {
      type: "string",
      label: "Granularity",
      description: "The granularity of the candlesticks to fetch",
      options: constants.CANDLE_GRANULARITIES,
      optional: true,
    },
    smooth: {
      type: "boolean",
      label: "Smooth",
      description: "A flag that controls whether the candlestick is “smoothed” or not. A smoothed candlestick uses the previous candle’s close price as its open price, while an unsmoothed candlestick uses the first price from its time range as its open price.",
      optional: true,
    },
    includeFirst: {
      type: "boolean",
      label: "Include First",
      description: "A flag that controls whether the candlestick that is covered by the from time should be included in the results. This flag enables clients to use the timestamp of the last completed candlestick received to poll for future candlesticks but avoid receiving the previous candlestick repeatedly.",
      optional: true,
    },
    dailyAlignment: {
      type: "integer",
      label: "Daily Alignment",
      description: "The hour of the day (in the specified timezone) to use for granularities that have daily alignments. minimum=0, maximum=23",
      optional: true,
    },
    alignmentTimezone: {
      type: "string",
      label: "Alignment Timezone",
      description: "The timezone to use for the dailyAlignment parameter. Candlesticks with daily alignment will be aligned to the dailyAlignment hour within the alignmentTimezone. Note that the returned times will still be represented in UTC. [default=America/New_York]",
      optional: true,
    },
    weeklyAlignment: {
      type: "string",
      label: "Weekly Alignment",
      description: "The day of the week used for granularities that have weekly alignment. [default=Friday]",
      options: constants.WEEKLY_ALIGNMENT_DAYS,
      optional: true,
    },
    units: {
      type: "integer",
      label: "Units",
      description: "The number of units used to calculate the volume-weighted average bid and ask prices in the returned candles. [default=1]",
      optional: true,
    },
  },
  async run({ $ }) {
    try {
      const response = await this.oanda.getHistoricalPrices({
        $,
        isDemo: this.isDemo,
        accountId: this.accountId,
        instrument: this.instrument,
        params: {
          price: this.price,
          granularity: this.granularity,
          from: this.startTime,
          to: this.endTime,
          smooth: this.smooth,
          includeFirst: this.includeFirst,
          dailyAlignment: this.dailyAlignment,
          alignmentTimezone: this.alignmentTimezone,
          weeklyAlignment: this.weeklyAlignment,
          units: this.units,
        },
      });
      $.export("$summary", `Successfully retrieved ${response.candles.length} trade${response.candles.length === 1
        ? ""
        : "s"}`);
      return response;
    } catch (error) {
      if (error?.message.includes("Maximum value for 'count' exceeded")) {
        throw new ConfigurationError("Maximum results exceeded. Update the time range or granularity to return fewer results.");
      } else {
        console.error("Error retrieving historical prices:", error);
        throw error;
      }
    }
  },
};

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.

LabelPropTypeDescription
OANDAoandaappThis component uses the OANDA app.
Is DemoisDemoboolean

Set to true if using a demo/practice account

Account IDaccountIdstringSelect a value from the drop down menu.
Instrument Nameinstrumentstring

The instrument to filter the requested Trades by. E.g. AUD_USD

Start TimestartTimestring

The start time for historical price data (ISO 8601 format). E.g. 2025-04-01T04:00:00.000000000Z

End TimeendTimestring

The end time for historical price data (ISO 8601 format). E.g. 2025-04-01T04:00:00.000000000Z

Pricepricestring

The Price component(s) to get candlestick data for. Can contain any combination of the characters “M” (midpoint candles) “B” (bid candles) and “A” (ask candles).

GranularitygranularitystringSelect a value from the drop down menu:{ "value": "S5", "label": "5 second candlesticks, minute alignment" }{ "value": "S10", "label": "10 second candlesticks, minute alignment" }{ "value": "S15", "label": "15 second candlesticks, minute alignment" }{ "value": "S30", "label": "30 second candlesticks, minute alignment" }{ "value": "M1", "label": "1 minute candlesticks, minute alignment" }{ "value": "M2", "label": "2 minute candlesticks, hour alignment" }{ "value": "M4", "label": "4 minute candlesticks, hour alignment" }{ "value": "M5", "label": "5 minute candlesticks, hour alignment" }{ "value": "M10", "label": "10 minute candlesticks, hour alignment" }{ "value": "M15", "label": "15 minute candlesticks, hour alignment" }{ "value": "M30", "label": "30 minute candlesticks, hour alignment" }{ "value": "H1", "label": "1 hour candlesticks, hour alignment" }{ "value": "H2", "label": "2 hour candlesticks, day alignment" }{ "value": "H3", "label": "3 hour candlesticks, day alignment" }{ "value": "H4", "label": "4 hour candlesticks, day alignment" }{ "value": "H6", "label": "6 hour candlesticks, day alignment" }{ "value": "H8", "label": "8 hour candlesticks, day alignment" }{ "value": "H12", "label": "12 hour candlesticks, day alignment" }{ "value": "D", "label": "1 day candlesticks, day alignment" }{ "value": "W", "label": "1 week candlesticks, aligned to start of week" }{ "value": "M", "label": "1 month candlesticks, aligned to first day of the month" }
Smoothsmoothboolean

A flag that controls whether the candlestick is “smoothed” or not. A smoothed candlestick uses the previous candle’s close price as its open price, while an unsmoothed candlestick uses the first price from its time range as its open price.

Include FirstincludeFirstboolean

A flag that controls whether the candlestick that is covered by the from time should be included in the results. This flag enables clients to use the timestamp of the last completed candlestick received to poll for future candlesticks but avoid receiving the previous candlestick repeatedly.

Daily AlignmentdailyAlignmentinteger

The hour of the day (in the specified timezone) to use for granularities that have daily alignments. minimum=0, maximum=23

Alignment TimezonealignmentTimezonestring

The timezone to use for the dailyAlignment parameter. Candlesticks with daily alignment will be aligned to the dailyAlignment hour within the alignmentTimezone. Note that the returned times will still be represented in UTC. [default=America/New_York]

Weekly AlignmentweeklyAlignmentstringSelect a value from the drop down menu:MondayTuesdayWednesdayThursdayFridaySaturdaySunday
Unitsunitsinteger

The number of units used to calculate the volume-weighted average bid and ask prices in the returned candles. [default=1]

Action Authentication

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

About OANDA

OANDA is a global leader in online multi-asset trading services, currency data, corporate payments and FX services.

More Ways to Connect OANDA + Zoho Projects

Create Order with OANDA API on New Bug from Zoho Projects API
Zoho Projects + OANDA
 
Try it
Create Order with OANDA API on New Log Time from Zoho Projects API
Zoho Projects + OANDA
 
Try it
Create Order with OANDA API on New Milestone from Zoho Projects API
Zoho Projects + OANDA
 
Try it
Create Order with OANDA API on New Project from Zoho Projects API
Zoho Projects + OANDA
 
Try it
Create Order with OANDA API on New Task List from Zoho Projects API
Zoho Projects + OANDA
 
Try it
New Bug from the Zoho Projects API

Emit new event when a new bug is created. See the docs here

 
Try it
New Log Time from the Zoho Projects API

Emit new event when a log time is created. See the docs here

 
Try it
New Milestone from the Zoho Projects API

Emit new event when a new milestone is created. See the docs here

 
Try it
New Project from the Zoho Projects API

Emit new event when a new project is created. See the docs here

 
Try it
New Task from the Zoho Projects API

Emit new event when a new task is created. See the docs here

 
Try it
Add Log Time with the Zoho Projects API

Add Time for a General Log. Adds the time log to other tasks. See the docs here

 
Try it
Create Bug with the Zoho Projects API

Creates a bug. See the docs here

 
Try it
Create Milestone with the Zoho Projects API

Creates a milestone. See the docs here

 
Try it
Create Project with the Zoho Projects API

Creates a project. See the docs here

 
Try it
Create Task with the Zoho Projects API

Creates a task. See the docs here

 
Try it

Explore Other Apps

1
-
24
of
3,000+
apps by most popular

Node
Node
Anything you can do with Node.js, you can do in a Pipedream workflow. This includes using most of npm's 400,000+ packages.
Python
Python
Anything you can do in Python can be done in a Pipedream Workflow. This includes using any of the 350,000+ PyPi packages available in your Python powered workflows.
Notion
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.
OpenAI (ChatGPT)
OpenAI (ChatGPT)
OpenAI is an AI research and deployment company with the mission to ensure that artificial general intelligence benefits all of humanity. They are the makers of popular models like ChatGPT, DALL-E, and Whisper.
Anthropic (Claude)
Anthropic (Claude)
AI research and products that put safety at the frontier. Introducing Claude, a next-generation AI assistant for your tasks, no matter the scale.
Google Sheets
Google Sheets
Use Google Sheets to create and edit online spreadsheets. Get insights together with secure sharing in real-time and from any device.
Telegram
Telegram
Telegram, is a cloud-based, cross-platform, encrypted instant messaging (IM) service.
Google Drive
Google Drive
Google Drive is a file storage and synchronization service which allows you to create and share your work online, and access your documents from anywhere.
HTTP / Webhook
HTTP / Webhook
Get a unique URL where you can send HTTP or webhook requests
Google Calendar
Google Calendar
With Google Calendar, you can quickly schedule meetings and events and get reminders about upcoming activities, so you always know what’s next.
Schedule
Schedule
Trigger workflows on an interval or cron schedule.
Pipedream Utils
Pipedream Utils
Utility functions to use within your Pipedream workflows
Shopify
Shopify
Shopify is a complete commerce platform that lets anyone start, manage, and grow a business. You can use Shopify to build an online store, manage sales, market to customers, and accept payments in digital and physical locations.
Supabase
Supabase
Supabase is an open source Firebase alternative.
MySQL
MySQL
MySQL is an open-source relational database management system.
PostgreSQL
PostgreSQL
PostgreSQL is a free and open-source relational database management system emphasizing extensibility and SQL compliance.
AWS
AWS
Premium
Amazon Web Services (AWS) offers reliable, scalable, and inexpensive cloud computing services.
Twilio SendGrid
Twilio SendGrid
Premium
Send marketing and transactional email through the Twilio SendGrid platform with the Email API, proprietary mail transfer agent, and infrastructure for scalable delivery.
Amazon SES
Amazon SES
Amazon SES is a cloud-based email service provider that can integrate into any application for high volume email automation
Klaviyo
Klaviyo
Premium
Klaviyo unifies your data, channels, and AI agents in one platform—text, WhatsApp, email marketing, and more—driving growth with every interaction.
Zendesk
Zendesk
Premium
Zendesk is award-winning customer service software trusted by 200K+ customers. Make customers happy via text, mobile, phone, email, live chat, social media.
ServiceNow
ServiceNow
Premium
Beta
The smarter way to workflow
Slack
Slack
Slack is the AI-powered platform for work bringing all of your conversations, apps, and customers together in one place. Around the world, Slack is helping businesses of all sizes grow and send productivity through the roof.
Microsoft Teams
Microsoft Teams
Microsoft Teams has communities, events, chats, channels, meetings, storage, tasks, and calendars in one place.