# Get a paginated result view of businesses 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 /Business/doLookup ## 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.Email` (array) Email. - `Includes.DeliverableEmail` (boolean) The deliverability status of the email address. - `Includes.MarketableEmail` (boolean) The marketable status of the email address. - `Includes.JobTitle` (array) Descriptive label of the individual's job. - `Includes.JobTitles` (array) Descriptive label of the individual's job. - `Includes.ManagementLevelLabel` (array) Describes the contact's position relative to others in their organization. - `Includes.ManagementLevelLabels` (array) Describes the contact's position relative to others in their organization. - `Includes.SICCode` (array) The primary line of business represented by a Standard Industrial Classification code. - `Includes.SecondarySICCode` (array) The line of business represented by a Standard Industrial Classification code. - `Includes.NAICSCode1` (array) The primary line of business represented by a North American Industry Classification System code. - `Includes.NAICSCode2` (array) The lines of business represented by North American Industry Classification System codes. - `Includes.NumberCorporateEmployees` (array) The actual, reported total number of employees at all locations in a corporate family. - `Includes.EstNumberCorporateEmployees` (array) Estimates the total number of employees at all locations in a corporate family. - `Includes.NumberLocalEmployees` (array) The number of employees who work at this place. - `Includes.EstNumberLocalEmployees` (array) Estimates the number of employees who work at this location. - `Includes.LocSalesVolume` (array) An estimation of the place's sales revenue. - `Includes.ContactEmail` (array) The email address of the contact. - `Includes.ContactDeliverableEmail` (boolean) The deliverability status of the email address. - `Includes.ContactMarketableEmail` (boolean) The marketable status of the email address. - `Includes.CBSACode` (array) The core based statistical area where the place is located. - `Includes.CBSALevel` (array) Information on whether the CBSA is a micropolitan or metropolitan area. - `Includes.CSACode` (array) The combined statistical area code where the place is located. - `Includes.ContactApider` (array) The gender of the individual. - `Includes.ContactJobFunctionId` (array) Describes the type of work an employee performs in their organization. - `Includes.ContactJobTitles` (array) Descriptive label of the individual's job. - `Includes.ContactJobTitlesCount` (array) The total number of Job titles associated with the contact. - `Includes.ContactManagementLevel` (array) Describes the contact's position relative to others in their organization. - `Includes.ContactProfessionalTitle` (array) The professional degree or title of the individual. - `Includes.ContactIndicator` (array) Information on whether the individual is the primary contact for the location. - `Includes.ContactSuppressedFields` (array) The fields on the individual that are suppressed. - `Includes.ContactTitleCodes` (array) A list of the individual's job titles. - `Includes.Website` (array) The primary homepage URL of the business. - `Includes.WorkAtHome` (boolean) The place is a work at home business. - `Includes.OpenedForBusinessOn` (array) The date when the place opened for business. - `Includes.EstimatedOpenedForBusinessLower` (array) Estimated opened for business lower. - `Includes.EstimatedOpenedForBusinessUpper` (array) Estimated opened for business upper. - `Includes.CorporateFranchising` (boolean) Determine if the corporation includes franchised branches. - `Includes.CorporateSalesRevenue` (array) The actual, reported sales revenue for the corporate family. - `Includes.EstimatedCorporateSalesRevenue` (array) Estimates total sales revenue for the corporate family. - `Includes.RestaurantCuisines` (array) The type of cuisine served at the place. - `Excludes` (object) Any parameter you would like to exclude in the query. - `Columns` (array, required) All [Business Columns](https://docs.melissa.com/reference-data/data-retriever/data-retriever-reference-guide.html#business) you want returned. Enum: "MelissaAddressKey", "BaseMelissaAddressKey", "Name", "AddressLine", "Suite", "City", "State", "ZIPCode", "Plus4", "DeliveryPoint", "AddressKey", "ResultCodes", "AddressStreetNumber", "AddressDirectionPrefix", "AddressStreetName", "AddressStreetSuffix", "AddressDirectionSuffix", "AddressSuiteName", "AddressSuiteNumber", "AddressTypeCode", "CarrierRoute", "FIPSCode", "CMRAInd", "AddressChangedDate", "LandmarkAddress", "MailingMelissaAddresskey", "MailingBaseMelissaAddresskey", "MailingAddressLine", "MailingAddressSuite", "MailingAddressCity", "MailingAddressState", "MailingAddressZIPCode", "MailingAddressPlus4", "MailingDeliveryPoint", "MailingAddressKey", "MailingResultCodes", "MailingAddressStreetNumber", "MailingAddressDirectionPrefix", "MailingAddressStreetName", "MailingAddressStreetSuffix", "MailingAddressDirectionSuffix", "MailingAddressSuiteName", "MailingAddressSuiteNumber", "MailingAddressTypeCode", "MailingAddressCarrierRoute", "MailingAddressFIPSCode", "MailingAddressCMRAInd", "PrimarySICCodeId", "SecondarySicCodeIds", "NAICSCode1", "NAICSCode2", "ContactFirstName", "ContactLastName", "PhoneNumber", "TollFreeNumber", "PhoneNumber2", "FaxNumber", "CorporateEmployeeCount", "EstimatedCorporateEmployeeCount", "LocationEmployeeCount", "EstimatedLocationEmployeeCount", "LocationSalesVolume", "ContactEmail", "ContactEmailDeliverableInd", "ContactEmailMarketableInd", "Latitude", "Longitude", "Censuskey", "CensusBlock", "CensusTract", "SgcDivision", "CBSACode", "CBSALevel", "CSACode", "MailingLatitude", "MailingLongitude", "MailingCensusKey", "ContactId", "ContactApider", "ContactJobFunctionId", "ContactJobTitles", "ContactJobTitlesCount", "ContactManagementLevel", "ContactProfessionalTitle", "ContactIndicator", "ContactSuppressedFields", "ContactTitleCodes", "Website", "FacebookURL", "TwitterUrl", "LinkedInURL", "YelpUrl", "PinterestUrl", "YoutubeUrl", "TumblrUrl", "FoursquareUrl", "InstagramUrl", "LogoUrl", "WebsiteKeywords", "LocationProfessionalSizeCode", "PlaceType", "AlternativeName", "HistoricalNames", "LegalNames", "BusinessID", "WorkAtHome", "InBusiness", "VerifiedOn", "DuplicateOf", "Suppressed", "SuppressedFields", "CreatedAt", "UpdatedAt", "OpenedForBusinessOn", "EstimatedOpenedForBusinessLower", "EstimatedOpenedForBusinessUpper", "LocationParentId", "LocationParentRelationship", "NumberOfTenants", "BusinessTypeIdsLabels", "ContactsCount", "OwnershipChangedOn", "HeadquartersId", "AncestorHeadquartersIds", "AncestorHeadquartersIdsCount", "UltimateHeadquartersId", "ChainIdLabels", "CorporateFranchising", "CorporateSalesRevenue", "EstimatedCorporateSalesRevenue", "BranchCount", "ForeignParentInd", "FortuneRanking", "StockExchangeCode", "CtockTickerSymbol", "TheCentralIndexKey", "AffiliationIdsLabels", "BrandIdsLabels", "CompanyDescription", "DressCode", "EquipmentRentals", "HasEcommerce", "LanguagesSpoken", "PriceRange", "ProfessionalSpecialty", "PublicAccess", "ShoppingCenterAtm", "OperatingHoursCount", "PaymentTypes", "InsurancesAccepted", "MedicareAccepted", "MedicaidAccepted", "ServiceAreaPostalCodes", "NbrcCorporationFilingType", "NbrcCorporateDate", "CarMakeIdsLabels", "ReligiousDenominationIdsLabels", "RestaurantCuisines", "RestaurantLimitedService", "RestaurantReservations", "RestaurantTakeout", "HappyHoursCount", "HotelCableTV", "HotelContinentalBreakfast", "HotelElevator", "HotelExerciseFacility", "HotelGuestLaundry", "HotelHotTub", "HotelIndoorPool", "HotelKitchens", "HotelOutdoorPool", "HotelPetFriendly", "HotelRoomService", "HospitalHasEmergencyRoom", "EstimatedFleetSizeLower", "EstimatedFleetSizeUpper", "GrowingBusinessGode", "SquareFootage", "WhiteCollarPercentage", "PopulationDensity", "PopulationCodeForZIP", "WealthyAreaInd", "PhysicianYearOfGraduation", "MedicalSchoolCode", "HospitalNumber", "Upin", "LicenseNumber", "StateOfLicense", "PhysicianYearOfBirth", "ResidencyHospitalCode", "ResidencyGraduationYear", "NationalProviderID", "MedicalDeaNumber", "AcceptingNewPatientsIndicator", "PhysicianPrimarySpecialtyCode", "PhysicianSecondarySpecialtyCode", "BoardCertifiedInd", "BusinessID", "FirstName", "LastName", "Apider", "Email", "EmailDeliverableInd", "EmailMarketableInd", "JobTitles", "JobTitlesCount", "ManagementLevelLabels", "TitleCodes", "TitleCodesLabels", "JobFunctionId", "LabelsJobFunctionId", "ProfessionalTitle", "LabelsProfessionalTitle", "PrimaryContactInd" - `Pagination` (object, required) Specify the desired page in the results to access. Pages are based on 100 records per page. - `Pagination.Page` (integer) ## 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.$.` (array) A detailed message about the error. - `traceId` (string) A unique identifier for the request, useful for debugging.