Create a Bill

Generate a new bill in your ConstructionOnline company account

post https://api.constructiononline.com/api/Bills?Info={billInfo}

This endpoint allows users to create a new bill for a project in their ConstructionOnline company account. If successful, the endpoint will return a record of the newly created bill. The new bill will be automatically assigned a unique numerical ID called 'ID', which will be used for any future references. The required fields for this endpoint include PRJ_ID, VENDOR_ID, and ITEMS (NAME and RATE); all other properties are optional and can be entered during bill creation.

Please note: bills can only be created for existing projects in ConstructionOnline. If a specific project ID is not included in the request, the bill creation will fail.

Requests

Info: JSON

  • Properties to be added to the bill.
  • Required properties for the bill: PRJ_ID, VENDOR_ID, ITEMS
    • Required properties for the bill ITEMS: NAME, RATE 
  • Allowed properties for the bill: TITLE, DUE_DATE, INVOICE_DATE, RECIEVED_DATE, ACTIVE, READY_FOR_PAYMENT, APPROVER, APPROVAL_DATE, NOTES, TRADE, BILL_TYPE, TRAFFIC_COLOR, LMOD, LMOD_BY, DATE_CREATED, CREATED_BY 
    • Allowed properties for the bill ITEMS: COST_CODE_ID, TAX_TYPE_ID, TAX_PERCENT, DESCRIPTION, QTY, UNIT

Individual properties for creation should be entered as JSON key-value pairs, as seen below:

{

"PRJ_ID": "1432504",
"VENDOR_ID" : "885048",
"DUE_DATE" : "2024-11-22T00:00:00",
"READY_FOR_PAYMENT" : "false",
"ITEMS" : [
{

"NAME" : "HVAC Labor",
"RATE" : "15000.00"
}
{
"NAME" : "HVAC Materials"
"RATE" : "62320.00"
}
]
}

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
# {billInfo} with the information for bill creation

curl -X POST https://api.constructiononline.com/api/Bills?Info={billInfo} -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
          {billInfo} with the information for bill creation */


public string MakeRequest(string endpoint, string payload) {
   string username = {username};
   string password = {password};
   string apiKey = {apikey};
   string response = "";
    var handler = new HttpClientHandler() { AutomaticDecompression = System.Net.DecompressionMethods.GZip };
        using (HttpClient client = new HttpClient(handler)) {
         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");
         HttpContent content = new StringContent(payload, System.Text.Encoding.UTF32, "application/json");
         response = client.PostAsync(endpoint, content).Result.ToString();
          }
    return response;
            }

   MakeRequest("api/Bills?Info={billInfo}");

Python

#replace {username} with the email address for your ConstructionOnline account
#{password} with your ConstructionOnline password
#{apikey} with your provided API key
#{billInfo} with the information for bill creation


import base64, requests, json
#Global Variables
apikey = {apikey}
username = {username}
password = {password}

#Functions
def makeRequest(endpoint, payload):
    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.request("POST", url, headers=headers, data=payload)
    return json.dumps(json.loads(response.text), indent=2)   
#Main Program
print(makeRequest("api/Bills?Info={billInfo}"))

JavaScript

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


 username = '{username}';
password = '{password}';
apikey = '{apikey}';

function makeRequest(endpoint, payload) {
        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: 'POST',
                    body: '',
                    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/Bills?Info={billInfo}");

Responses

green 200: Success

A successful request will return a 200 response with a record of the newly created bill in the body.

A sample response and property definitions can be found here.

red 404: Error

The server was not able to locate the resource specified in the request. 

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: Nov 5, 2024