Integrate the Odoo API with the Pipedream Utils API

Setup the Odoo API trigger to run a workflow which integrates with the Pipedream Utils API. Pipedream's integration platform allows you to integrate Odoo and Pipedream Utils remarkably fast. Free for developers.

Start for free — no credit card required

Watch a demo

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

Popular Odoo and Pipedream Utils Actions#

Formatting - [Data] Convert JSON to String with the Pipedream Utils API

Convert an object to a JSON format string

Try it

Formatting - [Data] Parse JSON with the Pipedream Utils API

Parse a JSON string

Try it

Formatting - [Date/Time] Add/Subtract Time with the Pipedream Utils API

Add or subtract time from a given input

Try it

Formatting - [Date/Time] Compare Dates with the Pipedream Utils API

Get the duration between two dates in days, hours, minutes, and seconds along with checking if they are the same.

Try it

Formatting - [Date/Time] Format with the Pipedream Utils API

Format a date string to another date string. For more examples on formatting, see the Sugar Date Format documentation.

Try it

Connect Odoo#

import xmlrpc from 'xmlrpc';

export default defineComponent({
  props: {
    odoo: {
      type: "app",
      app: "odoo",
    }
  },
  async run({ steps, $ }) {
    const url = this.odoo.$auth.server_url;
    const db = this.odoo.$auth.db;
    const username = this.odoo.$auth.username;
    const password = this.odoo.$auth.password;

    // Create clients for common and object endpoints
    const common = xmlrpc.createSecureClient(`${url}/xmlrpc/2/common`);
    const models = xmlrpc.createSecureClient(`${url}/xmlrpc/2/object`);

    // Using async/await with promises
    async function getFields() {
      try {
        // Authenticate and get uid
        const uid = await new Promise((resolve, reject) => {
          common.methodCall('authenticate', [db, username, password, {}], (error, value) => {
            if (error) reject(error);
            resolve(value);
          });
        });

        // Get fields
        const results = await new Promise((resolve, reject) => {
          models.methodCall('execute_kw', [
            db,
            uid,
            password,
            'res.partner',
            'fields_get',
            [],
            { 'attributes': ['string', 'help', 'type'] }
          ], (error, value) => {
            if (error) reject(error);
            resolve(value);
          });
        });
        return results;
      } catch (error) {
        throw new Error(error);
      }
    }

    return await getFields();
  },
})

Overview of Pipedream Utils#

The Pipedream Utils app is a set of pre-built functions that streamline common tasks in your workflows. It acts like a Swiss Army knife for developers, providing essential tools such as format conversion, date manipulation, and text processing. By leveraging these functions, you can reduce the boilerplate code needed for routine operations, speeding up the development of intricate automations. The Helper Functions API can be a game changer when it comes to tasks like parsing dates in user-friendly formats, encoding and decoding data, or generating UUIDs, making them more efficient and less error-prone.

Connect Pipedream Utils#

export default defineComponent({
  props: {
    pipedream_utils: {
      type: "app",
      app: "pipedream_utils",
    }
  },
  async run({steps, $}) {

  },
})

Start for free — no credit card required

Watch a demo