# Get record count and sample of consumers

This endpoint allows API users to retrieve a count and 10 record sample of the results to preview before purchasing a file version of the full dataset.

Endpoint: POST /ConsumerTwo/getCount

## Header parameters:

  - `Accept` (string, required)
    Format of the response.
    Enum: "application/json", "*/*"

  - `Content-Type` (string, required)
    Format of the request.
    Enum: "application/json", "application/xml"

## Request fields (application/json):

  - `CustomerID` (string, required)
    The [License Key](https://docs.melissa.com/melissa/license/license-information.html) issued by Melissa.

  - `Includes` (object, required)
    Any parameter you would like to include in the query.

Requires at least one from:
- Zips
- Cities
- Radius
- ShapeWKTs

  - `Includes.Zips` (array)
    A list of Zips objects containing Zip codes and optionally Plus4.

  - `Includes.Zips.Zip` (string, required)

  - `Includes.Zips.Plus4` (string)

  - `Includes.Cities` (array)
    A list of cities objects each containing City and State.

  - `Includes.Cities.City` (string, required)

  - `Includes.Cities.State` (string, required)

  - `Includes.Radius` (object)
    A Radius object containing a Latitude, Longitude, and Distance represented in miles.

  - `Includes.Radius.Latitude` (number, required)

  - `Includes.Radius.Longitude` (number, required)

  - `Includes.Radius.Distance` (number, required)

  - `Includes.ShapeWKTs` (array)
    A list of WKT polygon strings

  - `Includes.RBDI` (array)
    An RBDI code.

  - `Includes.FIPSCode` (array)
    A list of FIPSCodes.

  - `Includes.AddressStreetName` (array)
    A list of address street name objects.

  - `Includes.AddressStreetName.ZipCode` (string)

  - `Includes.AddressStreetName.Street` (string)

  - `Excludes` (object)
    Any parameter you would like to exclude in the query.

  - `Excludes.Zips` (array)
    A list of Zips objects containing Zip codes and optionally Plus4.

  - `Excludes.Zips.Zip` (string, required)

  - `Excludes.Zips.Plus4` (string)

  - `Excludes.Cities` (array)
    A list of cities objects each containing City and State.

  - `Excludes.Cities.City` (string, required)

  - `Excludes.Cities.State` (string, required)

  - `Excludes.RBDI` (array)
    An RBDI code.

  - `Excludes.FIPSCode` (array)
    A list of FIPSCodes.

  - `Excludes.AddressStreetName` (array)
    A list of address street name objects.

  - `Excludes.AddressStreetName.ZipCode` (string)

  - `Excludes.AddressStreetName.Street` (string)

  - `Columns` (array, required)
    All [Consumer Two Columns](https://docs.melissa.com/reference-data/data-retriever/data-retriever-reference-guide.html#consumer-two) you want returned.
    Enum: "MelissaAddressKey", "BaseMelissaAddressKey", "FirstName1", "MiddleNameInitial1", "LastName", "NameSuffix1", "AddressLine", "City", "State", "ZIPCode", "Plus4", "DeliveryPoint", "AddressKey", "ResultCodes", "AddressStreetNumber", "AddressStreetName", "AddressSuiteNumber", "AddressType", "RBDI", "CarrierRoute", "FIPSCode", "FIPSCountyCode", "RouteDesignatorAndNumber", "BoxDesignatorAndNumber", "AddressQualityCode", "SeasonalDeliveryCode", "DeliveryTypeCode", "AddressNameCensorCode", "PlaceCode", "Latitude", "Longitude", "CensusKey", "CensusTractBlockGroup2010", "FIPSStateCode2010", "FIPSCountyCode2010", "CBSACode", "Apider1", "Age1", "BirthYear1", "BirthMonth1", "TitleCode1", "PhoneNumberAreaCode", "PhoneNumber", "FullPhoneNumber", "LandlinePhoneAreaCode", "LandlinePhoneNumber", "PhoneType", "CellPhoneNumber1", "CellPhoneNumber2", "CellPhoneNumber3", "CellPhoneNumber4", "SecondaryCellPhoneAreaCode1", "SecondaryCellPhoneNumber1", "SecondaryCellPhoneAreaCode2", "SecondaryCellPhoneNumber2", "SecondaryCellPhoneAreaCode3", "SecondaryCellPhoneNumber3", "SecondaryCellPhoneAreaCode4", "SecondaryCellPhoneNumber4", "Email", "EmailResultLevel", "Age0to2Code", "Age3to5Code", "Age6to10Code", "Age11to15Code", "Age16to17Code", "Age18to24Code", "Age25to34Code", "Age35to44Code", "Age45to54Code", "Age55to64Code", "Age65to74Code", "Age75PlusCode", "AgeUnknownCode", "Under35Ind", "Age35to44Ind", "Age45to64Ind", "Age65PlusInd", "NumberOfPersonsinHousehold", "NumberOfAdultsinHousehold", "AdvantageNumberOfAdultsInd", "NumberOfChildreninHousehold", "PresenceOfChildren", "PresenceOfChildrenInd", "TargetNetWorth", "HouseholdsMedianHouseholdIncome", "HouseholdAgeCode", "HouseholdTypeCode", "AdvantageHouseholdAgeInd", "AdvantageHouseholdSizeInd", "HouseholdVerificationDate", "Occupation", "MaritalStatusCode", "LengthOfResidence", "AdvantageLengthOfResidenceInd", "AdvantageHomeOwnerInd", "AdvantageHouseholdMaritalStatusInd", "EstimatedHomeIncomePredictor", "AdvantageHouseholdIncomeIdentifierInd", "FamiliesPercentHouseholdIwthOwnChildren", "PopulationPercentWhiteAlone", "AvailableHomeEquityInThousands", "AvgVehiclesPerOccupiedUnit", "DwellingType", "AdvantageDwellingTypeInd", "HomeOwnerRenterCode", "MedianValueOwnerOccupiedHousingUnits", "YearHomeBuilt", "LivingAreaSquareFootageRange", "LotCode", "HomeSaleDate", "HomeSalePriceinThousands", "HomeMarketValueTaxRecord", "MortgageDate", "OriginalMortgageAmount", "FirstMortgageAmountInThousands", "SecondMortgageAmountinThousands", "MortgageLoantypeorRefinance", "MortgageInterestRateorRefinance", "MortgageInterestRateTypeorRefinance", "RefinanceInd", "HomeEquityLoanDate", "HomeEquityLoaninThousands", "HomeEquityLoanInd", "TargetHomeMarketValueOrig", "TargetHomeMarketValue", "TargetHomeMarketValueType", "HousingUnitsPercentOwnerOccupied", "HousingUnitsPercentOneUnitDetached", "HousingUnitsPercentBuilt2000To2004", "HousingUnitsPercentBuilt2005OrLater", "TypeOfCreditCardAmericanExpress", "TypeOfCreditCardAnyCreditCard", "CreditCardUsageBankCard", "TypeOfCreditCardCatalogShowroom", "TypeOfCreditCardComputerElectronic", "TypeOfCreditCardDebitCard", "CreditCardUsageFinanceCoCard", "TypeOfCreditCardFurniture", "TypeOfCreditCardGrocery", "TypeOfCreditCardHomeImprovement", "TypeOfCreditCardHomeOfficeSupply", "TypeOfCreditCardLowEndDepartmentStore", "TypeOfCreditCardMainStreetRetail", "TypeOfCreditCardMastercard", "TypeOfCreditCardMembershipWarehouse", "CreditCardUsageMiscellaneous", "CreditCardUsageOilGasCard", "TypeOfCreditCardSpecialtyApparel", "TypeOfCreditCardSportingGoods", "CreditCardUsageStandardRetail", "CreditCardUsageStandardSpecialtyCard", "CreditCardUsageTravelEntertainment", "TypeOfCreditCardTVMailOrder", "CreditCardUsageUpscaleRetail", "CreditCardUsageUpscaleSpecRetail", "TypeOfCreditCardVisa", "StatusCodeOfRecords", "FileCode", "Fraction", "PostOfficeName", "Niches2", "MailResponsiveInd", "FirstName2", "MiddleNameInitial2", "Apider2", "Age2", "BirthYear2", "BirthMonth2", "TitleCode2", "FirstName3", "MiddleNameInitial3", "Apider3", "Age3", "BirthYear3", "BirthMonth3", "FirstName4", "MiddleNameInitial4", "Apider4", "Age4", "BirthYear4", "BirthMonth4", "FirstName5", "MiddleNameInitial5", "Apider5", "Age5", "BirthYear5", "BirthMonth5"

  - `OrderBy` (array)
    Specify the desired column to order the responses by.

  - `OrderBy.column` (string)

  - `OrderBy.sortorder` (string)
    Enum: "ASC", "DESC"

## Response 200 fields (application/json):

  - `JobId` (string)
    The JobId to be used to purchase and access the full dataset.

  - `Count` (integer)
    Number of records returned by the query.

  - `ResultCode` (string)
    Success or Error codes based on the response/request.

  - `Sample` (array)
    A 10 record sample response.

## Response 400 fields (application/json):

  - `type` (string)
    The type of error that occurred.

  - `title` (string)
    A short summary of the error.

  - `status` (integer)
    The HTTP status code for the error.

  - `errors` (object)

  - `errors.$.<PropertyName>` (array)
    A detailed message about the error.

  - `traceId` (string)
    A unique identifier for the request, useful for debugging.