Returns all expenses that correspond with the provided filters
https://api.constructiononline.com/Expenses?FILTERS={ExpenseInfo}
This endpoint allows users to extract all expenses from their ConstructionOnline company account that match the applied filter.
Requests
FILTER: JSON
- Each individual filter must be enclosed in curly brackets, while all compound filters should be enclosed in square brackets.
- Each individual filter can include an additional parameter: GT (greater than), LT (less than), GTE (greater than or equals to), LTE (less than or equals to), EQ (equals), NEQ (not equals), SW (starts with), EW (ends with), or CONTAINS. If no parameter is applied, the equals condition is used by default.
- Allowed properties in FILTERS: ID, TITLE, COMPANY_ID, PRJ_ID, DATE_CREATED, CREATED_BY, SUBTOTAL, TAX_PERCET, TAX_TYPE, TOTAL, AMOUNT_BILLED, AMOUNT_PAID, PAID, VENDOR_ID, LMOD, LMOD_BY, NOTES, TRADE, RECEIPT_STATUS, IS_EXPENSE, TRAFFIC_COLOR
Sample request URL:
- https://api.constructiononline.com/api/Expenses?FILTER=[{GT:{"TOTAL":"90000"}},{GTE:{"DATE_CREATED":"2024-09-15T00:00:00"}}]
cURL
# replace {email} with the email address for your ConstructionOnline account
# {password} with your ConstructionOnline password
# {apikey} with your provided API key
# {ExpenseInfo} with the filter requirements
curl https://api.constructiononline.com/api/Expenses?FILTER={ExpenseInfo} -u {email}:{password} -H 'APIKey:{apikey}'
C#
/* replace {username} with the email address for your ConstructionOnline account
{password} with your ConstructionOnline password
{apikey} with your provided API key
{ExpenseInfo} with the filter requirements */
public string GetData(string endpoint) {
string username = "{username}";
string password = "{password}";
string apikey = "{apikey}";
HttpResponseMessage response = null;
HttpClientHandler handler = new HttpClientHandler() { AutomaticDecompression = System.Net.DecompressionMethods.GZip };
using (HttpClient client = new HttpClient(handler)) {
client.Timeout = new TimeSpan(0, 0, 30);
client.BaseAddress = new Uri("http://api.constructiononline.com");
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Basic",
System.Convert.ToBase64String(System.Text.Encoding.GetEncoding("ISO-8859-1").GetBytes(username + ":" + password)));
client.DefaultRequestHeaders.Add("APIKey", apikey);
client.DefaultRequestHeaders.Add("Accept-Encoding", "gzip");
response = client.GetAsync(endpoint).Result;
}
return response?.Content.ReadAsStringAsync().Result;
}
MessageBox.Show(GetData("api/Expenses?FILTER={ExpenseInfo}"));
Python
#replace {username} with the email address for your ConstructionOnline account
#{password} with your ConstructionOnline password
#{apikey} with your provided API key
#{ExpenseInfo} with the filter requirements
import base64, requests, json
apikey = "{apikey}"
username = "{username}"
password = "{password}"
def makeRequest(endpoint):
url = "https://api.constructiononline.com/" + endpoint
userPass = username + ":" + password
headers = {
"APIKey": apikey,
"Accept-Encoding": "gzip, deflate, br",
"Authorization": "Basic " + base64.b64encode(userPass.encode()).decode(),
}
response = requests.get(url, headers=headers)
return json.dumps(json.loads(response.text), indent=2)
#Main Program
print(makeRequest("api/Expenses?FILTER={ExpenseInfo}"))
JavaScript
/* replace {username} with the email address for your ConstructionOnline account
{password} with your ConstructionOnline password
{apikey} with your provided API key
{ExpenseInfo} with the filter requirements */
username = '{username}';
password = '{password}';
apikey = '{apikey}';
function makeRequest(endpoint) {
auth = btoa('${username}:${password}');
var myHeaders = new Headers();
myHeaders.append("APIKey", apikey);
myHeaders.append("Accept-Encoding", "gzip, deflate, br");
myHeaders.append("Authorization", "Basic ${auth}");
var requestOptions = {
method: 'GET',
headers: myHeaders,
redirect: 'follow'
};
fetch("https://api.constructiononline.com/" + endpoint, requestOptions)
.then(response => response.text())
.then(result => console.log(result))
.catch(error => console.log('error', error));
return response;
};makeRequest("api/Expenses?FILTER={ExpenseInfo}");
Responses
200: Success
A successful request will return a 200 response with the requested expense in the body, as seen below. Definitions for all returned properties can be found here.
{ "ID": 27,
"TITLE": "Site Supervisor Labor - September",
"COMPANY_ID": 23573,
"PRJ_ID": 1432504,
"DATE_CREATED": "2024-09-23T08:16:42.517",
"CREATED_BY": 885048,
"SUBTOTAL": 15962.0,
"TAX_PERCENT": 0.0,
"TAX_TYPE": 0,
"TOTAL": 15962.0,
"AMOUNT_BILLED": 0.0,
"AMOUNT_PAID": 0.0,
"PAID": false,
"VENDOR_ID": 1055308,
"LMOD": "2024-09-23T13:16:42.517",
"LMOD_BY": 885048,
"NOTES": "",
"TRADE": 0,
"RECEIPT_STATUS": 105770,
"IS_EXPENSE": true,
"TRAFFIC_COLOR": 0,
"ITEMS": [
{
"ID": 52,
"PRJ_ID": 1432504,
"RECEIPT_ID": 27,
"NAME": "Hourly Wage",
"QTY": 160.0,
"UNIT": 266,
"RATE": 45.0,
"SUBTOTAL": 7200.0,
"TOTAL": 7200.0,
"TAX_TYPE_ID": 0,
"TAX_PERCENT": 0.0,
"AMOUNT_BILLED": 0.0,
"AMOUNT_BILLED_NO_TAX": 0.0,
"AMOUNT_PAID": 0.0,
"AMOUNT_PAID_NO_TAX": 0.0
},
{
"ID": 53,
"PRJ_ID": 1432504,
"RECEIPT_ID": 27,
"NAME": "Overtime Pay",
"QTY": 20.0,
"UNIT": 266,
"RATE": 67.5,
"SUBTOTAL": 1350.0,
"TOTAL": 1350.0,
"TAX_TYPE_ID": 0,
"TAX_PERCENT": 0.0,
"AMOUNT_BILLED": 0.0,
"AMOUNT_BILLED_NO_TAX": 0.0,
"AMOUNT_PAID": 0.0,
"AMOUNT_PAID_NO_TAX": 0.0
},
{
"ID": 54,
"PRJ_ID": 1432504,
"RECEIPT_ID": 27,
"NAME": "Per Diem",
"QTY": 20.0,
"UNIT": 266,
"RATE": 50.0,
"SUBTOTAL": 1000.0,
"TOTAL": 1000.0,
"TAX_TYPE_ID": 0,
"TAX_PERCENT": 0.0,
"AMOUNT_BILLED": 0.0,
"AMOUNT_BILLED_NO_TAX": 0.0,
"AMOUNT_PAID": 0.0,
"AMOUNT_PAID_NO_TAX": 0.0
},
{
"ID": 55,
"PRJ_ID": 1432504,
"RECEIPT_ID": 27,
"NAME": "Travel Expenses",
"QTY": 200.0,
"UNIT": 266,
"RATE": 0.56,
"SUBTOTAL": 112.0,
"TOTAL": 112.0,
"TAX_TYPE_ID": 0,
"TAX_PERCENT": 0.0,
"AMOUNT_BILLED": 0.0,
"AMOUNT_BILLED_NO_TAX": 0.0,
"AMOUNT_PAID": 0.0,
"AMOUNT_PAID_NO_TAX": 0.0
},
{
"ID": 56,
"PRJ_ID": 1432504,
"RECEIPT_ID": 27,
"NAME": "Accommodation Costs",
"QTY": 20.0,
"UNIT": 266,
"RATE": 120.0,
"SUBTOTAL": 2400.0,
"TOTAL": 2400.0,
"TAX_TYPE_ID": 0,
"TAX_PERCENT": 0.0,
"AMOUNT_BILLED": 0.0,
"AMOUNT_BILLED_NO_TAX": 0.0,
"AMOUNT_PAID": 0.0,
"AMOUNT_PAID_NO_TAX": 0.0
},
{
"ID": 57,
"PRJ_ID": 1432504,
"RECEIPT_ID": 27,
"NAME": "Administrative Costs",
"QTY": 20.0,
"UNIT": 266,
"RATE": 45.0,
"SUBTOTAL": 900.0,
"TOTAL": 900.0,
"TAX_TYPE_ID": 0,
"TAX_PERCENT": 0.0,
"AMOUNT_BILLED": 0.0,
"AMOUNT_BILLED_NO_TAX": 0.0,
"AMOUNT_PAID": 0.0,
"AMOUNT_PAID_NO_TAX": 0.0
},
{
"ID": 58,
"PRJ_ID": 1432504,
"RECEIPT_ID": 27,
"NAME": "Insurance",
"QTY": 1.0,
"UNIT": 266,
"RATE": 1000.0,
"SUBTOTAL": 1000.0,
"TOTAL": 1000.0,
"TAX_TYPE_ID": 0,
"TAX_PERCENT": 0.0,
"AMOUNT_BILLED": 0.0,
"AMOUNT_BILLED_NO_TAX": 0.0,
"AMOUNT_PAID": 0.0,
"AMOUNT_PAID_NO_TAX": 0.0
},
{
"ID": 59,
"PRJ_ID": 1432504,
"RECEIPT_ID": 27,
"NAME": "Equipment / Tools",
"QTY": 20.0,
"UNIT": 266,
"RATE": 100.0,
"SUBTOTAL": 2000.0,
"TOTAL": 2000.0,
"TAX_TYPE_ID": 0,
"TAX_PERCENT": 0.0,
"AMOUNT_BILLED": 0.0,
"AMOUNT_BILLED_NO_TAX": 0.0,
"AMOUNT_PAID": 0.0,
"AMOUNT_PAID_NO_TAX": 0.0
}
]
}
404: Error
The server was not able to locate the resource specified in the request.
429: Error
The user has surpassed the request rate limit for the hour, day, week, or month.
500: Error
There was an internal server error and the server was unable to complete the request.
Last updated: Oct 14, 2024