# Get a paginated result view of consumers

This endpoint returns a paginated result view of the request. This can sometimes take awhile and should be used after DoCount has been used to filter down your dataset.

Endpoint: POST /Consumer/doLookup

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

  - `Includes.AgeRange` (object)
    The specified age range

  - `Includes.AgeRange.minimum` (integer)

  - `Includes.AgeRange.maximum` (integer)

  - `Includes.AgeRangeMale` (object)
    The specified male age range

  - `Includes.AgeRangeMale.minimum` (integer)

  - `Includes.AgeRangeMale.maximum` (integer)

  - `Includes.AgeRangeFemale` (object)
    The specified female age range

  - `Includes.AgeRangeFemale.minimum` (integer)

  - `Includes.AgeRangeFemale.maximum` (integer)

  - `Includes.AgeRangeUnknownGender` (object)
    The specified unknown gender age range

  - `Includes.AgeRangeUnknownGender.minimum` (integer)

  - `Includes.AgeRangeUnknownGender.maximum` (integer)

  - `Includes.NetWorthGoldRank` (array)
    The specified net worth gold rank

  - `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.Cities` (array)
    A list of cities objects each containing City and State.

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

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

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

  - `Excludes.AgeRange` (object)
    The specified age range

  - `Excludes.AgeRangeMale` (object)
    The specified male age range

  - `Excludes.AgeRangeFemale` (object)
    The specified female age range

  - `Excludes.AgeRangeUnknownGender` (object)
    The specified unknown gender age range

  - `Excludes.NetWorthGoldRank` (array)
    The specified net worth gold rank

  - `Columns` (array, required)
    All [Consumer Columns](https://docs.melissa.com/reference-data/data-retriever/data-retriever-reference-guide.html#consumer-one) you want returned.
    Enum: "MelissaAddressKey", "BaseMelissaAddressKey", "TitlePrefixInd", "FirstName", "MiddleNameInitial", "LastName", "FullName", "NameSuffix", "AddressLine", "Suite", "City", "State", "ZIPCode", "Plus4", "DeliveryPoint", "AddressKey", "ResultCodes", "AddressStreetNumber", "AddressDirectionPrefix", "AddressStreetName", "AddressStreetSuffix", "AddressDirectionSuffix", "AddressSuiteName", "AddressSuiteNumber", "AddressTypeInd", "AddressType", "RBDI", "WalkSequencenumber", "CarrierRoute", "FIPSCode", "FIPSMCDCode", "PlaceCode", "Latitude", "Longitude", "CensusKey", "CBSACode", "OccupationCode1", "GenderCode", "ContactAgeGroup", "BirthYear1", "BirthMonth1", "BirthDay1", "Gender1", "PoliticalPartyCode1", "EducationCode1", "PhoneNumber", "PhonePresenceInd", "Email", "EmailResultLevel", "eMailAppendAvailableInd", "AgeLessthan1Ind", "Age1Ind", "Age2Ind", "Age3Ind", "Age4Ind", "Age5Ind", "Age6Ind", "Age7Ind", "Age8Ind", "Age9Ind", "Age10Ind", "Age11Ind", "Age12Ind", "Age13Ind", "Age14Ind", "Age15Ind", "Age16Ind", "Age17Ind", "Age18Ind", "SupportsChildrensInd", "NumberOfChildrenCode", "PresenceOfChildrenInd", "NumberOfAdultsCode", "HouseholdSizeCode", "EstimatedHomeMarketValueCode", "HomeOwnerRenterCode", "IncomeEstimatedHousehold", "HouseholdAgeCode", "Age0to2MaleInd", "Age0to2FemaleInd", "Age0to2UnknownGenderInd", "Age3to5MaleInd", "Age3to5FemaleInd", "Age3to5UnknownGenderInd", "Age6to10MaleInd", "Age6to10FemaleInd", "Age6to10UnknownGenderInd", "Age11to15MaleInd", "Age11to15FemaleInd", "Age11to15UnknownGenderInd", "Age16to17MaleInd", "Age16to17FemaleInd", "Age16to17UnknownGenderInd", "Age18to24MaleInd", "Age18to24FeMaleInd", "Age18to24UnknownGenderInd", "Age25to34MaleInd", "Age25to34FeMaleInd", "Age25to34UnknownGenderInd", "Age35to44MaleInd", "Age35to44FeMaleInd", "Age35to44UnknownGenderInd", "Age45to54MaleInd", "Age45to54FeMaleInd", "Age45to54UnknownGenderInd", "Age55to64MaleInd", "Age55to64FeMaleInd", "Age55to64UnknownGenderInd", "Age65to74MaleInd", "Age65to74FeMaleInd", "Age65to74UnknownGenderInd", "Age75MaleInd", "Age75FeMaleInd", "Age75UnknownGenderInd", "YoungAdultinHouseholdInd", "GenerationsInHouseholdCount", "SeniorAdultInHouseholdInd", "HomeLengthofResidenceCode", "CensusMedianHomeValue", "CensusMedianHouseholdIncome", "DwellingTypeCode", "AdvantageDwellingTypeInd", "HomeYearBuiltCode", "HomePropertyTypeCode", "HomePurchaseDate", "NewToBuildIndicator", "HomeLotSquareFootageRangesCode", "HomePurchaseAmountRangesCode", "HomePropertyTypeDetailCode", "HomeLTVEstimatedRangesCode", "HomeLTVEstimatedActualCode", "MailOrderDonorInd", "LotCarrierlineOfTravelCode", "FileDate", "CompanyId", "IndividualId", "ConfidenceUseCode", "SupportsCharitableInd", "SupportsAnimalWelfareInd", "SupportsArtsOrCulturalInd", "SupportsEnvironmentOrWildlifeInd", "SupportsHealthInd", "SupportsInternationalAidInd", "SupportsPoliticalInd", "SupportsPoliticalConservativeInd", "SupportsPoliticalLiberalInd", "SupportsReligiousInd", "SupportsVeteransInd", "BusinessOwnerCode", "SingleParentInd", "OccupationDetailInputIndividualCode", "InferredHouseholdRankCode", "GreenLivingInd", "AgeinTwoYearIncrInputIndReseller", "SmallOfficeHouseholdInd", "TruckOwnerInd", "InvestmentPropertiesOwnedEstimated", "WorkingWomanInd", "BankCardHolderInd", "GasDepartmentRetailCardHolderInd", "TravelAndEntCardHolderInd", "CreditCardHolderUnknownTypeInd", "PremiumCardHolderInd", "UpscaleDeptStoreCardHolderInd", "OccupationInputIndividualCode", "OverallMatchInd", "OwnerRenterCode", "CatOwnerInd", "DogOwnerInd", "OtherPetOnwerInd", "MaritalStatus", "MailOrderResponderInd", "SupportsOtherInd", "CongressionalDistrictCode", "MotorcycleOwnerInd", "RecreationalVehicleInd", "PoliticalPartyInputIndividualCode", "BaseRecordVerificationDate", "VehicleNewCarBuyer", "VehicleKnownOwnedNumber", "CreditCardUserInd", "CRAIncomeClassificationCode", "EducationInputIndividualCount", "PrecisionLevelCode", "WirelessProductBuyerInd", "FashionInd", "HistoyMilitaryInd", "CelebritiesInd", "CurrentAffairsPoliticsInd", "TheaterPerformingArtsInd", "CommunityCharitiesInd", "ReligiousInspirationalInd", "ScienceSpaceInd", "CareerImprovementInd", "ArtsInd", "ReadingGeneralInd", "ReadingBestSellersInd", "ReadingReligiousInspirationalInd", "ReadingScienceFictionInd", "ReadingMagazinesInd", "ReadingAudioBooksInd", "CookingGeneralInd", "CookingGourmetInd", "CookingLowFatInd", "FoodsNaturalInd", "TravelDomesticInd", "RecreationalVehiclesInd", "TravelFamilyVacationsInd", "TravelCruiseVacationsInd", "ExerciseRunningJoggingInd", "ExerciseWalkingInd", "CraftsInd", "PhotographyInd", "AviationInd", "AutoWorkInd", "SewingKnittingNeedleworkInd", "WoodWorkingInd", "GamesBoardGamesPuzzlesInd", "MusicPlayerInd", "MusicCollectorInd", "MusicAvidListenerInd", "MovieCollectorInd", "TVCableInd", "MoviesatHomeInd", "TVSatelliteDishInd", "DietingWeightLossInd", "SelfImprovementInd", "ParentingInd", "ChildrensInterestsInd", "GrandChildrenInd", "SpectatorSportsRacingInd", "SpectatorSportsFootballInd", "NetWorthGoldRank"

  - `Pagination` (object, required)
    Specify the desired page in the results to access. Pages are based on 100 records per page.

  - `Pagination.Page` (integer)

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

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

  - `Results` (array)
    Returned records with requested Columns.

  - `Pagination` (object)
    The current page number and the next page number.

  - `Pagination.CurrentPage` (integer)

  - `Pagination.NextPage` (integer)

  - `Pagination.TotalPages` (integer)

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

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

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