Accounting & ERP
Sage 300 CRE is a construction ERP solution with tools for accounting, project management, and much more. Using Agave, you can integrate with Sage 300 CRE and dozens of other systems in hours using a single API.
| Customer Management | Read | Write |
|---|---|---|
| customers (AR Customers) | ||
| Financials Management | Read | Write |
| AP invoices | ||
| AP payments | ||
| AR invoices | ||
| AR payments | ||
| assets (Equipment) |
Available via Passthrough |
|
| budget line items (Estimates) | ||
| change orders | ||
| compliance codes (Vendor Certificates) |
Available via Passthrough |
|
| cost codes | ||
| cost types (Categories) | ||
| employees | ||
| items | ||
| job costs | ||
| ledger accounts (Account) | ||
| prime contracts (Contracts) | ||
| purchase orders (Commitments) | ||
| sales tax codes (Tax Groups) | ||
| sub jobs (Extras) | ||
| subcontracts (Commitments) | ||
| timecard entries (Daily Payroll) |
Available via Passthrough |
|
| Project Management | Read | Write |
| contacts (Customer Contacts) | ||
| projects (Jobs) | ||
| RFIs |
Available via Passthrough |
|
| submittals |
Available via Passthrough |
|
| transmittals |
Available via Passthrough |
|
| vendors (AP Vendors) | ||
| Passthrough Requests | Read | Write |
| More Sage 300 CRE 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: sage-300-cre-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 Sage 300 CRE
{
"JCCo": "12345",
"Job": " A123",
"Description": "Test Project-1",
"Contract": "12345",
"JobStatus": "1",
"BidNumber": null,
"LockPhases": "N",
"ProjectMgr": null,
"JobPhone": null,
"JobFax": null,
"MailAddress": "123 Main Street",
"MailCity": "AnyTown",
"MailState": "CA",
...
}
Option to call Sage 300 CRE 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: sage-300-cre-account-token' \
--header 'Content-Type: application/json' \
--data-raw '{
"method": "GET",
"path": "/rest/v1.0/projects",
"data": { "company_id": 31936 }
}'