Update Results of Approved Invoices with QuickBooks Enterprise Response

Endpoint Name: updateqbestatus

Endpoint Details:This API is used to get the results of approved invoices which are approved by the approver of a company using date range filter, QBE status filter and username list.

Authorization: Bearer token as header

Request Type

Method	URL
POST	URL/access/klearstack/updateqbestatus

Request Body

Type	Params	Values	Description
POST	company_name	string	Name of the company
POST	username	string	Username for a particular user of a company
POST	password	string	Password for a particular user of a company
POST	document_type	string	Type of document to be processed - “Invoices”, “Receipts”, “PurchaseOrders”,“NACH”,“LoanAgreement” or “Insurances”. By default “Invoices” will be set if this parameter is not passed Note: Optional Parameter
POST	QBE_response	string	Response of Quickbook to particular invoice.This will be a string of Json. Ex. “{"document_id":"6073ff72de02f2c94bca9cef","QBE_status": "successful","error_message": "ErrMsg","QBE_timestamp":"14/04/2021 12:32:49"}“

Shell (cURL)

• Request Body

curl -X POST "URL/access/klearstack/updateqbestatus" \
  -H "Authorization: Bearer your_token_here" \
  -H "Content-Type: application/json" \
  -d '{
    "company_name": "Replace_Company_Name_Here",
    "username": "Replace_User_Name_Here",
    "password": "Replace_Password_Here",
    "document_type": "Invoices",
    "QBE_response": "{\"document_id\":\"6073ff72de02f2c94bca9cef\",\"QBE_status\": \"successful\",\"error_message\": \"ErrMsg\",\"QBE_timestamp\":\"14/04/2021 12:32:49\"}"
  }'

Python

• Request Body

import requests

# API URL
url = "URL/access/klearstack/updateqbestatus"

# Request payload
data = {
    "company_name": "Replace_Company_Name_Here",
    "username": "Replace_User_Name_Here",
    "password": "Replace_Password_Here",
    "document_type": "Invoices",
    "QBE_response": '{"document_id":"6073ff72de02f2c94bca9cef","QBE_status": "successful","error_message": "ErrMsg","QBE_timestamp":"14/04/2021 12:32:49"}'
}

# Headers
headers = {
    "Content-Type": "application/json",
    "Authorization": "Bearer your_token_here"
}

# Make the POST request
response = requests.post(url, json=data, headers=headers)

# Print the response
if response.status_code == 200:
    print(response.json())
else:
    print("Error:", response.text)

Java

• Request Body

import okhttp3.*;

import java.io.IOException;

public class UpdateQBEStatusAPI {
    public static void main(String[] args) {
        OkHttpClient client = new OkHttpClient();

        // JSON payload
        String jsonPayload = "{ \"company_name\": \"Replace_Company_Name_Here\", " +
                "\"username\": \"Replace_User_Name_Here\", " +
                "\"password\": \"Replace_Password_Here\", " +
                "\"document_type\": \"Invoices\", " +
                "\"QBE_response\": \"{\\\"document_id\\\":\\\"6073ff72de02f2c94bca9cef\\\",\\\"QBE_status\\\": \\\"successful\\\",\\\"error_message\\\": \\\"ErrMsg\\\",\\\"QBE_timestamp\\\":\\\"14/04/2021 12:32:49\\\"}\" }";

        RequestBody body = RequestBody.create(
            jsonPayload, MediaType.parse("application/json"));

        Request request = new Request.Builder()
            .url("URL/access/klearstack/updateqbestatus")
            .post(body)
            .addHeader("Content-Type", "application/json")
            .addHeader("Authorization", "Bearer your_token_here")
            .build();

        try (Response response = client.newCall(request).execute()) {
            if (response.isSuccessful()) {
                System.out.println("Response: " + response.body().string());
            } else {
                System.out.println("Error: " + response.body().string());
            }
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}

Node.js

• Request Body

var request = require('request');

const form_data = {
  'company_name': 'Replace_Company_Name_Here',
  'username': 'Replace_User_Name_Here',
  'password': 'Replace_Password_Here',
  'document_type': 'Invoices',
  'QBE_response': '{"document_id":"6073ff72de02f2c94bca9cef","QBE_status": "successful","error_message": "ErrMsg","QBE_timestamp":"14/04/2021 12:32:49"}'
};

const options = {
  url: 'URL/access/klearstack/updateqbestatus',
  json: form_data,
  headers: {
    'Content-Type': 'application/json',
    'Authorization': 'Bearer your_token_here'
  }
};

request.post(options, function(err, httpResponse, body) {
  if (err) {
    console.error('Request failed:', err);
    return;
  }

  console.log('Response:', body);
});

JavaScript (Browser)

• Request Body

var payload = JSON.stringify({
    company_name: "Replace_Company_Name_Here",
    username: "Replace_User_Name_Here",
    password: "Replace_Password_Here",
    document_type: "Invoices",
    QBE_response: "{\"document_id\":\"6073ff72de02f2c94bca9cef\",\"QBE_status\": \"successful\",\"error_message\": \"ErrMsg\",\"QBE_timestamp\":\"14/04/2021 12:32:49\"}"
});

var xhr = new XMLHttpRequest();
xhr.open("POST", "URL/access/klearstack/updateqbestatus", true);
xhr.setRequestHeader("Content-Type", "application/json");
xhr.setRequestHeader("Authorization", "Bearer your_token_here");

// Handle response
xhr.onreadystatechange = function () {
    if (xhr.readyState === XMLHttpRequest.DONE) {
        if (xhr.status === 200) {
            console.log("Response:", xhr.responseText);
        } else {
            console.error("Error:", xhr.responseText);
        }
    }
};

// Send request
xhr.send(payload);

API Response

Status	Example Response
200	“QBE status updated successfully”
200	if document id is not found. “Document ID not found”