Get
[POST] .../v1/widgetdata/get
Returns data for one widget. Use this method after Widget/Get to load the live data payload for a selected dashboard widget. The result field is widget-specific: public OpenAPI lists the typed WidgetDataType payloads and Integration returns validated integration-defined chart JSON or an empty chart-compatible object. Additional typed payloads include InventoryValuation as WidgetDataType20, wholesale widgets as WidgetDataType21 through WidgetDataType24, project task widgets as WidgetDataType25 through WidgetDataType27, CRM lead widgets as WidgetDataType28 through WidgetDataType30, CRM deal widgets as WidgetDataType31 through WidgetDataType33 and CRM ticket widgets as WidgetDataType34 through WidgetDataType35. The request body is required and id must be a positive widget id; the method loads the widget, its dashboard filters, optional widget filters, the dashboard period and cached data where supported before returning the widget-specific result. Stock-scoped widgets apply the widget/dashboard company and warehouse filters together with the current user's warehouse access; users without warehouse-specific restrictions are evaluated across the selected or all active warehouses. The current implementation does not perform a separate permission check for most widget types, so callers should pass widget ids obtained through the dashboard assignment workflow; project task widgets use project task select permission and apply the project/task ACL, CRM widgets use the corresponding CRM lead, deal or ticket select permission and apply CRM pipeline or ticket ACL, while InventoryValuation hides quantity, cost or price blocks as null when the current user does not have the corresponding item quantity, last purchase cost or item price permission. Business errors such as missing body, invalid id, missing widget or dashboard, unsupported widget type, connected integration lookup failures, disabled or unsupported integration handler, permission lookup failures, database errors and cache/data lookup failures are returned as HTTP 200 ErrorResult.
Request Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| filters | Array of Filter | Optional | Optional filters by fields available for this API method. |
Filterable Fields
| Field | Type | Description |
|---|---|---|
| id | int | Record ID. |
Request Example
{
"filters": [
{
"Field": "id",
"Operator": "Equal",
"Value": "15"
}
]
}
Response Parameters
| Name | Type | Description |
|---|---|---|
| ok | Boolean | Indicates whether the request completed successfully. |
| result | Array of WidgetDataType1 / Array of WidgetDataType3 / WidgetDataType4 / Array of WidgetDataType5 / WidgetDataType6 / Array of WidgetDataType7 / Array of WidgetDataType8 / Array of WidgetDataType9 / Array of WidgetDataType10 / Array of WidgetDataType11 / Array of WidgetDataType12 / Array of WidgetDataType13 / Array of WidgetDataType14 / Array of WidgetDataType15 / WidgetDataType16 / Array of WidgetDataType17 / Array of WidgetDataType18 / WidgetDataType20 / WidgetDataType21 / Array of WidgetDataType22 / Array of WidgetDataType23 / Array of WidgetDataType24 / WidgetDataType25 / Array of WidgetDataType26 / Array of WidgetDataType27 / WidgetDataType28 / Array of WidgetDataType29 / Array of WidgetDataType30 / WidgetDataType31 / Array of WidgetDataType32 / Array of WidgetDataType33 / WidgetDataType34 / Array of WidgetDataType35 / Object | Widget data payload. The concrete shape depends on widget_type; Integration returns integration-defined chart JSON. |
Response Example
{
"ok": true,
"result": {
"item_count": 125,
"quantity": {
"common": 8432.5,
"booked": 120.0,
"allowed": 8312.5
},
"cost": {
"amount": 120000000.0
},
"prices": [
{
"price_type_id": 1,
"price_type_name": "Retail",
"currency_id": 1,
"currency_code": "UZS",
"currency_name": "Uzbek sum",
"exchange_rate": 1.0,
"amount": 180000000.0
}
]
}
}
Response Payload Schemas
WidgetDataType1
Data for widget types 1 and 2: personal and global targets.
| Name | Type | Description |
|---|---|---|
| id | Int64 | Target ID. |
| name | String | Target name. |
| percent | Int64 | Target progress percentage. |
| progress | Decimal | Target progress. |
| value | Decimal | Target value. |
WidgetDataType3
Data for widget type 3: accounts.
| Name | Type | Description |
|---|---|---|
| currency_name | String | Account currency name. |
| name | String | Account name. |
| value | Decimal | Account balance. |
WidgetDataType4
Data for widget type 4: retail orders.
| Name | Type | Description |
|---|---|---|
| new | Int64 | New retail order count. |
| total | Int64 | Total quantity. |
WidgetDataType5
Data for widget type 5: cash registers.
| Name | Type | Description |
|---|---|---|
| id | Int64 | Cash register ID. |
| name | String | Cash register name. |
WidgetDataType6
Data for widget type 6: sales statistics for the current day.
| Name | Type | Description |
|---|---|---|
| average_receipt_amount | Decimal | Average cheque amount. |
| gross_profit | Decimal | Gross profit (total_amount - last_purchase_cost_amount). |
| markup_avg_in_percent | Decimal | Average markup percentage: (total_amount - last_purchase_cost_amount) / last_purchase_cost_amount * 100. |
| operating_cash_avg_down_time | Decimal | Average cash register operating time in seconds (SUM(sls_date - sls_start_date)). |
| operating_cash_avg_work_time | Decimal | Average cash register operating time in seconds (SUM(sls_end_date - sls_start_date)). |
| receipt_count | Int64 | Cheques count. |
| refund_amount | Decimal | Return amount. |
| refund_count | Int64 | Number of return cheques. |
| refund_pos_count | Int64 | Number of line items in return cheques. |
| refund_unit_count | Int64 | Number of returned units. |
| sales_amount | Decimal | Sales amount. |
| sales_amount_per_square_meter | Decimal | Sales amount per square meter (total_amount / SUM(area)). |
| sales_count | Int64 | Sales cheque count. |
| sales_pos_count | Int64 | Number of line items in sale cheques. |
| sales_unit_count | Int64 | Number of sold units. |
| total_amount | Decimal | Total amount. |
WidgetDataType7
Data for widget type 7: payment statistics for the current day.
| Name | Type | Description |
|---|---|---|
| amount | Decimal | Amount. |
| id | Int64 | Payment type ID. |
| name | String | Payment type. |
WidgetDataType8
Data for widget type 8: retail sales amount turnover dynamics for the week.
| Name | Type | Description |
|---|---|---|
| amount | Decimal | Amount. |
| date | String | Date. |
WidgetDataType9
Data for widget type 9: top 10 selling retail items by quantity for 7 days including the current day.
| Name | Type | Description |
|---|---|---|
| code | Int64 | Item code. |
| id | Int64 | Item ID. |
| image_url | String | Image URL. |
| name | String | Item name. |
| quantity | Decimal | Quantity. |
WidgetDataType10
Data for widget type 10: top 10 selling retail items by amount for 7 days including the current day.
| Name | Type | Description |
|---|---|---|
| amount | Decimal | Quantity. |
| code | Int64 | Item code. |
| id | Int64 | Item ID. |
| image_url | String | Image URL. |
| name | String | Item name. |
WidgetDataType11
Data for widget type 11: retail customers with upcoming birthdays, 5 days in advance.
| Name | Type | Description |
|---|---|---|
| date | String | Customer birthday. |
| id | Int64 | Customer ID. |
| name | String | Customer first name. |
| phone | String | Customer contact number. |
WidgetDataType12
Data for widget type 12: top 10 preferred purchases by customer cards, by quantity and amount according to system settings.
| Name | Type | Description |
|---|---|---|
| customer_id | Int64 | Customer ID. |
| customer_name | String | Customer first name. |
| customer_phone | String | Customer phone number. |
| image_url | String | Image URL. |
| item_code | Int64 | Item code. |
| item_id | Int64 | Item ID. |
| item_name | String | Item name. |
| value | Decimal | Value. |
WidgetDataType13
Data for widget type 13: top 10 partner debts in base currency.
| Name | Type | Description |
|---|---|---|
| debt_amount | Decimal | Debt amount. |
| id | Int64 | Partner ID. |
| last_payment | String | Last payment date. |
| name | String | Partner name. |
WidgetDataType14
Data for widget type 14: customer age distribution for 7 days including the current day.
| Name | Type | Description |
|---|---|---|
| age | String | Customer age. |
| count | Int64 | Sales cheque count. |
WidgetDataType15
Data for widget type 15: customer distribution by gender for 7 days including the current day.
| Name | Type | Description |
|---|---|---|
| count | Int64 | Sales cheque count. |
| sex | String | Customer gender. Allowed values: none, male, female. |
WidgetDataType16
Data for widget type 16: tariff information.
| Name | Type | Description |
|---|---|---|
| data_display_period | Int32 | Data display period. |
| name | String | Tariff name. |
| name_var | String | Tariff name variable. |
| paid_until | String | Paid until. |
| pay_discount_percent | Int32 | Payment discount percentage. |
| pay_period | Int32 | Payment frequency in months. |
| price | Decimal | Tariff cost for one month without discount. |
| service_data | Array of WidgetDataType16Data | Service data. |
| services_price | Decimal | Cost of all tariff services for one month without discount. |
| tariff_id | Int32 | Tariff ID. |
WidgetDataType16Data
Additional widget data.
| Name | Type | Description |
|---|---|---|
| in_use | Int64 | Used. |
| name_var | String | Name, stored as a translation variable. |
| quantity | Int64 | Quantity. |
WidgetDataType17
Data for widget type 17: top 10 retail customer debts in base currency.
| Name | Type | Description |
|---|---|---|
| debt_amount | Decimal | Debt amount. |
| id | Int64 | Partner ID. |
| last_payment | String | Last payment date. |
| name | String | Partner name. |
WidgetDataType18
Data for widget type 18: sales activity.
| Name | Type | Description |
|---|---|---|
| data | Array of WidgetDataType18HourData | Hourly sales activity values for the day. |
| day | String | Day of week. Allowed values: Default, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday. |
WidgetDataType18HourData
Hourly sales activity value.
| Name | Type | Description |
|---|---|---|
| hour | Int32 | Hour (0 - 23). |
| value | Int32 | Value (number of cheques). |
WidgetDataType20
Data for widget type 20: current inventory quantity and valuation.
| Name | Type | Description |
|---|---|---|
| cost | WidgetDataType20Cost | Inventory valuation by last purchase cost. null means that the caller has no last purchase cost permission or no item quantity permission. |
| item_count | Int64 | Number of item records with non-zero current common quantity. null means that the caller has no item quantity permission. |
| prices | Array of WidgetDataType20Price | Inventory valuation by price type with current exchange rates. null means that the caller has no item price permission or no item quantity permission. |
| quantity | WidgetDataType20Quantity | Current inventory quantity totals. null means that the caller has no item quantity permission. |
WidgetDataType20Quantity
Current inventory quantity totals for widget type 20.
| Name | Type | Description |
|---|---|---|
| allowed | Decimal | Total available quantity calculated as common minus booked. |
| booked | Decimal | Total booked quantity. |
| common | Decimal | Total current common quantity. |
WidgetDataType20Cost
Inventory valuation by last purchase cost for widget type 20.
| Name | Type | Description |
|---|---|---|
| amount | Decimal | Total current common quantity multiplied by the last purchase cost in the base currency. |
WidgetDataType20Price
Inventory valuation by one price type for widget type 20.
| Name | Type | Description |
|---|---|---|
| amount | Decimal | Total current common quantity multiplied by item prices and the current exchange rate. |
| currency_code | String | Price type currency alphabetic code. |
| currency_id | Int64 | Price type currency ID. |
| currency_name | String | Price type currency name. |
| exchange_rate | Decimal | Exchange rate used to convert the price type amount to the base currency. |
| price_type_id | Int64 | Price type ID. |
| price_type_name | String | Price type name. |
WidgetDataType21
Data for widget type 21: wholesale sales and return statistics for the selected period.
| Name | Type | Description |
|---|---|---|
| average_document_amount | Decimal | Average wholesale document amount in the base currency. |
| document_count | Int64 | Total wholesale document count. |
| gross_profit | Decimal | Gross profit in the base currency: net wholesale amount minus last purchase cost amount. |
| markup_avg_in_percent | Decimal | Average markup percentage: gross profit divided by last purchase cost amount. |
| refund_amount | Decimal | Wholesale return amount in the base currency. |
| refund_count | Int64 | Wholesale return document count. |
| refund_pos_count | Int64 | Number of line items in wholesale return documents. |
| refund_unit_count | Decimal | Number of returned units in wholesale return documents. |
| sales_amount | Decimal | Wholesale shipment amount in the base currency. |
| sales_count | Int64 | Wholesale shipment document count. |
| sales_pos_count | Int64 | Number of line items in wholesale shipment documents. |
| sales_unit_count | Decimal | Number of shipped units in wholesale shipment documents. |
| total_amount | Decimal | Net wholesale amount in the base currency: sales minus returns. |
WidgetDataType22
Data for widget type 22: wholesale sales amount turnover dynamics by day.
| Name | Type | Description |
|---|---|---|
| amount | Decimal | Net wholesale amount in the base currency for the date. |
| date | String | Date. |
WidgetDataType23
Data for widget type 23: top 10 wholesale items by net quantity.
| Name | Type | Description |
|---|---|---|
| code | Int64 | Item code. |
| id | Int64 | Item ID. |
| image_url | String | Image URL. |
| name | String | Item name. |
| quantity | Decimal | Net quantity: shipments minus returns. |
WidgetDataType24
Data for widget type 24: top 10 wholesale items by net amount.
| Name | Type | Description |
|---|---|---|
| amount | Decimal | Net amount in the base currency: shipments minus returns. |
| code | Int64 | Item code. |
| id | Int64 | Item ID. |
| image_url | String | Image URL. |
| name | String | Item name. |
WidgetDataType25
Data for widget type 25: project task status and due-date statistics for the current request user.
| Name | Type | Description |
|---|---|---|
| assigned_to_me | Int64 | Open task count assigned to the current request user. |
| canceled_in_period | Int64 | Task count canceled during the selected dashboard period. |
| created_by_me | Int64 | Open task count created by the current request user. |
| created_in_period | Int64 | Task count created during the selected dashboard period. |
| done_in_period | Int64 | Task count completed during the selected dashboard period. |
| due_today | Int64 | Open task count due today. |
| due_tomorrow | Int64 | Open task count due tomorrow. |
| in_progress | Int64 | In-progress open task count. |
| new | Int64 | New open task count. |
| observing | Int64 | Open task count where the current request user is an observer. |
| open | Int64 | Open task count: New plus InProgress. |
| overdue | Int64 | Open task count with due date earlier than today. |
| without_due_date | Int64 | Open task count without due date. |
WidgetDataType26
Data row for widget type 26: top projects by open task count.
| Name | Type | Description |
|---|---|---|
| open | Int64 | Open task count in the project. |
| overdue | Int64 | Overdue open task count in the project. |
| project_id | Int64 | Project ID. |
| project_name | String | Project name. |
WidgetDataType27
Data row for widget type 27: nearest open project tasks ordered by due date.
| Name | Type | Description |
|---|---|---|
| due_date | Int64 | Due date as Unix time in seconds. |
| id | Int64 | Task ID. |
| name | String | Task name. |
| project_id | Int64 | Project ID. |
| project_name | String | Project name. |
| responsible_user_id | Int64 | Responsible user ID. |
| status | String | Task status. Allowed values: Default, New, InProgress, Done, Canceled. |
WidgetDataType28
Data for widget type 28: CRM lead status and SLA statistics for records visible to the current request user.
| Name | Type | Description |
|---|---|---|
| assigned_to_me | Int64 | Active lead count assigned to the current request user. |
| closed_in_period | Int64 | Lead count closed without conversion during the selected dashboard period. |
| converted_in_period | Int64 | Lead count converted to deals during the selected dashboard period. |
| created_in_period | Int64 | Lead count created during the selected dashboard period. |
| in_progress | Int64 | In-progress active lead count. |
| new | Int64 | New active lead count. |
| open | Int64 | Active lead count: New plus InProgress plus WaitingClient. |
| participating | Int64 | Active lead count where the current request user is a participant. |
| sla_breached | Int64 | Active lead count with breached SLA. |
| waiting_client | Int64 | Lead count waiting for the client. |
WidgetDataType29
Data row for widget type 29: top CRM lead stages by active lead count.
| Name | Type | Description |
|---|---|---|
| open | Int64 | Active lead count in the stage. |
| pipeline_id | Int64 | Pipeline ID. |
| pipeline_name | String | Pipeline name. |
| stage_id | Int64 | Stage ID. |
| stage_name | String | Stage name. |
WidgetDataType30
Data row for widget type 30: top CRM lead pipelines by active lead count.
| Name | Type | Description |
|---|---|---|
| open | Int64 | Active lead count in the pipeline. |
| pipeline_id | Int64 | Pipeline ID. |
| pipeline_name | String | Pipeline name. |
| sla_breached | Int64 | Active lead count with breached SLA in the pipeline. |
WidgetDataType31
Data for widget type 31: CRM deal amount and conversion statistics for records visible to the current request user.
| Name | Type | Description |
|---|---|---|
| assigned_to_me | Int64 | Open deal count assigned to the current request user. |
| avg_won_amount | Decimal | Average won deal amount in the base currency for the selected dashboard period. |
| created_in_period_amount | Decimal | Deal amount in the base currency for deals opened during the selected dashboard period. |
| created_in_period_count | Int64 | Deal count opened during the selected dashboard period. |
| lost_in_period_amount | Decimal | Lost deal amount in the base currency for deals closed during the selected dashboard period. |
| lost_in_period_count | Int64 | Lost deal count closed during the selected dashboard period. |
| open_amount | Decimal | Open deal amount in the base currency. |
| open_count | Int64 | Open deal count. |
| participating | Int64 | Open deal count where the current request user is a participant. |
| win_rate | Decimal | Won share percentage among deals closed as Won or Lost during the selected dashboard period. |
| won_in_period_amount | Decimal | Won deal amount in the base currency for deals closed during the selected dashboard period. |
| won_in_period_count | Int64 | Won deal count closed during the selected dashboard period. |
WidgetDataType32
Data row for widget type 32: top CRM deal stages by open deal count.
| Name | Type | Description |
|---|---|---|
| open_amount | Decimal | Open deal amount in the base currency for the stage. |
| open_count | Int64 | Open deal count in the stage. |
| pipeline_id | Int64 | Pipeline ID. |
| pipeline_name | String | Pipeline name. |
| stage_id | Int64 | Stage ID. |
| stage_name | String | Stage name. |
WidgetDataType33
Data row for widget type 33: top CRM deal types by open deal amount.
| Name | Type | Description |
|---|---|---|
| deal_type_id | Int64 | Deal type ID. |
| deal_type_name | String | Deal type name. |
| open_amount | Decimal | Open deal amount in the base currency for the deal type. |
| open_count | Int64 | Open deal count for the deal type. |
WidgetDataType34
Data for widget type 34: CRM ticket status and SLA statistics for records visible to the current request user.
| Name | Type | Description |
|---|---|---|
| assigned_to_me | Int64 | Open ticket count assigned to the current request user. |
| closed_in_period | Int64 | Ticket count closed during the selected dashboard period. |
| created_in_period | Int64 | Ticket count created during the selected dashboard period. |
| first_response_overdue | Int64 | Open ticket count with an overdue first-response SLA and no first response. |
| inbound_open | Int64 | Open inbound ticket count. |
| missed | Int64 | Missed ticket count resolved during the selected dashboard period. |
| open | Int64 | Open ticket count: Open plus WaitingClient plus WaitingStaff. |
| outbound_open | Int64 | Open outbound ticket count. |
| participating | Int64 | Open ticket count where the current request user is a participant. |
| resolve_overdue | Int64 | Open ticket count with an overdue resolution SLA. |
| sla_breached | Int64 | Open ticket count with breached SLA. |
| waiting_client | Int64 | Ticket count waiting for the client. |
| waiting_staff | Int64 | Ticket count waiting for staff. |
WidgetDataType35
Data row for widget type 35: nearest open CRM tickets ordered by SLA due date.
| Name | Type | Description |
|---|---|---|
| channel_id | Int64 | Channel ID. |
| client_id | Int64 | Client ID. |
| client_name | String | Client name, or null if the linked client is unavailable. |
| due_date | Int64 | SLA due date as Unix time in seconds. |
| id | Int64 | Ticket ID. |
| responsible_user_id | Int64 | Responsible user ID. |
| sla_type | String | SLA kind selected for ordering. Values are FirstResponse or Resolve. |
| status | String | Ticket status. Allowed values: Default, Open, Closed, WaitingClient, WaitingStaff. |
| subject | String | Ticket subject. |