# Retrieve Filtered Pricing

Get record(s) using filters

Endpoint: GET /rest/2.0/PRICING
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.AccountProductId` (any)
    AccountProductId: Customer Product Id

  - `retrieveResponse.BlockIterations` (any)
    BlockIterations: ITERATIONS

  - `retrieveResponse.BlockSize` (any)
    BlockSize

  - `retrieveResponse.BuyRate` (any)
    BuyRate

  - `retrieveResponse.ContractRateId` (any)
    ContractRateId

  - `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.EffectiveDate` (any)
    EffectiveDate: The Date when the plan takes effect

  - `retrieveResponse.EndDate` (any)
    EndDate: The Date when the plan terminates

  - `retrieveResponse.ExternalKey` (any)
    ExternalKey

  - `retrieveResponse.Id` (any)
    Id: Pricing Id

  - `retrieveResponse.LowerBand` (any)
    LowerBand

  - `retrieveResponse.MainPricingPlanId` (any)
    MainPricingPlanId

  - `retrieveResponse.MinCharge` (any)
    MinCharge

  - `retrieveResponse.OrderLineItemId` (any)
    OrderLineItemId

  - `retrieveResponse.PackageProductId` (any)
    PackageProductId

  - `retrieveResponse.ProductId` (any)
    ProductId

  - `retrieveResponse.QuoteProductId` (any)
    QuoteProductId

  - `retrieveResponse.QuoteRate` (any)
    QuoteRate

  - `retrieveResponse.Rate` (any)
    Rate

  - `retrieveResponse.RateClassProductId` (any)
    RateClassProductId

  - `retrieveResponse.RateOrder` (any)
    RateOrder

  - `retrieveResponse.RateSource` (any)
    Rate Source

  - `retrieveResponse.RatingMethodId` (any)
    Rating Method

  - `retrieveResponse.RerateFlag` (any)
    Automatically re-rate current usage: When checked, all charges for this product in open/CURRENT invoices are re-rated unless these charges were priced using other than the base product (e.g. rated using account product rates, contract rates, etc.).

  - `retrieveResponse.RevRecContractProductId` (any)
    RevRecContractProductId: RevRec Contract Product

  - `retrieveResponse.SSP` (any)
    SSP: SSP (Revenue Recognition)

  - `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

## 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