# Retrieve Filtered Invoice Detail

Get record(s) using filters

Endpoint: GET /rest/2.0/ACTIVITY
Version: 1.0
Security: JWT

## Query parameters:

  - `queryAnsiSql` (string, required)
    SQL Where part

## Header parameters:

  - `sessionId` (string, required)

## Response 200 fields (application/json):

  - `retrieveResponse` (object)

  - `retrieveResponse.AccountId` (any)
    Account

  - `retrieveResponse.AccountPackageId` (any)
    AccountPackageId: Account Package

  - `retrieveResponse.AccountProductId` (any)
    Account Product: Customer Product

  - `retrieveResponse.AccumulatorValueId` (any)
    AccumulatorValueId

  - `retrieveResponse.ActivityCollectorId` (any)
    ActivityCollectorId

  - `retrieveResponse.ActivityDate` (any)
    Activity Date

  - `retrieveResponse.AvalaraGroupKey` (any)
    AvalaraGroupKey

  - `retrieveResponse.BillingIdentifierAccountProductId` (any)
    BillingIdentifierAccountProductId: Billing Identifier Account Product

  - `retrieveResponse.BillingIdentifierId` (any)
    BillingIdentifierId: USER_VENDOR_MAPPING_ID

  - `retrieveResponse.CollectorStageId` (any)
    CollectorStageId

  - `retrieveResponse.ContractId` (any)
    ContractId

  - `retrieveResponse.ContractRateId` (any)
    ContractRateId

  - `retrieveResponse.CostUnrounded` (any)
    CostUnrounded

  - `retrieveResponse.CountryCodeMapId` (any)
    CountryCodeMapId

  - `retrieveResponse.Created` (any)
    System controlled field: Date and time the record was created

  - `retrieveResponse.CreatedUserId` (any)
    System controlled field: Id of the user that created the record

  - `retrieveResponse.CurrencyCode` (any)
    CurrencyCode

  - `retrieveResponse.DestinationCountryCodeId` (any)
    DestinationCountryCodeId

  - `retrieveResponse.DiscountActivityId` (any)
    DiscountActivityId

  - `retrieveResponse.DiscountedBy` (any)
    Discounted By: Applicable only for usage charges that are part of a linked overage associated to a customer's subscription. This will redirect to the invoice detail of the associated subscription charge.

  - `retrieveResponse.EffectiveRated` (any)
    Effective Rated

  - `retrieveResponse.Estimated` (any)
    Estimated

  - `retrieveResponse.EventInvoiceCycleId` (any)
    EventInvoiceCycleId

  - `retrieveResponse.ExchangeRateId` (any)
    ExchangeRateId

  - `retrieveResponse.Feature` (any)
    Feature

  - `retrieveResponse.Formula` (any)
    Formula

  - `retrieveResponse.Id` (any)
    Invoice Detail ID: BILLING_ACTIVITY_ID

  - `retrieveResponse.InvoiceId` (any)
    InvoiceId

  - `retrieveResponse.MDLEventId` (any)
    MDL Event Id

  - `retrieveResponse.ManualChargeByUserId` (any)
    ManualChargeByUserId

  - `retrieveResponse.MinChargeFlag` (any)
    MinChargeFlag

  - `retrieveResponse.OriginationCountryCodeId` (any)
    OriginationCountryCodeId

  - `retrieveResponse.PackageProductId` (any)
    PackageProductId

  - `retrieveResponse.PricingCurrencyCode` (any)
    PricingCurrencyCode

  - `retrieveResponse.PricingId` (any)
    PricingId

  - `retrieveResponse.ProcessDescription` (any)
    ProcessDescription

  - `retrieveResponse.ProcessStatus` (any)
    ProcessStatus

  - `retrieveResponse.ProductId` (any)
    Product

  - `retrieveResponse.ProrateFactor` (any)
    ProrateFactor

  - `retrieveResponse.Quantity` (any)
    Quantity

  - `retrieveResponse.RateClassProductId` (any)
    RateClassProductId

  - `retrieveResponse.RateDate` (any)
    Rate Date

  - `retrieveResponse.RateSource` (any)
    RateSource

  - `retrieveResponse.RatedAmount` (any)
    Rating Amount: RATING_AMOUNT

  - `retrieveResponse.RatingDate` (any)
    Rating Date

  - `retrieveResponse.RatingMethodId` (any)
    RatingMethodId

  - `retrieveResponse.ReprocessQueueID` (any)
    Reprocess Queue ID: Reference to last reprocess task for the entry

  - `retrieveResponse.SplitFromBillActId` (any)
    SplitFromBillActId

  - `retrieveResponse.StandardCostUnrounded` (any)
    Standard Cost Unrounded

  - `retrieveResponse.SubscriptionFromDate` (any)
    SubscriptionFromDate

  - `retrieveResponse.SubscriptionToDate` (any)
    SubscriptionToDate

  - `retrieveResponse.TaxCostUnrounded` (any)
    TaxCostUnrounded

  - `retrieveResponse.TieredGroup` (any)
    TieredGroup

  - `retrieveResponse.UpdateError` (any)
    Update Error: Mass Update Error

  - `retrieveResponse.Updated` (any)
    System controlled field: Date and time the record was last updated

  - `retrieveResponse.UpdatedUserId` (any)
    System controlled field: Id of the last user that updated the record

  - `retrieveResponse.UpperBand` (any)
    UpperBand

  - `retrieveResponse.UsageIdentifier` (any)
    UsageIdentifier

## Response 400 fields (application/json):

  - `error` (string)
    Bad request

  - `message` (string)
    Bad request

## Response 401 fields (application/json):

  - `error` (string)
    Unauthorized

  - `message` (string)
    Unauthorized

## Response 404 fields (application/json):

  - `error` (string)
    Not found

  - `message` (string)
    Not found

## Response 429 fields (application/json):

  - `error` (string)
    Too many requests

  - `message` (string)
    Too many requests

## Response 500 fields (application/json):

  - `error` (string)
    Internal error

  - `message` (string)
    Internal error