# Get a paginated result view of new movers 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 /NewMovers/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: - CensusKey - Zips - Cities - Radius - ShapeWKTs - `Includes.CensusKey` (array) A list of CensusKeys. - `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.MelissaAddressKey` (array) A list of Melissa address keys. - `Includes.BaseMelissaAddressKey` (array) A list of BaseMelissaAddressKeys. - `Includes.FullName` (array) A list of FullNames. - `Includes.FirstName` (array) A list of FirstNames. - `Includes.MiddleName` (array) A list of MiddleNames. - `Includes.LastName` (array) A list of LastNames. - `Includes.RBDI` (array) An RBDI code. - `Includes.AddressLines` (array) A list of Address Lines. - `Includes.State` (array) A list of States. - `Includes.Plus4` (array) A list of Plus4s. - `Includes.AddressKey` (array) A list of AddressKeys. - `Includes.ResultCodes` (array) A list of ResultCodes. - `Includes.Latitude` (array) A list of Latitudes. - `Includes.Longitude` (array) A list of Longitudes. - `Includes.PreviousMelissaAddressKey` (array) A list of PreviousMelissaAddressKeys. - `Includes.PreviousBaseMelissaAddressKey` (array) A list of PreviousBaseMelissaAddressKeys. - `Includes.PreviousAddressLine` (array) A list of PreviousAddressLines. - `Includes.PreviousSuite` (array) A list of PreviousSuites. - `Includes.PreviousCities` (array) A list of PreviousCities. - `Includes.PreviousCountyName` (array) A list of PreviousCountyNames. - `Includes.PreviousState` (array) A list of PreviousStates. - `Includes.PreviousZIPCode` (array) A list of PreviousZIPCodes. - `Includes.PreviousAddressKey` (array) A list of PreviousAddressKeys. - `Includes.PreviousPlus4` (array) A list of PreviousPlus4s. - `Includes.PreviousResultCodes` (array) A list of PreviousResultCodes. - `Includes.PreviousLatitude` (array) A list of PreviousLatitudes. - `Includes.PreviousLongitude` (array) A list of PreviousLongitudes. - `Includes.PhoneNumber` (array) A list of PhoneNumbers. - `Includes.MoveEffectiveDate` (object) A date range with start and end dates. - `Includes.MoveEffectiveDate.StartDate` (string) - `Includes.MoveEffectiveDate.EndDate` (string) - `Includes.EstimatedHouseholdIncomeCode` (array) A list of EstimatedHouseholdIncomeCodes. - `Includes.AgeOfHouseholdCode` (array) A list of AgeOfHouseholdCodes. - `Includes.EstimatedHousingValueCode` (array) A list of EstimatedHousingValueCodes. - `Includes.HomeownershipCode` (array) A list of HomeownershipCodes. - `Includes.PresenceOfChildrenCode` (array) A list of PresenceOfChildrenCodes. - `Includes.DwellingCodeNormal` (array) A list of DwellingCodeNormals. - `Includes.DwellingCodeSpecific` (array) A list of Dwelling Specific Codes. - `Includes.MoveDistanceCode` (array) A list of MoveDistanceCodes. - `Includes.ConstructionTypeCode` (array) A list of ConstructionTypeCodes. - `Excludes` (object) Any parameter you would like to exclude in the query. - `Excludes.CensusKey` (array) A list of CensusKeys. - `Excludes.MelissaAddressKey` (array) A list of Melissa address keys. - `Excludes.BaseMelissaAddressKey` (array) A list of BaseMelissaAddressKeys. - `Excludes.FullName` (array) A list of FullNames. - `Excludes.FirstName` (array) A list of FirstNames. - `Excludes.MiddleName` (array) A list of MiddleNames. - `Excludes.LastName` (array) A list of LastNames. - `Excludes.RBDI` (array) An RBDI code. - `Excludes.AddressLines` (array) A list of Address Lines. - `Excludes.Cities` (array) A list of cities objects each containing City and State. - `Excludes.Cities.City` (string, required) - `Excludes.Cities.State` (string, required) - `Excludes.State` (array) A list of States. - `Excludes.Zips` (array) A list of Zips objects containing Zip codes and optionally Plus4. - `Excludes.Zips.Zip` (string, required) - `Excludes.Zips.Plus4` (string) - `Excludes.Plus4` (array) A list of Plus4s. - `Excludes.AddressKey` (array) A list of AddressKeys. - `Excludes.ResultCodes` (array) A list of ResultCodes. - `Excludes.Latitude` (array) A list of Latitudes. - `Excludes.Longitude` (array) A list of Longitudes. - `Excludes.PreviousMelissaAddressKey` (array) A list of PreviousMelissaAddressKeys. - `Excludes.PreviousBaseMelissaAddressKey` (array) A list of PreviousBaseMelissaAddressKeys. - `Excludes.PreviousAddressLine` (array) A list of PreviousAddressLines. - `Excludes.PreviousSuite` (array) A list of PreviousSuites. - `Excludes.PreviousCities` (array) A list of PreviousCities. - `Excludes.PreviousCountyName` (array) A list of PreviousCountyNames. - `Excludes.PreviousState` (array) A list of PreviousStates. - `Excludes.PreviousZIPCode` (array) A list of PreviousZIPCodes. - `Excludes.PreviousAddressKey` (array) A list of PreviousAddressKeys. - `Excludes.PreviousPlus4` (array) A list of PreviousPlus4s. - `Excludes.PreviousResultCodes` (array) A list of PreviousResultCodes. - `Excludes.PreviousLatitude` (array) A list of PreviousLatitudes. - `Excludes.PreviousLongitude` (array) A list of PreviousLongitudes. - `Excludes.PhoneNumber` (array) A list of PhoneNumbers. - `Excludes.MoveEffectiveDate` (object) A date range with start and end dates. - `Excludes.MoveEffectiveDate.StartDate` (string) - `Excludes.MoveEffectiveDate.EndDate` (string) - `Excludes.EstimatedHouseholdIncomeCode` (array) A list of EstimatedHouseholdIncomeCodes. - `Excludes.AgeOfHouseholdCode` (array) A list of AgeOfHouseholdCodes. - `Excludes.EstimatedHousingValueCode` (array) A list of EstimatedHousingValueCodes. - `Excludes.HomeownershipCode` (array) A list of HomeownershipCodes. - `Excludes.PresenceOfChildrenCode` (array) A list of PresenceOfChildrenCodes. - `Excludes.DwellingCodeNormal` (array) A list of DwellingCodeNormals. - `Excludes.DwellingCodeSpecific` (array) A list of Dwelling Specific Codes. - `Excludes.MoveDistanceCode` (array) A list of MoveDistanceCodes. - `Excludes.ConstructionTypeCode` (array) A list of ConstructionTypeCodes. - `Columns` (array, required) All [NewMovers Columns](https://docs.melissa.com/reference-data/data-retriever/data-retriever-reference-guide.html#newmovers) you want returned. Enum: "MelissaAddressKey", "BaseMelissaAddressKey", "FullName", "FirstName", "MiddleName", "LastName", "AddressLine", "City", "State", "ZIPCode", "Plus4", "AddressKey", "ResultCodes", "Latitude", "Longitude", "CensusKey", "PreviousMelissaAddressKey", "PreviousBaseMelissaAddressKey", "PreviousAddressLine", "PreviousSuite", "PreviousCity", "PreviousState", "PreviousZIPCode", "PreviousPlus4", "PreviousAddressKey", "PreviousResultCodes", "PreviousLatitude", "PreviousLongitude", "PhoneNumber", "MoveEffectiveDate", "EstimatedHouseholdIncomeCode", "AgeOfHouseholdCode", "EstimatedHousingValueCode", "HomeownershipCode", "PresenceOfChildrenCode", "DwellingCodeSpecific", "MoveDistanceCode", "MailResponsiveInd" - `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.$.` (array) A detailed message about the error. - `traceId` (string) A unique identifier for the request, useful for debugging.