The Ramp API provides programmatic access to financial and accounting functionalities, allowing for the management of company cards, transactions, and reporting. By leveraging the Ramp API within Pipedream, you can automate intricate finance operations, synchronize transaction data with accounting software, trigger notifications based on spending activities, and analyze financial data in real-time, integrating with other services for enhanced financial workflows.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
ramp: {
type: "app",
app: "ramp",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.ramp.com/developer/v1/business`,
headers: {
Authorization: `Bearer ${this.ramp.$auth.oauth_access_token}`,
},
})
},
})
Automated Expense Reporting: Automatically export new Ramp transactions into a Google Sheet or Airtable base for real-time expense tracking. This workflow can be set to trigger whenever a new transaction is detected, populating the sheet or base with transaction details, amounts, merchant names, and categories for easy reporting and analysis.
Receipt Matching and Reconciliation: Use the Ramp API to fetch transaction data and match receipts uploaded to a cloud storage platform like Dropbox or Google Drive. This can involve extracting receipt information through OCR (Optical Character Recognition) services and comparing it with transaction records to streamline the reconciliation process without manual data entry.
Real-time Alerts and Approvals: Create a workflow where you receive instant Slack notifications or emails when high-value transactions occur or when spend thresholds are approached. Further, implement approval workflows where managers receive a prompt to approve or reject proposed transactions via a Slack message or a custom-built approval interface on Pipedream.
Creates a new virtual card for a given user. See the documentation
Uploads a receipt for a given transaction and user. See the documentation
Ramp uses OAuth authentication. When you connect your Ramp account, Pipedream will open a popup window where you can sign into Ramp and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any Ramp API.
Pipedream requests the following authorization scopes when you connect your account:
transactions:read
cards:read
cards:write
spend_programs:read
spend_programs:write
users:read
users:write
locations:read
locations:write
limits:read
limits:write
departments:read
departments:write
business:read
receipts:read
transfers:read
vendors:read
merchants:read
accounting:read
receipts:write
GET
https://app.ramp.com/v1/authorize
?
client_id={{oauth.client_id}}
&
redirect_uri={{oauth.redirect_uri}}
&
state={{oauth.state}}
&
response_type=code
&
scope={{oauth.space_separated_scopes}}
POST
https://api.ramp.com/developer/v1/token
content-type: application/x-www-form-urlencoded
accept: application/json
redirect_uri={{oauth.redirect_uri}}
&
grant_type=authorization_code
&
code={{oauth.code}}
POST
https://api.ramp.com/developer/v1/token
content-type: application/x-www-form-urlencoded
accept: application/json
grant_type=refresh_token
&
refresh_token={{oauth.refresh_token}}