Example: retrieving account numbers and their revenue class and customer name where the account number is not null

The following examples use &top=1000 to return only the first 1000 results. This value can be up to 10,000 to suit your needs.

  • HTTP example:

    Copy 
    GET /DimAccount?$top=1000&$select=AccountNumber,RevenueClassID,CustomerFirstName,CustomerLastName,BusinessName&$filter=AccountNumber ne null HTTP/1.1
    Host: https://services.itrontotal.com/odata
    itron-route-override: iaodata
    Authorization: Bearer 
    {{Token}}

  • cURL example:

    Copy 
    curl --location --request GET 'https://services.itrontotal.com/odata/DimAccount?$top=1000&$select=AccountNumber,RevenueClassID,CustomerFirstName,CustomerLastName,BusinessName&$filter=AccountNumber%20ne%20null' \
    --header 'itron-route-override: iaodata' \
    --header 'Authorization: Bearer {{Token}}’
Copy 
{
    "@odata.context": "https://services.itrontotal.com/odata/$metadata#DimAccount(AccountNumber,RevenueClassID,CustomerFirstName,CustomerLastName,BusinessName)",
    "value": [
        {
            "AccountNumber": null,
            "RevenueClassID": "Undefined",
            "CustomerFirstName": null,
            "CustomerLastName": null,
            "BusinessName": null
        },
        {
            "AccountNumber": "1175",
            "RevenueClassID": "RESIDENTIAL",
            "CustomerFirstName": "ROBERT K",
            "CustomerLastName": "WHITE",
            "BusinessName": null
        },
        {
            "AccountNumber": "140505",
            "RevenueClassID": "RESIDENTIAL",
            "CustomerFirstName": "ANTHONY D",
            "CustomerLastName": "HART",
            "BusinessName": null
        },
        {
…
        }
    ]
}