businessreports/list

Get a list of all available business reports. This includes both the standard (default) reports as well as all your custom reports.

The result includes some properties that are required to correctly create a report, notably:

  • Does the report require specifying a date range?
  • Is there a report parameter and what are the available options?

URL

(GET) /api/businessreports/list

PARAMETERS

None.

RESULTS

The result is a JSON array. Each element represents a report and has these properties:

reportId

The unique ID of the report. The format is:

  • A default report is prefixed "S" such as in S500.
  • A custom report is prefixed with "C" such as in C1002
string
titleThe report title. string
descriptionOptional description of report. string
pinIndicates if this report is pinned by the user and moved to the top of the list. In the UI such reports are indicated with an orange star icon. bool
categoryIdThe numeric report category. Also see businessreports/categoriesint
categoryThe report category title. Also see businessreports/categoriesstring
colorOptional. HTML color code assigned to the report. Can be specified when creating/editing a custom report. string?
helpA URL to the online documentation describing customization.string




USED FOR REPORT CREATION
needDateSelectorSpecifies if a from/to date range must be supplied when creating this report. Most reports expect a date range but some do not.bool
options

Some reports when created allow to specify an option to choose a variant. This property is then the list of available options.

For example, the "Client and supplier costs" report proposes these options:

"options": [
                {
                    "v": "",
                    "t": "Filter by project creation or completion date"
                },
                {
                    "v": "CREATED",
                    "t": "Filter by project creation date"
                },
                {
                    "v": "RECEIVED",
                    "t": "Filter by project reception date"
                },
                {
                    "v": "INPROGRESS",
                    "t": "Filter by project start date"
                },
                {
                    "v": "DONE",
                    "t": "Filter by project completion date"
                }
            ]

When you create this report you can optionally pass the value in the "v" property. 

The first element is the default value.

object[]
canClone

Specifies if it is possible to create a custom report based on this default report.

Deprecated or older reports may not be "clonable".

bool




OTHER
deprecatedSome reports should no longer be used and are flagged as deprecated (also in the Wordbee Translator user interface).bool
systemReportId

With custom reports only. Indicates the standard report from which this custom report is derived. Note that this number omits the "S" prefix.

int?
customReportId

With custom reports only. The ID without the "C" prefix.

int?


EXAMPLE

A report with options:

{
	"reportId": "S107",
	"systemReportId": 107,
	"systemReportTitle": null,
	"customReportId": null,
	"category": "Financial",
	"title": "Client and supplier costs - By language",
	"help": "https://wordbee.atlassian.net/wiki/spaces/WBT/pages/712138/Report+S107+-+Client+and+supplier+costs+-+By+language",
	"description": "Shows client and supplier invoice amounts grouped by source and target language. Perfect to review benefit and loss individually per source and target language.",
	"categoryid": 1,
	"pin": false,
	"needDateSelector": true,
	"options": [
		{
			"v": "",
			"t": "Filter by project creation or completion date"
		},
		{
			"v": "CREATED",
			"t": "Filter by project creation date"
		},
		{
			"v": "RECEIVED",
			"t": "Filter by project reception date"
		},
		{
			"v": "INPROGRESS",
			"t": "Filter by project start date"
		},
		{
			"v": "DONE",
			"t": "Filter by project completion date"
		},
		{
			"v": "ONEINV",
			"t": "All projects with an invoice date in interval"
		}
	],
	"color": null,
	"deprecated": false,
	"canClone": true
}







Copyright Wordbee - Buzzin' Outside the Box since 2008