Get Customer Bills

get

/customerBill

Gets the customer bills that match the query criteria.

Request

Query Parameters
  • The type of object to return.
    Example:
    Use @type=CustomerBill for a base object or @type=CustomerBillOracle for an extended object.
  • Retrieves the customer bills with an amount due that matches the specified value.
    Example:
    amountDue.value=20
  • Retrieves the customer bills with an amount due that is greater than the specified value.
    Example:
    amountDue.value.gt=20
  • Retrieves the customer bills with an amount due that is greater than or equal to the specified value.
    Example:
    amountDue.value.gte=20
  • Retrieves the customer bills with an amount due value that is less than the specified value.
    Example:
    amountDue.value.lt=20
  • Retrieves the customer bills with an amount due that is less than or equal to the specified value.
    Example:
    amountDue.value.lte=20
  • Retrieves the customer bills with a billDate that matches the specified dateTime.
    Example:
    billDate=2020-01-01T04:00:27-08:00
  • Retrieves the customer bills with a billDate that is greater than the specified dateTime.
    Example:
    billDate.gt=2020-01-01T04:00:27-08:00
  • Retrieves the customer bills with a billDate that is greater than or equal to the specified dateTime.
    Example:
    billDate.gte=2020-01-01T04:00:27-08:00
  • Retrieves the customer bills with a billDate that is less than the specified dateTime.
    Example:
    billDate.lt=2020-01-01T04:00:27-08:00
  • Retrieves the customer bills with a billDate that is less than or equal to the specified dateTime.
    Example:
    billDate.lte=2020-01-01T04:00:27-08:00
  • Retrieves customer bills by bill number.
    Example:
    billNo=B1-28
  • Retrieves customer bills that match the specified bill number.
    Example:
    billNo.like=B1-28
  • Retrieves customer bills for the specified account ID.
    Example:
    billingAccount.id=0.0.0.1+-account+107117
  • Retrieves the customer bills with a billing period end date time that matches the specified dateTime.
    Example:
    billingPeriod.endDateTime=2020-01-01T04:00:27-08:00
  • Retrieves the customer bills with a billing period end date time that is greater than the specified dateTime.
    Example:
    billingPeriod.endDateTime.gt=2020-01-01T04:00:27-08:00
  • Retrieves the customer bills with a billing period end date time that is greater than or equal to the specified dateTime.
    Example:
    billingPeriod.endDateTime.gte=2020-01-01T04:00:27-08:00
  • Retrieves the customer bills with a billing period end date time that is less than the specified dateTime.
    Example:
    billingPeriod.endDateTime.lt=2020-01-01T04:00:27-08:00
  • Retrieves the customer bills with a billing period end date time that is less than or equal to the specified dateTime.
    Example:
    billingPeriod.endDateTime.lte=2020-01-01T04:00:27-08:00
  • Retrieves the customer bills with a billing period start date time that matches the specified dateTime.
    Example:
    billingPeriod.startDateTime=2020-01-01T04:00:27-08:00
  • Retrieves the customer bills with a billing period start date time that is greater than the specified dateTime.
    Example:
    billingPeriod.startDateTime.gt=2020-01-01T04:00:27-08:00
  • Retrieves the customer bills with a billing period start date that is greater than or equal to the specified dateTime.
    Example:
    billingPeriod.startDateTime.gte=2020-01-01T04:00:27-08:00
  • Retrieves the customer bills with a billing period start date time that is less than the specified dateTime.
    Example:
    billingPeriod.startDateTime.lt=2020-01-01T04:00:27-08:00
  • Retrieves the customer bills with a billing period start date time that is less than or equal to the specified dateTime.
    Example:
    billingPeriod.startDateTime.lte=2020-01-01T04:00:27-08:00
  • The list of comma-separated fields to return in the response.
    Example:
    fields=runType,amountDue
  • Retrieves customer bills for the specified bill ID.
    Example:
    id=0.0.0.1+-bill+106861
  • Retrieves the customer bills whose lastUpdate matches the specified dateTime.
    Example:
    lastUpdate=2020-01-01T04:00:27-08:00
  • Retrieves the customer bills whose lastUpdate is greater than the specified dateTime.
    Example:
    lastUpdate.gt=2020-01-01T04:00:27-08:00
  • Retrieves the customer bills whose lastUpdate is less than the specified dateTime.
    Example:
    lastUpdate.gte=2020-01-01T04:00:27-08:00
  • Retrieves customer bills whose lastUpdate is less than the specified dateTime.
    Example:
    lastUpdate.lt=2020-01-01T04:00:27-08:00
  • Retrieves the customer bills whose lastUpdate is less than or equal to the specified dateTime.
    Example:
    lastUpdate.lte=2020-01-01T04:00:27-08:00
  • The maximum number of results to return.
    Example:
    Use limit=10 to return the first 10 results only.
  • The number of results to offset the response by.
    Example:
    Use offset=10 to return results 10 and higher.
  • Retrieves the customer bills with a paymentDueDate that matches the specified dateTime.
    Example:
    paymentDueDate=2020-01-01T04:00:27-08:00
  • Retrieves the customer bills with a paymentDueDate that is greater than the specified dateTime.
    Example:
    paymentDueDate.gt=2020-01-01T04:00:27-08:00
  • Retrieves the customer bills with a paymentDueDate that is greater than or equal to the specified dateTime.
    Example:
    paymentDueDate.gte=2020-01-01T04:00:27-08:00
  • Retrieves the customer bills with a paymentDueDate that is less than the specified dateTime.
    Example:
    paymentDueDate.lt=2020-01-01T04:00:27-08:00
  • Retrieves the customer bills with a paymentDueDate that is less than or equal to the specified dateTime.
    Example:
    paymentDueDate.lte=2020-01-01T04:00:27-08:00
  • Retrieves the customer bills with a remaining amount that matches the specified value.
    Example:
    remainingAmount.value=30
  • Retrieves the customer bills with a remaining amount that is greater than the specified value.
    Example:
    remainingAmount.value.gt=30
  • Retrieves the customer bills with a remaining amount that is greater than or equal to the specified value.
    Example:
    remainingAmount.value.gte=30
  • Retrieves the customer bills with a wild card in the remaining amount value.
    Example:
    remainingAmount.value.like=3
  • Retrieves the customer bills with a remaining amount that is less than the specified value.
    Example:
    remainingAmount.value.lt=30
  • Retrieves the customer bills with a remaining amount that is less than or equal to the specified value.
    Example:
    remainingAmount.value.lte=30
  • The state of the bill.
    Allowed Values: [ "new", "partiallyPaid", "settled", "inProgress" ]
    Example:
    state=inProgress

There's no request body for this operation.

Back to Top

Response

Supported Media Types

200 Response

Success
Headers
Body ()
Root Schema : schema
Type: array
Show Source
Nested Schema : Customer Bill
Type: object
Title: Customer Bill
A customer bill, also called an invoice.
Show Source
Nested Schema : Money
Type: object
A base / value business entity used to represent money.
Show Source
Nested Schema : appliedPayment
Type: array
Payments applied to the bill.
Show Source
Nested Schema : billDocument
Type: array
A document attached to the bill.
Show Source
  • Attachment Ref Or Value
    Title: Attachment Ref Or Value
    An attachment reference or value. The baseType, type, schemaLocation and referredType properties are related to the contained object, not the AttchmentRefOrValue.
Nested Schema : Billing Account Ref
Type: object
Title: Billing Account Ref
A billing account is a detailed description of a bill structure.
Show Source
Nested Schema : TimePeriod
Type: object
A period of time.
Show Source
Nested Schema : Financial Account Ref
Type: object
Title: Financial Account Ref
A financial account reference.
Show Source
Nested Schema : Payment Method Ref
Type: object
Title: Payment Method Ref
A reference to a payment method.
Show Source
Nested Schema : relatedParty
Type: array
The parties related to the bill.
Show Source
Nested Schema : taxItem
Type: array
Taxes on the bill.
Show Source
Nested Schema : Applied Payment
Type: object
Title: Applied Payment
A payment that can be assigned to a bill.
Show Source
Nested Schema : Payment Ref
Type: object
Title: Payment Ref
A payment captured as a reference on an order. Used when a payment is made immediately on an order rather than at a later billing date.
Show Source
Nested Schema : Attachment Ref Or Value
Type: object
Title: Attachment Ref Or Value
An attachment reference or value. The baseType, type, schemaLocation and referredType properties are related to the contained object, not the AttchmentRefOrValue.
Show Source
Nested Schema : Quantity
Type: object
An amount in a given unit.
Show Source
Nested Schema : accountBalance
Type: array
The account's balances.
Show Source
Nested Schema : Account Balance
Type: object
Title: Account Balance
A balance associated with an account.
Show Source
Nested Schema : Related Party Ref
Type: object
Title: Related Party Ref
A reference to the party related to an object.
Show Source
Nested Schema : State Values
Type: object
Title: State Values
A tax item.
Show Source

400 Response

Bad Request
Body ()
Root Schema : Error
Type: object
This is used when an API throws an error, typically with a HTTP error response-code (3xx, 4xx, 5xx).
Show Source

401 Response

Unauthorized
Body ()
Root Schema : Error
Type: object
This is used when an API throws an error, typically with a HTTP error response-code (3xx, 4xx, 5xx).
Show Source

403 Response

Forbidden
Body ()
Root Schema : Error
Type: object
This is used when an API throws an error, typically with a HTTP error response-code (3xx, 4xx, 5xx).
Show Source

404 Response

Not Found
Body ()
Root Schema : Error
Type: object
This is used when an API throws an error, typically with a HTTP error response-code (3xx, 4xx, 5xx).
Show Source

405 Response

Method Not allowed
Body ()
Root Schema : Error
Type: object
This is used when an API throws an error, typically with a HTTP error response-code (3xx, 4xx, 5xx).
Show Source

409 Response

Conflict
Body ()
Root Schema : Error
Type: object
This is used when an API throws an error, typically with a HTTP error response-code (3xx, 4xx, 5xx).
Show Source

500 Response

Internal Server Error
Body ()
Root Schema : Error
Type: object
This is used when an API throws an error, typically with a HTTP error response-code (3xx, 4xx, 5xx).
Show Source
Back to Top

Examples

The following example shows how to get bills by submitting a GET request on the REST resource using cURL. For more information about cURL, see Use cURL.

The request uses query parameters to show a maximum of two results, limited to bills in progress that have a payment due date later than or equal to June 1, 2020.

curl -X GET 'http://host:port/brm/customerBillManagement/version/customerBill?limit=2&state=inProgress&paymentDueDate.gte=2020-06-01T01:05:29-07:00

Example of the Response Body

The following example shows the contents of the response body in JSON format.

[
    {
        "id": "0.0.0.1+-bill+106861",
        "href": "http://host:port/brm/customerBillManagement/version/customerBill/0.0.0.1+-bill+106861",
        "billDate": null,
        "billNo": "bill in progress",
        "category": "0",
        "lastUpdate": "2020-05-02T01:14:13-07:00",
        "nextBillDate": "2020-06-13T00:00:00-07:00",
        "paymentDueDate": "2020-08-01T01:05:29-07:00",
        "runType": "onCycle",
        "amountDue": {
            "unit": "EUR",
            "value": 90.0
        },
        "appliedPayment": null,
        "billDocument": null,
        "billingAccount": {
            "id": "0.0.0.1+-account+107117",
            "href": null,
            "name": "Tanya Levy",
            "@baseType": null,
            "@schemaLocation": null,
            "@type": null,
            "@referredType": "billingAccount"
        },
        "billingPeriod": {
            "endDateTime": null,
            "startDateTime": "2020-05-02T00:00:00-07:00"
        },
        "financialAccount": {
            "id": "0.0.0.1+-account+107117",
            "href": null,
            "name": "Tanya Levy",
            "accountBalance": null,
            "@baseType": null,
            "@schemaLocation": null,
            "@type": null,
            "@referredType": "financialAccount"
        },
        "paymentMethod": {
            "id": "0.0.0.1+-payinfo-invoice+109165",
            "href": null,
            "name": "4243324",
            "@baseType": null,
            "@schemaLocation": null,
            "@type": null,
            "@referredType": null
        },
        "relatedParty": null,
        "remainingAmount": {
            "unit": "EUR",
            "value": 90.0
        },
        "state": "inProgress",
        "taxExcludedAmount": {
            "unit": "EUR",
            "value": 86.0
        },
        "taxIncludedAmount": {
            "unit": "EUR",
            "value": 90.0
        },
        "taxItem": null,
        "@baseType": "CustomerBill",
        "@schemaLocation": null,
        "@type": "CustomerBill"
    },
    {
        "id": "0.0.0.1+-bill+103581",
        "href": "http://host:port/brm/customerBillManagement/version/customerBill/0.0.0.1+-bill+103581",
        "billDate": null,
        "billNo": "bill in progress",
        "category": "0",
        "lastUpdate": "2020-05-02T00:23:54-07:00",
        "nextBillDate": "2020-06-02T00:00:00-07:00",
        "paymentDueDate": "2020-10-12T01:05:29-07:00",
        "runType": "onCycle",
        "amountDue": {
            "unit": "USD",
            "value": 100.0
        },
        "appliedPayment": null,
        "billDocument": null,
        "billingAccount": {
            "id": "0.0.0.1+-account+104221",
            "href": null,
            "name": "Grace Wang",
            "@baseType": null,
            "@schemaLocation": null,
            "@type": null,
            "@referredType": "billingAccount"
        },
        "billingPeriod": {
            "endDateTime": null,
            "startDateTime": "2020-05-02T00:00:00-07:00"
        },
        "financialAccount": {
            "id": "0.0.0.1+-account+104221",
            "href": null,
            "name": "Grace Wang",
            "accountBalance": null,
            "@baseType": null,
            "@schemaLocation": null,
            "@type": null,
            "@referredType": "financialAccount"
        },
        "paymentMethod": {
            "id": "0.0.0.1+-payinfo-invoice+106269",
            "href": null,
            "name": "Invoice1",
            "@baseType": null,
            "@schemaLocation": null,
            "@type": null,
            "@referredType": null
        },
        "relatedParty": null,
        "remainingAmount": {
            "unit": "USD",
            "value": 0.0
        },
        "state": "inProgress",
        "taxExcludedAmount": {
            "unit": "USD",
            "value": 93.75
        },
        "taxIncludedAmount": {
            "unit": "USD",
            "value": 100.0
        },
        "taxItem": null,
        "@baseType": "CustomerBill",
        "@schemaLocation": null,
        "@type": "CustomerBill"
    }
]
Back to Top