Get Invoice by Date Range API
Retrieve invoices within a specified date range for reporting and analysis
Get Invoice by Date Range API
Filter and retrieve invoices within a specific date range. Ideal for generating reports, reconciliation, and financial analysis.
Date Filtering
Specify start and end dates.
Reporting
Generate period reports.
Flexible Range
Any date range supported.
Endpoint Overview
/graphqlRetrieve all invoices that fall within the specified date range. Useful for monthly, quarterly, or yearly reports.
Request Parameters
startDateString!RequiredThe start date of the range (ISO 8601 format: YYYY-MM-DD).
endDateString!RequiredThe end date of the range (ISO 8601 format: YYYY-MM-DD).
GraphQL Query
query getInvoiceByDateRange($startDate: String!, $endDate: String!) {
getInvoiceByDateRange(startDate: $startDate, endDate: $endDate) {
id
firstName
lastName
email
totalAmount
paymentMethod
paymentDate
invoiceDate
groupId
}
}Variables:
{
"startDate": "2024-01-01",
"endDate": "2024-01-31"
}HTTP Request:
curl -X POST https://api.orbnet.com/graphql \
-H "Content-Type: application/json" \
-H "Authorization: Bearer YOUR_ADMIN_TOKEN" \
-d '{
"query": "query getInvoiceByDateRange($startDate: String!, $endDate: String!) { getInvoiceByDateRange(startDate: $startDate, endDate: $endDate) { id email totalAmount paymentDate } }",
"variables": {
"startDate": "2024-01-01",
"endDate": "2024-01-31"
}
}'Response
{
"data": {
"getInvoiceByDateRange": [
{
"id": "inv_12345",
"firstName": "John",
"lastName": "Doe",
"email": "john@example.com",
"totalAmount": 29.99,
"paymentMethod": "stripe",
"paymentDate": "2024-01-05T10:30:00Z",
"invoiceDate": "2024-01-05T10:30:00Z",
"groupId": "100"
},
{
"id": "inv_12346",
"firstName": "Jane",
"lastName": "Smith",
"email": "jane@example.com",
"totalAmount": 49.99,
"paymentMethod": "paypal",
"paymentDate": "2024-01-15T14:20:00Z",
"invoiceDate": "2024-01-15T14:20:00Z",
"groupId": "200"
}
]
}
}{
"errors": [
{
"message": "Invalid date format. Use YYYY-MM-DD",
"path": ["getInvoiceByDateRange"],
"extensions": {
"code": "INVALID_DATE"
}
}
],
"data": null
}Common Date Ranges
Daily Report
Single day invoice summary.
Weekly Report
7-day transaction overview.
Monthly Report
Full month financial data.
Custom Range
Any start/end date combo.
Use Cases
Monthly Reports
Generate monthly revenue reports.
Tax Filing
Gather data for tax periods.
Reconciliation
Match with bank statements.
Trend Analysis
Compare across time periods.
Related Endpoints
Date Format
Use ISO 8601 date format (YYYY-MM-DD). Times are interpreted as start of day (00:00:00) for startDate and end of day (23:59:59) for endDate.
Need Accounting Summary?
Get aggregated metrics instead of individual invoice records.