Daftra API
All Endpoints
Daftra PartnersDevelopers Portal
All Endpoints
Daftra PartnersDevelopers Portal
  1. Sales Revenue Report
  • Welcome
  • Getting Started
  • Authorization
    • How To Authorize
    • Generate Access Token
  • Endpoints
    • Site
      • GET Site Info
    • Sales
      • Validation Errors
      • Invoices
        • GET All Invoices
        • GET Single Invoice
        • Edit Invoice
        • Delete Invoice
        • Add New Invoice
        • Bulk Add Invoices
        • Edit Invoice Draft Status
        • Assign Work Order to Invoice
        • Add Shipping to Invoice
        • Convert Sales Order to Invoice
        • Delete Sales Order
      • Subsciptions
        • List Subscriptions
        • View Subscription
        • Create Subscription
        • Edit Subscription
        • Delete Subscription
      • Estimates
        • GET All Estimates
        • GET Single Estimate
        • Add New Estimate
        • Edit Estimate
        • Delete Estimate
      • Credit Notes
        • GET All Credit Notes
        • GET Single Credit Note
        • Add New Credit Note
        • Edit Credit Notes
        • Delete Credit Notes
      • Refund Receipts
        • GET All Refund Receipts
        • GET Single Refund Receipt
        • Add New Refund Receipt
        • Edit Refund Receipts
        • Delete Refund Receipts
        • Bulk Add Refund Receipts
      • Invoice Payments
        • GET All Invoice Payments
        • GET Single Invoice Payment
        • Add New Invoice Payment
        • Edit Invoice Payments
        • Delete Invoice Payments
      • Invoice Appointments
        • GET All Invoice Appointments
        • GET Single Invoice Appointment
        • Add New Invoice Appointment
        • Edit Invoice Appointments
        • Delete Invoice Appointments
      • Advance Payment Invoices
        • GET All Advance payment
        • GET Single Advance payment
        • Add Advance Payment
      • Estimate Appointments
        • GET All Estimate Appointments
        • GET Single Estimate Appointment
        • Add New Estimate Appointment
        • Edit Estimate Appointments
        • Delete Estimate Appointments
        • Update Estimate Appointment (POST alias)
      • Shipping Options
        • List Shipping Options
      • POS
        • Get POS Shift Session
      • Follow-Up Status
        • Get All Follow-Up Statuses by type
        • Get Single Follow-Up Status
        • Delete Follow-Up Status
        • Get All Follow-Up Statuses
        • Add New Follow-Up Status
    • Clients
      • Clients
        • GET All Clients
        • GET Single Client
        • Add New Client
        • Edit Clients
        • Delete Clients
        • Assign Staff To Client
        • Client Loyalty Points
        • Bulk Add Clients
        • Client Has Membership
        • Client Attendance By Barcode
      • Client Appointments
        • GET All Client Appointments
        • GET Single Client Appointment
        • Add New Client Appointment
        • Edit Client Appointments
        • Delete Client Appointments
      • Client Payments
        • GET All Client Payments
        • GET Single Client Payment
        • Add New Client Payment
        • Edit Client Payments
        • Delete Client Payments
      • Client Attendance Log
        • Get All Client Attendance Logs
        • Get Single Client Attendance Log
        • Add New Client Attendance Log
        • Edit Client Attendance Log
        • Delete Client Attendance Log
      • Notes
        • GET All Notes
        • GET Single Note
        • Add New Note
        • Edit Notes
        • Delete Notes
      • Follow-Up Action
        • Get All Follow-Up Actions
        • Get Single Follow-Up Action
        • Delete Follow-Up Action
    • Bookings
      • Booking (Classic version)
        • Get All Bookings
        • Get Single Booking
        • Add new Booking
        • Delete booking
        • Change Booking Status
        • Convert booking to Invoice
      • Booking (Beta version)
        • Get All Bookings
        • Get Single Booking
        • Add new Booking
        • Delete booking
        • Change Booking Status
    • Work Orders
      • Work Order Appointments
        • GET All Work Order Appointments
        • GET Single Work Order Appointment
        • Add New Work Order Appointment
        • Edit Work Order Appointments
        • Delete Work Order Appointments
        • Update Work Order Appointment (POST alias)
      • Work Orders
        • GET All Work Orders
        • GET Single Work Order
        • Add New Work Order
        • Edit Work Orders
        • Delete Work Orders
    • Inventory
      • Products
        • GET All Products
        • GET Single Product
        • Add New Product
        • Edit Products
        • Delete Products
        • List Brands
      • Requsitions
        • GET All Requisitions
        • GET single Requisition
        • Add New Requisition
        • Edit Requisitions
        • Delete Requisitions
        • Trigger Requisition Update
      • Product Categories
        • GET All Product Categories
        • GET Single Product Category
        • Add New Product Category
        • Edit Product Category
        • Delete Product Category
        • Update Category Display Order
        • Update Category Items
      • Stores
        • GET All Stores
        • GET Single Store
        • Add New Store
        • Edit Stores
        • Delete Stores
      • Stock Transactions
        • GET All Stock Transactions
        • GET Single Stock Transaction
        • Add New Stock Transaction
        • Edit Stock Transactions
        • Delete Stock Transactions
      • Product Bundles
        • Add Product bundle
      • Brands
        • Get All Brands
        • Get Single Brand
        • Add New Brand
        • Edit brand
        • Delete brand
      • Unit Templates
        • Get All Unit Templates
        • Get Single Unit Template
        • Add Unit Template
        • Edit Unit Template
    • Accounting
      • Journals
        • Delete Journals
        • Edit Journals
        • GET All Journals
        • GET Single Journal
        • Add New Journal
      • Journal Accounts
        • GET All Journal Accounts
        • GET Single Journal Account
        • Add New Journal Account
        • Edit Journal Accounts
        • Delete Journal Accounts
      • Journal Cats
        • GET All Journal Cats
        • GET Single Journal Cat
        • Delete Journal Cats
        • Edit Journal Cats
        • Add New Journal Cat
      • Cost Centers
        • Get All Cost Centers
        • Get Single Cost Center
        • Add New Cost Center
        • Edit Cost Center
        • Delete Cost Center
    • Finance
      • Treasuries
        • GET All Treasuries
        • GET Single Treasury
        • Add New Treasury
        • Edit Treasuries
        • Delete Treasuries
      • Expenses
        • GET All Expenses
        • GET Single Expens
        • Add New Expens
        • Edit Expenses
        • Delete Expenses
      • Incomes
        • GET All Incomes
        • GET Single Income
        • Add New Income
        • Edit Incomes
        • Delete Incomes
    • Taxes
      • GET All Taxes
      • GET Single Taxe
      • Add New Taxe
      • Edit Taxes
      • Delete Taxes
    • Purchases
      • Purchase Refunds
        • GET All Purchase Refunds
        • GET Single Purchase Refund
        • Add New Purchase Refund
        • Edit Purchase Refunds
        • Delete Purchase Refunds
      • Purchase Invoices
        • GET All Purchase Invoices
        • GET Single Purchase Invoice
        • Add New Purchase Invoice
        • Edit Purchase Invoices
        • Delete Purchase Invoices
      • Purchase Orders
        • GET All Purchase Orders
        • GET Single Purchase Order
        • Add New Purchase Order
        • Edit Purchase Order
        • Delete Purchase Order
      • Purchase Debit Note
        • Purchase Debit Note
        • Purchase Debit Note
    • Suppliers
      • GET All Suppliers
      • GET Single Supplier
      • Add New Supplier
      • Edit Suppliers
      • Delete Suppliers
    • Staff
      • GET All Staff
      • GET Single Staff
      • Add New Staff
      • DELETE Staff
      • GET Send Staff Login Details
    • Time Tracking
      • GET All Time Tracking
      • GET Single Time Tracking
      • Add New Time Tracking
      • Edit Time Tracking
      • Delete Time Tracking
    • General Listing
      • GET General Listing
    • HR
      • Leave Application
        • Get All Leave Applications
        • Get Single Leave Applications
        • Add Leave Application
        • Edit Leave Application
      • Attendance Logs
        • Get All Attendance Logs
        • Get Single Attendance Log
        • Add Attendance Log
      • Employee Asset
        • Asset Type
          • Get All Types
          • Get Single Type
          • Add New Type
          • Edit Type
        • Asset Location
          • Get All Locations
          • Get Single Location
          • Add New Location
          • Edit Location
        • Asset Storage
          • Get All Storages
          • Get Single Storage
          • Add New Storage
          • Edit Storage
        • Asset
          • Get All Assets
          • Get Single Asset
          • Add New Asset
          • Edit Asset
      • Organizational Structure
        • Designation
          • Get All Designations
          • Get Single Designation
          • Add New Designation
          • Edit Designation
        • Department
          • Get All Departments
          • Get Single Department
          • Add New Department
          • Edit Department
        • Employment Type
          • Get All Employment Types
          • Get Single Employment Type
          • Add New Employment Type
          • Edit Employment Type
    • Branches
      • Get All Branches
      • Get Single Branch
      • Add New Branch
      • Edit Branch
      • Delete Branch
    • Payment Gateways
      • Get All Payment Methods
      • Get Single Payment Method
      • Add Payment Method
      • Add Payment Method Copy
    • Points & Credits
      • Credit Charges
        • Get All Credit Charges
        • Get Single Credit Charge
        • Add New Credit Charge
        • Edit Credit Charge
      • Credit Usage
        • Get All Credit Usage
        • Get Single Credit Usage
        • Add New Credit Usage
        • Edit Credit Usage
        • Get All Credit Usage Amount
        • Get Single Credit Usage Amount
        • Add Credit Usage Amount
        • Edit Credit Usage Amount
      • Credit Types
        • Get All Credit types
        • Get Single Credit type
        • Add New Credit type
        • Edit Credit type
      • Packages
        • Get All Packages
        • Get Single Package
        • Add New Package
        • Edit Package
      • Packages Credit Types
        • Get All Package Credit Types
        • Get Single Package Credit Type
        • Add Package Credit Type
        • Edit Package Credit Type
    • Workflow
      • Get All Records
      • Get Single Record
      • Add New Record
      • Edit Record
    • Multi Entity Request
      • Overview
      • Multi Entity Request
    • Follow-Up Statuses
      • Get All Follow-Up Statuses
      • Get Single Follow-Up Status
      • Add New Follow-Up Status
      • Delete Follow-Up Status
    • Entities
      • List entity records
      • View entity record
      • Create entity record
      • Update entity record
      • Delete entity record
    • Reports
      • Sales Revenue Report
        • Sales Revenue report
          GET
      • Product Sales Report
        • Product Sales report
      • Payments Report
        • Payments report
      • Profit & Loss (Accrual) Report
        • Profit & Loss (Accrual) report
  • Advanced Filtering
    • API Improvements
    • Filtering
    • Endpoints Structure
    • Using API v2
      • Data Fetching — Filtered
  • Developers Portal
    • Introduction & Getting Started
    • Dashboard, Earnings & Withdrawals
    • Creating a New App
    • App Configuration
    • Managing Your App
    • Entities: Modeling Your Data
    • The Entity Builder
    • Buttons & Page Scripts
    • Integrations: Webhooks
    • Invitations, Publishing & Reviews
    • Developers Portal Endpoints
      • Activate / Deactivate App
      • Lock / Unlock Entity Record
      • Check App Status
  1. Sales Revenue Report

Sales Revenue report

Production
https://{{subdomain}}.daftara.com
Production
https://{{subdomain}}.daftara.com
GET
https://{{subdomain}}.daftara.com
/api2/reports/revenue
OperationId:get_api2_reports_revenue
The Sales Invoices report. One endpoint covers five report types: report_type=invoice is the Detailed view and returns document rows inside each group; client, staff, sales_person and period are Summary views and return one figure block per group.
Results are always grouped by currency. Pass currency=-1 to convert everything into the base currency and receive a single bucket.
Mirrors /owner/reports/revenue, and backs 7 of the Sales Reports tab's cards.
Not paginated, and no {format} suffix. /api2/reports/revenue.json is not a route, and ext=csv and friends are refused -- the response is always JSON.

Size ceilings#

BoundDefaultApplies to
Documents7,000report_type=invoice
Groups2,000every report type

Parameters that are refused#

ParameterReason
showResultsNot a filter. The API always runs the report.
quickA page rendering mode.
no_graphA page rendering mode; the API returns no charts.
hiddenA PDF column-hiding control.
extThis endpoint always answers JSON.
auto_csvA page export control.
csv_confirmedA page export control.
handlerA page export control.
is_summarySet by this endpoint itself; not a filter.
threshold_limitA page export control. Sending it would suppress the query entirely.
dataSend the nested filters at the top level: work_order_id, order_source_id, branch_id, e_invoice_status.
Custom-field filters (field_<id>) are refused too. Any parameter not documented above is a 400 naming it -- nothing is silently ignored, so a typo or a pasted report-page URL fails loudly rather than returning a different report.

Request

Query Params

Header Params

Responses

🟢200
application/json
The report.
Bodyapplication/json

🟠400Error400
🟠401Error401
🟠403Error403
🟠404Error404
🟠405Error405
🔴500Error500
Request Request Example
Shell
JavaScript
Java
Swift
curl --location --globoff 'https://.daftara.com/api2/reports/revenue?report_type=period&group_by=monthly&date_from=2026-09-01&date_to=2026-10-01&client_id=&client_category=&staff_id=&invoice_type=&currency=-1&shipping_option_id=&show_not_taxed=&work_order_id=&order_source_id=&branch_id=&e_invoice_status=' \
--header 'Accept: application/json' \
--header 'Authorization: Bearer ' \
--header 'apikey: ' \
--header 'Content-Type: application/json'
Response Response Example
200 - Example 1
{
    "result": "successful",
    "code": 200,
    "data": {
        "report": {
            "key": "revenue",
            "report_type": "client",
            "mode": "detailed",
            "group_by": "string",
            "group_dimension": "string",
            "title": "string"
        },
        "filters": {
            "report_type": "string",
            "group_by": "string",
            "date_from": "2019-08-24",
            "date_to": "2019-08-24",
            "client_id": 0,
            "client_category": [
                0
            ],
            "staff_id": [
                "string"
            ],
            "invoice_type": [
                "string"
            ],
            "currency": "string",
            "shipping_option_id": 0,
            "show_not_taxed": true,
            "work_order_id": 0,
            "order_source_id": 0,
            "branch_id": [
                0
            ],
            "e_invoice_status": [
                "string"
            ],
            "converted_to": "string"
        },
        "columns": [
            {
                "key": "string",
                "label": "string"
            }
        ],
        "currencies": [
            {
                "currency": "string",
                "totals": {
                    "paid": 0,
                    "unpaid": 0,
                    "refund": 0,
                    "total": 0,
                    "total_without_tax": 0,
                    "unpaid_retention": 0
                },
                "groups": [
                    {
                        "key": "string",
                        "label": "string",
                        "period": {
                            "start": "2019-08-24",
                            "end": "2019-08-24"
                        },
                        "id": 0,
                        "client_identity": {
                            "bn1": "string",
                            "bn1_label": "string"
                        },
                        "subtotals": {
                            "paid": 0,
                            "unpaid": 0,
                            "refund": 0,
                            "total": 0,
                            "total_without_tax": 0,
                            "unpaid_retention": 0
                        },
                        "invoices": [
                            {
                                "paid": 0,
                                "unpaid": 0,
                                "refund": 0,
                                "total": 0,
                                "total_without_tax": 0,
                                "unpaid_retention": 0,
                                "no": "string",
                                "document_type": "invoice",
                                "date": "2019-08-24",
                                "client": {
                                    "id": 0,
                                    "name": "string",
                                    "bn1": "string",
                                    "bn1_label": "string",
                                    "bn2": "string",
                                    "bn2_label": "string"
                                },
                                "staff": {
                                    "id": 0,
                                    "name": "string"
                                },
                                "sales_person": {
                                    "id": 0,
                                    "name": "string"
                                },
                                "e_invoice_status": {
                                    "code": "string",
                                    "label": "string"
                                },
                                "shows_retention": true
                            }
                        ]
                    }
                ]
            }
        ],
        "meta": {
            "currency_count": 0,
            "group_count": 0,
            "retention_enabled": true,
            "e_invoice_enabled": true,
            "sales_without_tax_enabled": true,
            "invoice_count": 0,
            "invoice_id_available": true,
            "converted_to": "string"
        }
    }
}
Previous
Delete entity record
Next
Product Sales report