Returns a list of trialBalance

Request

Security

oAuthoauth2 (OAuth 2.0)
OAuth2oauth2 (OAuth 2.0)

Path

company_idstring (uuid)required
(v1.0) id for company

Example: e942a270-62d2-4aef-aa48-6fe3ef9e53e1

Query

$topinteger
(v1.0) Number of items to return from the top of the list

Example: 100
$skipinteger
(v1.0) Number of items to skip from the list

Example: 0
$limitinteger
(v1.0) Number of items to return from the list

Example: 100
$filterstring
(v1.0) Filtering expression
$expandArray of strings
(v1.0) Entities to expand
$selectArray of strings
(v1.0) Selected properties to be retrieved

Responses

(v1.0) Succesfully returned a list of trialBalance

Body application/json

valueArray of objects (trialBalance)
Show 10 properties
- numberstring
  (v1.0) The number property for the Dynamics 365 Business Central trialBalance entity
  
  Example: 2a2dfc50-f21b-4ab0-8f89-463efd0dfce4
  <= 50 characters
- accountIdstring (uuid)
  (v1.0) The accountId property for the Dynamics 365 Business Central trialBalance entity
  
  Example: null
- accountTypestring
  (v1.0) The accountType property for the Dynamics 365 Business Central trialBalance entity
  
  Example: null
- displaystring
  (v1.0) The display property for the Dynamics 365 Business Central trialBalance entity
  
  Example: null
  <= 100 characters
- totalDebitstring
  (v1.0) The totalDebit property for the Dynamics 365 Business Central trialBalance entity
  
  Example: null
  <= 30 characters
- totalCreditstring
  (v1.0) The totalCredit property for the Dynamics 365 Business Central trialBalance entity
  
  Example: null
  <= 30 characters
- balanceAtDateDebitstring
  (v1.0) The balanceAtDateDebit property for the Dynamics 365 Business Central trialBalance entity
  
  Example: null
  <= 30 characters
- balanceAtDateCreditstring
  (v1.0) The balanceAtDateCredit property for the Dynamics 365 Business Central trialBalance entity
  
  Example: null
  <= 30 characters
- dateFilterstring (date-time)
  (v1.0) The dateFilter property for the Dynamics 365 Business Central trialBalance entity
  
  Example: null
- accountobject (account)
  Show 7 properties
  - idstring (uuid)
    (v1.0) The id property for the Dynamics 365 Business Central account entity
    
    Example: 2a2dfc50-f21b-4ab0-8f89-463efd0dfce4
  - numberstring
    (v1.0) The number property for the Dynamics 365 Business Central account entity
    
    Example: null
    <= 20 characters
  - displayNamestring
    (v1.0) The displayName property for the Dynamics 365 Business Central account entity
    
    Example: null
    <= 100 characters
  - categorystring
    (v1.0) The category property for the Dynamics 365 Business Central account entity
    
    Example: null
  - subCategorystring
    (v1.0) The subCategory property for the Dynamics 365 Business Central account entity
    
    Example: null
    <= 80 characters
  - blockedboolean
    (v1.0) The blocked property for the Dynamics 365 Business Central account entity
    
    Example: null
  - lastModifiedDateTimestring (date-time)
    (v1.0) The lastModifiedDateTime property for the Dynamics 365 Business Central account entity
    
    Example: null

get /companies({company_id})/trialBalance

curl -X GET \
  'https://www.beehexa.com/_mock/api/microsoft-dynamics-365-business-central-api/default-built-by-microsoft/companies(e942a270-62d2-4aef-aa48-6fe3ef9e53e1)/trialBalance' \
  -H 'Authorization: Bearer <YOUR_TOKEN_HERE>'

const url = 'https://www.beehexa.com/_mock/api/microsoft-dynamics-365-business-central-api/default-built-by-microsoft/companies(e942a270-62d2-4aef-aa48-6fe3ef9e53e1)/trialBalance';
const options = {method: 'GET', headers: {Authorization: 'Bearer <YOUR_TOKEN_HERE>'}};

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/microsoft-dynamics-365-business-central-api/default-built-by-microsoft/companies(e942a270-62d2-4aef-aa48-6fe3ef9e53e1)/trialBalance';
const options = {method: 'GET', headers: {Authorization: 'Bearer <YOUR_TOKEN_HERE>'}};

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/microsoft-dynamics-365-business-central-api/default-built-by-microsoft/companies(e942a270-62d2-4aef-aa48-6fe3ef9e53e1)/trialBalance"

headers = {"Authorization": "Bearer <YOUR_TOKEN_HERE>"}

response = requests.get(url, headers=headers)

print(response.json())

OkHttpClient client = new OkHttpClient();

Request request = new Request.Builder()
  .url("https://www.beehexa.com/_mock/api/microsoft-dynamics-365-business-central-api/default-built-by-microsoft/companies(e942a270-62d2-4aef-aa48-6fe3ef9e53e1)/trialBalance")
  .get()
  .addHeader("Authorization", "Bearer <YOUR_TOKEN_HERE>")
  .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/microsoft-dynamics-365-business-central-api/default-built-by-microsoft/companies(e942a270-62d2-4aef-aa48-6fe3ef9e53e1)/trialBalance"),
  Headers =
  {
    { "Authorization", "Bearer <YOUR_TOKEN_HERE>" },
  },
};
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/microsoft-dynamics-365-business-central-api/default-built-by-microsoft/companies(e942a270-62d2-4aef-aa48-6fe3ef9e53e1)/trialBalance",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "GET",
  CURLOPT_HTTPHEADER => [
    "Authorization: Bearer <YOUR_TOKEN_HERE>"
  ],
]);

$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/microsoft-dynamics-365-business-central-api/default-built-by-microsoft/companies(e942a270-62d2-4aef-aa48-6fe3ef9e53e1)/trialBalance"

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

	req.Header.Add("Authorization", "Bearer <YOUR_TOKEN_HERE>")

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

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

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

}

Response

application/json

{
  "value": [
    {
      "number": "2a2dfc50-f21b-4ab0-8f89-463efd0dfce4",
      "accountId": null,
      "accountType": null,
      "display": null,
      "totalDebit": null,
      "totalCredit": null,
      "balanceAtDateDebit": null,
      "balanceAtDateCredit": null,
      "dateFilter": null,
      "account": {}
    }
  ]
}

Returns a list of trialBalance

Request

Security

Path

Query

Responses200

Body application/json

Responses