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 |
Ready in December Available via Pass-through |
Ready in December |
AR invoices |
Available via Pass-through |
|
assets (Equipment) |
Available via Pass-through |
|
budget line items (Estimates) | ||
change orders |
Available via Pass-through |
|
compliance codes (Vendor Certificates) |
Available via Pass-through |
|
cost codes | ||
cost types (Categories) | ||
employees | ||
items |
Ready in December Available via Pass-through |
|
ledger accounts (Account) | ||
purchase orders |
Ready in November Available via Pass-through |
Ready in December |
sales tax codes |
Ready in November Available via Pass-through |
|
subcontracts | ||
timecard entries (Daily Payroll) |
Available via Pass-through |
|
Project Management | Read | Write |
projects (Jobs) |
Ready in November |
|
RFIs |
Available via Pass-through |
|
submittals |
Available via Pass-through |
|
transmittals |
Available via Pass-through |
|
vendors (AP Vendors) | ||
Pass-through 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 pass-through 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 }
}'