Import Expenses to Lawpractica

The Lawpractica Expense Import API allows for the seamless importation of existing expense data into Lawpractica. This functionality is designed specifically for developers looking to integrate or migrate expense information into Lawpractica efficiently.
Authentication Method
The API uses a Bearer token (API key) for authentication.
Obtaining Credentials
Credentials can be obtained from the Lawpractica application under the Integration tab in the Manage Settings form. Look for the Security Key value provided in the data exchange section.
Expense Import Endpoint
  • URL:
  • Method: POST
  • Description: Imports expense data into Lawpractica.
  • Request Headers:
    • Authorization: Bearer token (API key)
    • sd: Name of the user's subdomain (instance of the user application)
Request Body
Request body contains the requestor's information and an array of expenses to be imported.

Request body schema (JSON Schema) 
{
    "UserPrefix": "string",
    "UserFullName": "string",
    "UserEmail": "string",
    "ProfileCode": "string",
    "IsSendNotification": "integer",
    "NotificationEmail": "string",
    "NotificationCustomMessage": "string",
    "Expenses": [
    {       
        "ExpenseDate": "DateTime",
        "ExpenseFileNumber": "string",
        "ExpensePrefix": "string",
        "ExpenseReference": "string",
        "ExpenseCode": "string",
        "ExpenseGLCode": "string",
        "ExpenseDescription": "string",
        "ExpenseNetAmount": "decimal",
        "Tax1Amount": "decimal",
        "Tax2Amount": "decimal",
        "ExpenseBillable": "boolean",
        "ExpenseTaxable": "boolean",
        "ExpenseUI": "string",
        "ExpenseUpdDate": "DateTime?"
    }
  ]
}
Response Body
Response body contains a summary of the import operation and details of each expense processed.
  • Description:   A summary of the import operation, including the Import Request ID and the number of expenses successfully imported.
    TotalRecords: Total number of expense records processed.
    TotalInserted: Number of new expense records inserted during the import.
    TotalUpdated: Number of expense records updated during the import.
    TotalErrors:    Number of errors encountered during the import process.
    Expenses:         An array containing details of each expense processed.
    • id: Unique identifier of the expense record.
      >Other expense attributes.

      >importNotes: Descriptions of any errors encountered while importing the expense data.
      >importStatus: Indicates the status of the import operation for the expense record. It has the format "I-[id]" if the record was inserted, "U-[id]" if it was updated, where "id" is the record ID.


    • Response body schema (JSON Schema) 
    {
    "RequestID": "integer",
    "TotalRecords": "integer",
    "TotalUpdated": "integer",
    "TotalInserted": "integer",
    "TotalErrors": "integer",
    "Expenses": [
    {
        "ID": "string",
        "ExpenseDate": "DateTime",
        "ExpenseFileNumber": "string",
        "ExpensePrefix": "string",
        "ExpenseReference": "string",
        "ExpenseCode": "string",
        "ExpenseGLCode": "string",
        "ExpenseDescription": "string",
        "ExpenseNetAmount": "decimal",
        "Tax1Amount": "decimal",
        "Tax2Amount": "decimal",
        "ExpenseBillable": "boolean",
        "ExpenseTaxable": "boolean",
        "ExpenseUI": "string",
        "ExpenseUpdDate": "DateTime?",
        "ImportNotes": "string",
        "ImportStatus": "string"
    }
  ]
}
    • 400 Invalid JSON Format: The provided JSON information is invalid.
    • 411 User information cannot be empty: User information required for the operation is missing.
    • 411 API Key cannot be empty: API key required for authentication is missing.
    • 411 Subdomain cannot be empty: Subdomain information required for the operation is missing.
    • 411 Notification email cannot be empty (if IsSendNotification = 1): Notification email is required when notification is enabled.
    • 422 Invalid notification email format (if IsSendNotification=1): The format of the notification email is invalid.
    • 422 Invalid token: The provided token is invalid.
    • 500 Exception: An internal server error occurred.

    




                                                                 

    

    crossDomain: true,
    contentType: 'application/json; charset=utf-8',
    dataType: 'json',
    data: JSON.stringify(Expenses),
    headers: {
        'Authorization': 'Bearer ' + apiKey,
        'sd:' + subDomain,
        'Content-Type': 'application/json'
    }


    

var  Expenses =
{
    "UserPrefix": "BS",
    "UserFullName": "Brian Smith",
    "UserEmail": "info@lawpractica.com",
    "ProfileCode": "LP-DE",
    "IsSendNotification": "0",
    "NotificationEmail": "notification@example.com",
    "NotificationCustomMessage": "This is a custom notification message",
    "Expenses": [
    {
        "ExpenseDate": "2024-01-29",
        "ExpenseFileNumber": "EX-2024-001",
        "ExpenseReference": "Invoice #1234",
        "ExpenseCode": "OFFICE_SUPPLIES",
        "ExpenseGLCode": "1010",
        "ExpenseDescription": "Purchase of printer cartridges and paper",
        "ExpenseNetAmount": 75.42,
        "Tax1Amount": 6.03,
        "Tax2Amount": 0.00,
        "ExpenseBillable": true,
        "ExpenseTaxable": true,
        "ExpenseUI": "EXP0001",
        "ExpenseUpdDate": "2024-01-29T15:00:00"
    },
    {
        "ExpenseDate": "2024-01-30",
        "ExpenseFileNumber": "EX-2024-002",
        "ExpenseReference": "Travel Receipt",
        "ExpenseCode": "TRAVEL_TRANSPORT",
        "ExpenseGLCode": "5020",
        "ExpenseDescription": "Taxi fare to client meeting",
        "ExpenseNetAmount": 28.00,
        "Tax1Amount": 2.24,
        "Tax2Amount": 0.00,
        "ExpenseBillable": true,
        "ExpenseTaxable": true,
        "ExpenseUI": "EXP0002",
        "ExpenseUpdDate": "2024-01-29T15:00:00"
    }
  ]
}


    

200: function  () {
    console.log("200 - Success");
    },
                                                                
    //when any of info not supplied (without json object(ajax) either in URL parameters)
    
                                                                400: function  (request, status, error) {
    alert(error);
    },
                                                                
    //when any of supplied info is empty
    
                                                                411: function (request, status, error) {
    alert(error);
    },
                                                                
    //when the provided info is not invalid
    
                                                                422: function (request, status, error) {
    alert(error);
    },
                                                                500: function (request, status, error) {
    alert(error);
    }

    https://
    lawpractica.com

    Notes: Uses the logged-in Econveyance user information when making API requests..