with Expensify and Open Exchange Rates?
Convert any money value from one currency to another. See the documentation
Creates a new report with transactions in a user's account. See docs here
Export Expensify reports to a file (csv, xls, xlsx, txt, pdf, json, xml). See the documentation
The Expensify API enables the automation of expense reporting and management tasks. By harnessing this API within Pipedream, you can craft workflows that streamline the expense submission process, synchronize financial data across platforms, and trigger actions based on expense report statuses. With Pipedream’s serverless platform, these automations can run in the background, allowing for real-time data processing and interaction between Expensify and a myriad of other apps and services.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
expensify: {
type: "app",
app: "expensify",
}
},
async run({ steps, $ }) {
// The Expensify API requires the request data to be sent as
// a URL-encoded form with a key of "requestJobDescription".
// The value of this key must be a JSON string.
// First, define the JSON object as per the Expensify API documentation.
const requestJobDescription = {
type: "get",
credentials: {
partnerUserID: this.expensify.$auth.partnerUserId,
partnerUserSecret: this.expensify.$auth.partnerUserSecret,
},
inputSettings: {
type: "policyList",
}
};
// Use URLSearchParams to create a properly formatted form body.
const formData = new URLSearchParams();
formData.append('requestJobDescription', JSON.stringify(requestJobDescription));
// Make the API call with the correctly formatted data.
return await axios($, {
method: "post",
url: `https://integrations.expensify.com/Integration-Server/ExpensifyIntegrations`,
data: formData,
// It's good practice to explicitly set the Content-Type header
// to match the data format.
headers: {
'Content-Type': 'application/x-www-form-urlencoded',
},
});
},
})
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}`,
},
})
},
})