Accounting & ERP
Foundation is a comprehensive platform for job cost accounting, change orders, and project management. Using Agave, you can integrate with Foundation and dozens of other systems in hours using a single API.
| Customer Management | Read | Write |
|---|---|---|
| customers | ||
| Financials Management | Read | Write |
| AP invoices | ||
| AP payments | ||
| AR invoices | ||
| AR payments | ||
| assets | ||
| budget line items | ||
| change orders | ||
| cost codes | ||
| cost types | ||
| employees | ||
| job costs | ||
| items | ||
| ledger accounts | ||
| prime contracts | ||
| purchase orders | ||
| subcontracts | ||
| sub jobs (Phases) | ||
| tax codes | ||
| timecard entries | ||
| Project Management | Read | Write |
| contacts |
Available via Passthrough |
|
| projects | ||
| vendors | ||
| vendor compliances |
Available via Passthrough |
|
| Passthrough Requests | Read | Write |
| More Foundation data (without unified model) |
Agave has sandbox environments with sample data that you can use instead of spending time creating your own.
Agave provides unified models and access to source data. In addition, we even support passthrough requests, so you are never blocked by us.
curl https://api.agaveapi.com/projects \
# 3 headers that are consisttent
-H 'Api-Version: 2021-11-21' \
-H 'Client-Id: your-client-id' \
-H 'Client-Secret: your-client-secret' \
# Change the account token to request data from different accounts and different systems
-H 'Account-Token: foundation-example-account-token'
Consistent schema across all systems
{
"id": "ee9b53e7-f982-4be6-bc12-75f716d3ee94",
"source_id": "12345",
"address": {...},
"amount": 500000,
"completion_date": "2022-01-01",
"description": "123 Main Street residential project",
"logo_url": "https://storage.agaveapi.com/project-log.png?signature=xxx",
"name": "Test Project-1",
"number": "A123",
"start_date": "2022-01-01",
"status": "Active",
"type": "Residential",
"source_create_time": "2022-01-01T00:00:00Z",
"source_update_time": "2022-01-01T00:00:00Z"
}Get raw output from Foundation
{
"company_no": "1",
"job_no": "1",
"description": "Test Project-1",
"cost_code_method": "1",
"cost_basis": "U",
"certified_payroll": "N",
"job_status": "A",
"overhead_percent": ".0000000",
"county_no": null,
"tax_pr_no": "AKRON",
"customer_no": "2009",
"project_manager_no": "SR",
"geo_area_no": "100",
...
}
Option to call Foundation APIs directly
curl --request POST https://api.agaveapi.com/passthrough \
--header 'API-Version: 2021-11-21' \
--header 'Client-Id: your-client-id' \
--header 'Client-Secret: your-client-secret' \
--header 'Account-Token: foundation-account-token' \
--header 'Content-Type: application/json' \
--data-raw '{
"method": "GET",
"path": "/rest/v1.0/projects",
"data": { "company_id": 31936 }
}'