Retrieves sales invoices from a specific date

Request

Fetches sales invoices recorded from a given date onward.

Path

datestringrequired
The date in YYYY-MM-DD format.

Example: 2020-01-01
Default:

Query

limitinteger (int32)
Maximum number of results to return (default: 100).

Example: 1
Default: 100
offsetinteger (int32)
Offset for pagination (default: 0).

Example: 0
Default: 0

Responses

Returns the details of the business object

Body application/json

get /api/sales-invoices/from-date/{date}

curl -X GET \
  https://www.beehexa.com/_mock/api/sql-account-rest-api/customized-by-beehexa/api/sales-invoices/from-date/2020-01-01

const url = 'https://www.beehexa.com/_mock/api/sql-account-rest-api/customized-by-beehexa/api/sales-invoices/from-date/2020-01-01';
const options = {method: 'GET'};

try {
  const response = await fetch(url, options);
  const data = await response.json();
  console.log(data);
} catch (error) {
  console.error(error);
}

const fetch = require('node-fetch');

const url = 'https://www.beehexa.com/_mock/api/sql-account-rest-api/customized-by-beehexa/api/sales-invoices/from-date/2020-01-01';
const options = {method: 'GET'};

try {
  const response = await fetch(url, options);
  const data = await response.json();
  console.log(data);
} catch (error) {
  console.error(error);
}

import requests

url = "https://www.beehexa.com/_mock/api/sql-account-rest-api/customized-by-beehexa/api/sales-invoices/from-date/2020-01-01"

response = requests.get(url)

print(response.json())

OkHttpClient client = new OkHttpClient();

Request request = new Request.Builder()
  .url("https://www.beehexa.com/_mock/api/sql-account-rest-api/customized-by-beehexa/api/sales-invoices/from-date/2020-01-01")
  .get()
  .build();

Response response = client.newCall(request).execute();

using System.Net.Http.Headers;
var client = new HttpClient();
var request = new HttpRequestMessage
{
  Method = HttpMethod.Get,
  RequestUri = new Uri("https://www.beehexa.com/_mock/api/sql-account-rest-api/customized-by-beehexa/api/sales-invoices/from-date/2020-01-01"),
};
using (var response = await client.SendAsync(request))
{
  response.EnsureSuccessStatusCode();
  var body = await response.Content.ReadAsStringAsync();
  Console.WriteLine(body);
}

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://www.beehexa.com/_mock/api/sql-account-rest-api/customized-by-beehexa/api/sales-invoices/from-date/2020-01-01",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "GET",
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

package main

import (
	"fmt"
	"net/http"
	"io"
)

func main() {

	url := "https://www.beehexa.com/_mock/api/sql-account-rest-api/customized-by-beehexa/api/sales-invoices/from-date/2020-01-01"

	req, _ := http.NewRequest("GET", url, nil)

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(res)
	fmt.Println(string(body))

}

Response

application/json

[
  {
    "DOCKEY": 1,
    "DOCNO": "IV-00001",
    "DOCNOEX": "",
    "DOCDATE": "2024-06-11T00:00:00",
    "POSTDATE": "2024-06-11T00:00:00",
    "TAXDATE": "2024-06-11T00:00:00",
    "EIVDATETIME": "",
    "CODE": "300-T0001",
    "COMPANYNAME": "THAI TEA TRADING",
    "ADDRESS1": "No 45, Jalan Batu Tiga Klang,",
    "ADDRESS2": "42000, Pelabuhan Klang, Selangor.",
    "ADDRESS3": "",
    "ADDRESS4": "",
    "POSTCODE": "",
    "CITY": "",
    "STATE": "",
    "COUNTRY": "",
    "PHONE1": "03-3816 1027",
    "MOBILE": "",
    "EIV_UTC": "",
    "FAX1": "",
    "ATTENTION": "Mr. Leonard",
    "AREA": "Selangor",
    "AGENT": "Yuki",
    "PROJECT": "----",
    "TERMS": "60 Days",
    "CURRENCYCODE": "----",
    "CURRENCYRATE": 1,
    "SHIPPER": "----",
    "DESCRIPTION": "Sales",
    "CANCELLED": "F",
    "DOCAMT": 800,
    "LOCALDOCAMT": 800,
    "D_AMOUNT": 0,
    "VALIDITY": "",
    "DELIVERYTERM": "",
    "CC": "",
    "DOCREF1": "",
    "DOCREF2": "",
    "DOCREF3": "",
    "DOCREF4": "",
    "BRANCHNAME": "BILLING",
    "DADDRESS1": "No 45, Jalan Batu Tiga Klang,",
    "DADDRESS2": "42000, Pelabuhan Klang, Selangor.",
    "DADDRESS3": "",
    "DADDRESS4": "",
    "DPOSTCODE": "",
    "DCITY": "",
    "DSTATE": "",
    "DCOUNTRY": "",
    "DATTENTION": "Mr. Leonard",
    "DPHONE1": "03-3816 1027",
    "DMOBILE": "",
    "DFAX1": "",
    "TAXEXEMPTNO": "",
    "SALESTAXNO": "",
    "SERVICETAXNO": "",
    "TIN": "",
    "IDTYPE": 0,
    "IDNO": "",
    "TOURISMNO": "",
    "SIC": "",
    "INCOTERMS": "",
    "LASTMODIFIED": 1730460182,
    "SUBMISSIONTYPE": 0,
    "IRBM_STATUS": 0,
    "IRBM_INTERNALID": "",
    "IRBM_UUID": "",
    "IRBM_LONGID": "",
    "ATTACHMENTS": "",
    "NOTE": "",
    "TRANSFERABLE": "T",
    "UPDATECOUNT": "",
    "PRINTCOUNT": 0,
    "cdsDocDetail": [
      {
        "DTLKEY": 3,
        "DOCKEY_1": 1,
        "SEQ": 1000,
        "STYLEID": "",
        "NUMBER": "",
        "ITEMCODE": "RFC/Blue",
        "LOCATION": "----",
        "BATCH": "",
        "PROJECT_1": "----",
        "DESCRIPTION_1": "Ultra Soft Fluffy Rug Rectangle Carpet (Blue)",
        "DESCRIPTION2": "",
        "DESCRIPTION3": "",
        "PERMITNO": "",
        "QTY": 10,
        "UOM": "UNIT",
        "RATE": 1,
        "SQTY": 10,
        "SUOMQTY": 0,
        "UNITPRICE": 40,
        "DELIVERYDATE": "2024-06-11T00:00:00",
        "DISC": "",
        "TAX": "",
        "TARIFF": "",
        "TAXEXEMPTIONREASON": "",
        "IRBM_CLASSIFICATION": 22,
        "TAXRATE": "",
        "TAXAMT": 0,
        "LOCALTAXAMT": 0,
        "TAXINCLUSIVE": 0,
        "AMOUNT": 400,
        "LOCALAMOUNT": 400,
        "TAXABLEAMT": 400,
        "ACCOUNT": "500-500",
        "PRINTABLE": "T",
        "FROMDOCTYPE": "",
        "FROMDOCKEY": "",
        "FROMDTLKEY": "",
        "TRANSFERABLE_1": "T",
        "REMARK1": "",
        "REMARK2": "",
        "INITIALPURCHASECOST": 0
      },
      {
        "DTLKEY": 4,
        "DOCKEY_1": 1,
        "SEQ": 2000,
        "STYLEID": "",
        "NUMBER": "",
        "ITEMCODE": "RFC/Green",
        "LOCATION": "----",
        "BATCH": "",
        "PROJECT_1": "----",
        "DESCRIPTION_1": "Ultra Soft Fluffy Rug Rectangle Carpet (Green)",
        "DESCRIPTION2": "",
        "DESCRIPTION3": "",
        "PERMITNO": "",
        "QTY": 10,
        "UOM": "UNIT",
        "RATE": 1,
        "SQTY": 10,
        "SUOMQTY": 0,
        "UNITPRICE": 40,
        "DELIVERYDATE": "2024-06-11T00:00:00",
        "DISC": "",
        "TAX": "",
        "TARIFF": "",
        "TAXEXEMPTIONREASON": "",
        "IRBM_CLASSIFICATION": 22,
        "TAXRATE": "",
        "TAXAMT": 0,
        "LOCALTAXAMT": 0,
        "TAXINCLUSIVE": 0,
        "AMOUNT": 400,
        "LOCALAMOUNT": 400,
        "TAXABLEAMT": 400,
        "ACCOUNT": "500-500",
        "PRINTABLE": "T",
        "FROMDOCTYPE": "",
        "FROMDOCKEY": "",
        "FROMDTLKEY": "",
        "TRANSFERABLE_1": "T",
        "REMARK1": "",
        "REMARK2": "",
        "INITIALPURCHASECOST": 0
      }
    ]
  }
]

Retrieves sales invoices from a specific date

Request

Path

Query

Responses200400

Body application/json

Body application/json

Responses