--- title: "Get a paginated result view of businesses" method: POST path: "/Business/doLookup" tags: ["Business"] --- # Get a paginated result view of businesses `POST /Business/doLookup` 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. ## Headers - `Accept` 'application/json' | '*/*', required - `Content-Type` 'application/json', required ## Request body - RequestBusinessDoLookup - `CustomerID` string, required — The [License Key](https://docs.melissa.com/melissa/license/license-information.html) issued by Melissa. - `Includes` BusinessIncludes, required — Any parameter you would like to include in the query. Requires at least one from: - Zips - Cities - Radius - ShapeWKTs - `Zips` object[] — A list of Zips objects containing Zip codes and optionally Plus4. - `Zip` string, required - `Plus4` string - `Cities` object[] — A list of cities objects each containing City and State. - `City` string, required - `State` string, required - `Radius` Radius — A Radius object containing a Latitude, Longitude, and Distance represented in miles. - `Latitude` number, required - `Longitude` number, required - `Distance` number, required - `ShapeWKTs` string[] — A list of WKT polygon strings - `PrimarySICCodeId` string[] — The primary line of business represented by a Standard Industrial Classification code. - `RBDI` string[] — A list of RBDI codes. - `FIPSCode` string[] — A list of FIPSCodes. - `Email` string[] — Email. - `EmailDeliverableInd` string[] — The deliverability status of the email address. - `EmailMarketableInd` boolean — The marketable status of the email address. - `JobTitles` string[] — Descriptive label of the individual's job. - `JobFunctionId` string[] — Indicator of the individual's job function. - `LabelsJobFunctionId` string[] — Descriptive label of the individual's job function. - `ProfessionalTitle` string[] — The individual's professional title. - `LabelsProfessionalTitle` string[] — Descriptive label of the individual's professional title. - `LanguagesSpoken` string[] — Descriptive label of the individual's job. - `ManagementLevelLabels` string[] — Describes the contact's position relative to others in their organization. - `TitleCodes` string[] — A list of title codes. - `TitleCodesLabels` string[] — A list of title codes labels. - `SecondarySicCodeIds` string[] — The line of business represented by a Standard Industrial Classification code. - `NAICSCode1` string[] — The primary line of business represented by a North American Industry Classification System code. - `NAICSCode2` string[] — The lines of business represented by North American Industry Classification System codes. - `CorporateEmployeeCount` CorporateEmployeeCount — The actual, reported total number of employees at all locations in a corporate family. - `minimum` integer - `maximum` integer - `EstimatedCorporateEmployeeCount` EstimatedCorporateEmployeeCount — Estimates the total number of employees at all locations in a corporate family. - `minimum` integer - `maximum` integer - `LocationEmployeeCount` LocationEmployeeCount — The number of employees who work at this place. - `minimum` integer - `maximum` integer - `EstimatedLocationEmployeeCount` EstimatedLocationEmployeeCount — Estimates the number of employees who work at this location. - `minimum` integer - `maximum` integer - `LocationSalesVolume` LocationSalesVolume — An estimation of the place's sales revenue. - `minimum` integer - `maximum` integer - `ContactEmail` string[] — The email address of the contact. - `ContactEmailDeliverableInd` string[] — The deliverability status of the email address. - `ContactEmailMarketableInd` boolean — The marketable status of the email address. - `CBSACode` string[] — The core based statistical area where the place is located. - `CBSALevel` string[] — Information on whether the CBSA is a micropolitan or metropolitan area. - `CSACode` string[] — The combined statistical area code where the place is located. - `ContactGender` string[] — The gender of the individual. - `ContactJobFunctionId` string[] — Describes the type of work an employee performs in their organization. - `ContactJobTitles` string[] — Descriptive label of the individual's job. - `ContactJobTitlesCount` string[] — The total number of Job titles associated with the contact. - `ContactManagementLevel` string[] — Describes the contact's position relative to others in their organization. - `ContactProfessionalTitle` string[] — The professional degree or title of the individual. - `ContactIndicator` string[] — Information on whether the individual is the primary contact for the location. - `ContactSuppressedFields` string[] — The fields on the individual that are suppressed. - `ContactTitleCodes` string[] — A list of the individual's job titles. - `Website` string[] — The primary homepage URL of the business. - `WorkAtHome` boolean — The place is a work at home business. - `OpenedForBusinessOn` string[] — The date when the place opened for business. - `EstimatedOpenedForBusiness` EstimatedOpenedForBusiness — Range of the estimated date when the place opened for business. - `minimum` string - `maximum` string - `CorporateFranchising` boolean — Determine if the corporation includes franchised branches. - `CorporateSalesRevenue` string[] — The actual, reported sales revenue for the corporate family. - `EstimatedCorporateSalesRevenue` string[] — Estimates total sales revenue for the corporate family. - `RestaurantCuisines` string[] — The type of cuisine served at the place. - `Excludes` BusinessExcludes — Any parameter you would like to exclude in the query. - `Zips` object[] — A list of Zips objects containing Zip codes and optionally Plus4. - `Zip` string, required - `Plus4` string - `Cities` object[] — A list of cities objects each containing City and State. - `City` string, required - `State` string, required - `PrimarySICCodeId` string[] — The primary line of business represented by a Standard Industrial Classification code. - `RBDI` string[] — A list of RBDI codes. - `FIPSCode` string[] — A list of FIPSCodes. - `Email` string[] — Email. - `EmailDeliverableInd` string[] — The deliverability status of the email address. - `EmailMarketableInd` boolean — The marketable status of the email address. - `JobTitles` string[] — Descriptive label of the individual's job. - `JobFunctionId` string[] — Indicator of the individual's job function. - `LabelsJobFunctionId` string[] — Descriptive label of the individual's job function. - `ProfessionalTitle` string[] — The individual's professional title. - `LabelsProfessionalTitle` string[] — Descriptive label of the individual's professional title. - `LanguagesSpoken` string[] — Descriptive label of the individual's job. - `ManagementLevelLabels` string[] — Describes the contact's position relative to others in their organization. - `TitleCodes` string[] — A list of title codes. - `TitleCodesLabels` string[] — A list of title codes labels. - `SecondarySicCodeIds` string[] — The line of business represented by a Standard Industrial Classification code. - `NAICSCode1` string[] — The primary line of business represented by a North American Industry Classification System code. - `NAICSCode2` string[] — The lines of business represented by North American Industry Classification System codes. - `CorporateEmployeeCount` CorporateEmployeeCount — The actual, reported total number of employees at all locations in a corporate family. - `minimum` integer - `maximum` integer - `EstimatedCorporateEmployeeCount` EstimatedCorporateEmployeeCount — Estimates the total number of employees at all locations in a corporate family. - `minimum` integer - `maximum` integer - `LocationEmployeeCount` LocationEmployeeCount — The number of employees who work at this place. - `minimum` integer - `maximum` integer - `EstimatedLocationEmployeeCount` EstimatedLocationEmployeeCount — Estimates the number of employees who work at this location. - `minimum` integer - `maximum` integer - `LocationSalesVolume` LocationSalesVolume — An estimation of the place's sales revenue. - `minimum` integer - `maximum` integer - `ContactEmail` string[] — The email address of the contact. - `ContactEmailDeliverableInd` string[] — The deliverability status of the email address. - `ContactEmailMarketableInd` boolean — The marketable status of the email address. - `CBSACode` string[] — The core based statistical area where the place is located. - `CBSALevel` string[] — Information on whether the CBSA is a micropolitan or metropolitan area. - `CSACode` string[] — The combined statistical area code where the place is located. - `ContactGender` string[] — The gender of the individual. - `ContactJobFunctionId` string[] — Describes the type of work an employee performs in their organization. - `ContactJobTitles` string[] — Descriptive label of the individual's job. - `ContactJobTitlesCount` string[] — The total number of Job titles associated with the contact. - `ContactManagementLevel` string[] — Describes the contact's position relative to others in their organization. - `ContactProfessionalTitle` string[] — The professional degree or title of the individual. - `ContactIndicator` string[] — Information on whether the individual is the primary contact for the location. - `ContactSuppressedFields` string[] — The fields on the individual that are suppressed. - `ContactTitleCodes` string[] — A list of the individual's job titles. - `Website` string[] — The primary homepage URL of the business. - `WorkAtHome` boolean — The place is a work at home business. - `OpenedForBusinessOn` string[] — The date when the place opened for business. - `EstimatedOpenedForBusiness` EstimatedOpenedForBusiness — Range of the estimated date when the place opened for business. - `minimum` string - `maximum` string - `CorporateFranchising` boolean — Determine if the corporation includes franchised branches. - `CorporateSalesRevenue` string[] — The actual, reported sales revenue for the corporate family. - `EstimatedCorporateSalesRevenue` string[] — Estimates total sales revenue for the corporate family. - `RestaurantCuisines` string[] — The type of cuisine served at the place. - `Columns` string[], required — All [Business Columns](https://docs.melissa.com/reference-data/data-retriever/data-retriever-reference-guide.html#business) you want returned. - `Pagination` Pagination, required — Specify the desired page in the results to access. Pages are based on 100 records per page. - `Page` integer - `OrderBy` object[] — Specify the desired column to order the responses by. - `column` string - `sortorder` 'ASC' | 'DESC' ## Response `200` Successful response - ResponseDoLookup - `Count` integer — Number of records returned by the query. - `Results` object[] — Returned records with requested Columns. - `Pagination` object — The current page number and the next page number. - `CurrentPage` integer - `NextPage` integer - `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. - `Message` string — Success or Error message associated with the result code. ## Other responses - `400` — Bad Request --- [API](https://skmtc.net/melissa/apis/data-retriever.md) · [All operations](https://skmtc.net/melissa/apis/data-retriever/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/melissa/data-retriever/versions/5eb8fbc33099/schema)