---
title: "Get a paginated result view of consumers"
method: POST
path: "/ConsumerTwo/doLookup"
tags: ["Consumer Two"]
---

# Get a paginated result view of consumers

`POST /ConsumerTwo/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

- RequestConsumerTwoDoLookup
  - `CustomerID` string, required — The [License Key](https://docs.melissa.com/melissa/license/license-information.html) issued by Melissa.
  - `Includes` ConsumerTwoIncludes, 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
    - `RBDI` string[] — A list of RBDI codes.
    - `FIPSCode` string[] — A list of FIPSCodes.
    - `AddressStreetName` object[] — A list of address street name objects.
      - `ZipCode` string
      - `Street` string
  - `Excludes` ConsumerTwoExcludes — 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
    - `RBDI` string[] — A list of RBDI codes.
    - `FIPSCode` string[] — A list of FIPSCodes.
    - `AddressStreetName` object[] — A list of address street name objects.
      - `ZipCode` string
      - `Street` string
  - `Columns` string[], required — All [Consumer Two Columns](https://docs.melissa.com/reference-data/data-retriever/data-retriever-reference-guide.html#consumer-two) 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.dev/melissa/apis/data-retriever.md) · [All operations](https://skmtc.dev/melissa/apis/data-retriever/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/melissa/data-retriever/revisions/5eb8fbc33099/schema)