Retrieves customer invoices from a specific date

Request

Fetches customer 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/customer-invoices/from-date/{date}

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

const url = 'https://www.beehexa.com/_mock/api/sql-account-rest-api/customized-by-beehexa/api/customer-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/customer-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/customer-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/customer-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/customer-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/customer-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/customer-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": "",
    "CODE": "300-T0001",
    "JOURNAL": "SALES",
    "DOCDATE": "2024-06-11T00:00:00",
    "POSTDATE": "2024-06-11T00:00:00",
    "TAXDATE": "2024-06-11T00:00:00",
    "TERMS": "60 Days",
    "DUEDATE": "2024-08-10T00:00:00",
    "DESCRIPTION": "Sales",
    "AREA": "Selangor",
    "AGENT": "Yuki",
    "PROJECT": "----",
    "CURRENCYCODE": "----",
    "CURRENCYRATE": 1,
    "DOCAMT": 800,
    "LOCALDOCAMT": 800,
    "PAYMENTAMT": 800,
    "FROMDOCTYPE": "IV",
    "TAXEXEMPTNO": "",
    "GLTRANSID": 1,
    "CANCELLED": "F",
    "UPDATECOUNT": "",
    "ATTACHMENTS": "",
    "NOTE": "",
    "LASTMODIFIED": 1730460182,
    "cdsDocDetail": [
      {
        "DTLKEY": 3,
        "DOCKEY_1": 1,
        "SEQ": 1000,
        "PROJECT_1": "----",
        "ACCOUNT": "500-500",
        "DESCRIPTION_1": "Ultra Soft Fluffy Rug Rectangle Carpet (Blue)",
        "TAX": "",
        "TARIFF": "",
        "TAXRATE": "",
        "TAXAMT": 0,
        "LOCALTAXAMT": 0,
        "TAXINCLUSIVE": 0,
        "AMOUNT": 400,
        "LOCALAMOUNT": 400,
        "TAXABLEAMT": 400,
        "FROMDTLKEY": 3
      },
      {
        "DTLKEY": 4,
        "DOCKEY_1": 1,
        "SEQ": 2000,
        "PROJECT_1": "----",
        "ACCOUNT": "500-500",
        "DESCRIPTION_1": "Ultra Soft Fluffy Rug Rectangle Carpet (Green)",
        "TAX": "",
        "TARIFF": "",
        "TAXRATE": "",
        "TAXAMT": 0,
        "LOCALTAXAMT": 0,
        "TAXINCLUSIVE": 0,
        "AMOUNT": 400,
        "LOCALAMOUNT": 400,
        "TAXABLEAMT": 400,
        "FROMDTLKEY": 4
      }
    ]
  }
]

Retrieves customer invoices from a specific date

Request

Path

Query

Responses200400

Body application/json

Body application/json

Responses