capabilities.work

Locate Department Spend

A 3-step recipe with Ramp. We can help you get access.

Recipe · 3 steps

Locate Department Spend

with Ramp · Financial Management

List departments, users, and transactions to attribute spend by department.

  1. List the organization's departments to form the top level of the spend rollup.
  2. List users so each user's department_id can be joined to a department.
  3. List transactions for the date window so each transaction's user_id can be traced to a department for the spend rollup.
What you'll need to have ready
  • accessToken: OAuth2 client-credentials bearer token with departments:read, users:read, and transactions:read scopes.
  • fromDate: Inclusive lower bound for the transaction window (YYYY-MM-DD).
  • toDate: Inclusive upper bound for the transaction window (YYYY-MM-DD).
For your developer

Arazzo workflow ramp:locate-department-spend, 3 operations: listDepartments → listUsers → listTransactions. Specs on APIs.io.