--- title: "Get a paginated result view of new movers" method: POST path: "/NewMovers/doLookup" tags: ["NewMovers"] --- # Get a paginated result view of new movers `POST /NewMovers/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 - RequestNewMoversDoLookup - `CustomerID` string, required — The [License Key](https://docs.melissa.com/melissa/license/license-information.html) issued by Melissa. - `Includes` NewMoversIncludes, required — Any parameter you would like to include in the query. Requires at least one from: - CensusKey - Zips - Cities - Radius - ShapeWKTs - `CensusKey` string[] — A list of CensusKeys. - `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 - `MelissaAddressKey` string[] — A list of Melissa address keys. - `BaseMelissaAddressKey` string[] — A list of BaseMelissaAddressKeys. - `FullName` string[] — A list of FullNames. - `FirstName` string[] — A list of FirstNames. - `MiddleName` string[] — A list of MiddleNames. - `LastName` string[] — A list of LastNames. - `RBDI` string[] — A list of RBDI codes. - `AddressLines` string[] — A list of Address Lines. - `State` string[] — A list of States. - `Plus4` string[] — A list of Plus4s. - `AddressKey` string[] — A list of AddressKeys. - `ResultCodes` string[] — A list of ResultCodes. - `Latitude` string[] — A list of Latitudes. - `Longitude` string[] — A list of Longitudes. - `PreviousMelissaAddressKey` string[] — A list of PreviousMelissaAddressKeys. - `PreviousBaseMelissaAddressKey` string[] — A list of PreviousBaseMelissaAddressKeys. - `PreviousAddressLine` string[] — A list of PreviousAddressLines. - `PreviousSuite` string[] — A list of PreviousSuites. - `PreviousCities` string[] — A list of PreviousCities. - `PreviousCountyName` string[] — A list of PreviousCountyNames. - `PreviousState` string[] — A list of PreviousStates. - `PreviousZIPCode` string[] — A list of PreviousZIPCodes. - `PreviousAddressKey` string[] — A list of PreviousAddressKeys. - `PreviousPlus4` string[] — A list of PreviousPlus4s. - `PreviousResultCodes` string[] — A list of PreviousResultCodes. - `PreviousLatitude` string[] — A list of PreviousLatitudes. - `PreviousLongitude` string[] — A list of PreviousLongitudes. - `PhoneNumber` string[] — A list of PhoneNumbers. - `MoveEffectiveDate` MoveEffectiveDate — A date range with start and end dates. - `StartDate` string - `EndDate` string - `EstimatedHouseholdIncomeCode` string[] — A list of EstimatedHouseholdIncomeCodes. - `AgeOfHouseholdCode` integer[] — A list of AgeOfHouseholdCodes. - `EstimatedHousingValueCode` string[] — A list of EstimatedHousingValueCodes. - `HomeownershipCode` integer[] — A list of HomeownershipCodes. - `PresenceOfChildrenCode` integer[] — A list of PresenceOfChildrenCodes. - `DwellingCodeNormal` string[] — A list of DwellingCodeNormals. - `DwellingCodeSpecific` integer[] — A list of Dwelling Specific Codes. - `MoveDistanceCode` integer[] — A list of MoveDistanceCodes. - `ConstructionTypeCode` string[] — A list of ConstructionTypeCodes. - `Excludes` NewMoversExcludes — Any parameter you would like to exclude in the query. - `CensusKey` string[] — A list of CensusKeys. - `MelissaAddressKey` string[] — A list of Melissa address keys. - `BaseMelissaAddressKey` string[] — A list of BaseMelissaAddressKeys. - `FullName` string[] — A list of FullNames. - `FirstName` string[] — A list of FirstNames. - `MiddleName` string[] — A list of MiddleNames. - `LastName` string[] — A list of LastNames. - `RBDI` string[] — A list of RBDI codes. - `AddressLines` string[] — A list of Address Lines. - `Cities` object[] — A list of cities objects each containing City and State. - `City` string, required - `State` string, required - `State` string[] — A list of States. - `Zips` object[] — A list of Zips objects containing Zip codes and optionally Plus4. - `Zip` string, required - `Plus4` string - `Plus4` string[] — A list of Plus4s. - `AddressKey` string[] — A list of AddressKeys. - `ResultCodes` string[] — A list of ResultCodes. - `Latitude` string[] — A list of Latitudes. - `Longitude` string[] — A list of Longitudes. - `PreviousMelissaAddressKey` string[] — A list of PreviousMelissaAddressKeys. - `PreviousBaseMelissaAddressKey` string[] — A list of PreviousBaseMelissaAddressKeys. - `PreviousAddressLine` string[] — A list of PreviousAddressLines. - `PreviousSuite` string[] — A list of PreviousSuites. - `PreviousCities` string[] — A list of PreviousCities. - `PreviousCountyName` string[] — A list of PreviousCountyNames. - `PreviousState` string[] — A list of PreviousStates. - `PreviousZIPCode` string[] — A list of PreviousZIPCodes. - `PreviousAddressKey` string[] — A list of PreviousAddressKeys. - `PreviousPlus4` string[] — A list of PreviousPlus4s. - `PreviousResultCodes` string[] — A list of PreviousResultCodes. - `PreviousLatitude` string[] — A list of PreviousLatitudes. - `PreviousLongitude` string[] — A list of PreviousLongitudes. - `PhoneNumber` string[] — A list of PhoneNumbers. - `MoveEffectiveDate` MoveEffectiveDate — A date range with start and end dates. - `StartDate` string - `EndDate` string - `EstimatedHouseholdIncomeCode` string[] — A list of EstimatedHouseholdIncomeCodes. - `AgeOfHouseholdCode` integer[] — A list of AgeOfHouseholdCodes. - `EstimatedHousingValueCode` string[] — A list of EstimatedHousingValueCodes. - `HomeownershipCode` integer[] — A list of HomeownershipCodes. - `PresenceOfChildrenCode` integer[] — A list of PresenceOfChildrenCodes. - `DwellingCodeNormal` string[] — A list of DwellingCodeNormals. - `DwellingCodeSpecific` integer[] — A list of Dwelling Specific Codes. - `MoveDistanceCode` integer[] — A list of MoveDistanceCodes. - `ConstructionTypeCode` string[] — A list of ConstructionTypeCodes. - `Columns` string[], required — All [NewMovers Columns](https://docs.melissa.com/reference-data/data-retriever/data-retriever-reference-guide.html#newmovers) 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)