Get projects created after a specific date

Returns all projects within your ConstructionOnline company account that were created after a specific date

get https://api.constructiononline.com/api/v2/Projects?fromDate={date}

This endpoint returns all projects that were recently created, using the entered date and current date to create a specific date range. All projects that were created on or beyond the entered date will be returned. A project's creation date is stored in the property 'DATE_CREATED'.

Requests

REQUIRED PARAMETERS

fromDate: date

  • Oldest creation date. All projects created on or after the date will be returned.
  • Should be entered in YYYY-MM-DD format. For example: October 14 2023 would be 2023-10-14.

Sample URL request:

  • https://api.constructiononline.com/api/v2/Projects?fromDate=2023-01-01

Example requests in cURL, C#, Python, and JavaScript can be found below:

cURL

# replace {email} with the email address for your ConstructionOnline account
# {password} with your ConstructionOnline password
# {apikey} with your provided API key
# {date} with the oldest creation date


curl https://api.constructiononline.com/api/v2/Projects?fromDate={date} -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
{date} with the oldest creation date */

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/v2/Projects?fromDate={date}"));

Python

#replace {username} with the email address for your ConstructionOnline account
#{password} with your ConstructionOnline password
#{apikey} with your provided API key
#{date} with the oldest creation date

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/v2/Projects?fromDate={date}"))

JavaScript

/* replace {username} with the email address for your ConstructionOnline account
{password} with your ConstructionOnline password
{apikey} with your provided API key
{date} with the oldest creation date */

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/v2/Projects?fromDate={date}");

Responses

green 200: Success

A successful request will return a 200 response with the requested projects in the body, as seen below. Definitions for all returned properties can be found here

{
      "ID": 1265198,
        "NAME": "Downtown Restaurant Relocation",
      "CREATED_BY": 988889,
      "CREATOR_NAME": "Alice Conway",
        "LMOD": "2022-08-04T14:30:56.223",
      "ADDRESS": "1222 E Samford St",
        "CITY": "Auburn",
        "STATE": "AL",
        "ZIP": "36830",
        "PROJECT_NUMBER": "",
      "LMOD_CON_ID": 985313,
      "IS_ARCHIVED": true,
        "CURRENCY": 0,
        "IS_TEMPLATE": false,
        "COUNTRY_SETTING": 1,
        "CUSTOM_COLOR": "#f4a8de",
      "COMPANY_ID": 20000,
        "IS_INACTIVE": false,
        "LAT": 32.479692,
        "LON": -85.499419,
        "SCOPE_OF_WORK": "%3Cp%3ELooking%20for%20a%20new%20restaurant%20space%2C%20wanting%20to%20expand.%26nbsp%3B%3C%2Fp%3E",
        "IS_UNGROUPED": false,
        "TOTAL_TIME": 0,
        "TOTAL_MONEY": 0.0,
        "PROJECT_NOTES": "",
        "NUMBERFOLDERS": 2,
        "NUMBERIMAGES": 0,
        "NUMBERALBUMS": 0,
        "NUMBERFILES": 0,
      "DATE_CREATED": "2022-01-17T16:09:29.94",
      "PROJECT_TYPE_CUSTOM": 390,
        "PROJECT_TYPE": "Commercial",
        "ATTACH_FOLDER_ID": null,
        "PERMISSION_FILES": 65535,
        "PERMISSION_CALENDAR": 3,
        "PERMISSIONS_TIME": 3,
        "PERMISSIONS_TODOS": 3,
        "PERMISSIONS_SCHEDULING": 3,
        "PERMISSIONS_PUNCHLISTS": 3,
        "PERMISSIONS_CHANGEORDERS": 3,
        "PERMISSIONS_SELECTIONS": 3,
        "PERMISSIONS_LOGGING": 3,
        "PERMISSIONS_RFIS": 3,
        "PERMISSIONS_TRANSMITTAL": 3,
        "PERMISSIONS_SUBMITTAL": 3,
        "ESTIMATE_UNQUALIFIED_COMMITS": null,
        "ESTIMATE_UNQUALIFIED_ACTUALS": null,
        "ESTIMATE_UNQUALIFIED_EXPENSES": null,
        "SELECTION_UNQUALIFIED_COMMITS": null,
        "SELECTION_UNQUALIFIED_ACTUALS": null,
        "SELECTION_UNQUALIFIED_EXPENSES": null,
        "CHANGE_ORDER_UNQUALIFIED_COMMITS": null,
        "CHANGE_ORDER_UNQUALIFIED_ACTUALS": null,
        "CHANGE_ORDER_UNQUALIFIED_EXPENSES": null,
        "PRIMARY_SCHEDULE": null,
        "COST_CODE_SET": 2,
        "JOBSITE_INSTRUCTIONS": "",
        "PROJECT_GROUP": 0,
        "PROJECT_STAGE": 1616,
        "PROJECT_CATEGORY": 0,
        "PROJECT_OFFICE": 0,
        "PROJECT_DIVISION": 0,
        "PROJECT_REGION": 0,
        "PERMISSIONS_ESTIMATING": 3,
        "PERMISSIONS_CHECKLISTS": 3
  }

red 404: Error

The server was not able to locate the resource specified in the request. The date may have been entered in a non-acceptable format, or no projects were created during the specified date range. 

red 429: Error

The user has surpassed the request rate limit for the hour, day, week, or month.

 red 500: Error

There was an internal server error and the server was unable to complete the request.

 

Last updated: Dec 28, 2023