with Odoo and Open Exchange Rates?
Convert any money value from one currency to another. See the documentation
Get the latest exchange rates available. See the documentation
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();
},
})
The Open Exchange Rates API provides real-time and historical exchange rates for currencies worldwide, which enables you to retrieve the latest currency data for any purpose like financial reporting, pricing products in multiple currencies, or converting currency for international transactions. In Pipedream, you can tap into this API to create workflows that automate currency-related tasks, enrich data with current exchange rates, and trigger actions based on currency fluctuations.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
open_exchange_rates: {
type: "app",
app: "open_exchange_rates",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://openexchangerates.org/api/usage.json`,
params: {
app_id: `${this.open_exchange_rates.$auth.app_id}`,
},
})
},
})