Skip to content

Data Retriever

Important Announcements

None

General Information

Build History

9.2.0.10

Released on: February 4, 2026

Added

  • OrderBy support added to DoLookup and GetCount.
  • Customers can optionally include an orderby parameter to control result sorting.
  • The orderby parameter accepts an array of column definitions.
  • Each order-by object includes a column name and an optional sortorder.
  • If sortorder is not supplied, it defaults to asc.
  • Multiple order-by clauses are supported.

  • Example: 

    "orderby": [
  { "column": "address", "sortorder": "desc" }
]

  • New MAK filters added:

  • BaseRecord (bit) 
    "BaseRecord": [true, null]
  • CommercialMailReceivingAgency (bit) 
    "CommercialMailReceivingAgency": [true, null]
  • NonUSPS (bit) 
    "NonUSPS": [true, null]
  • GeoLevel (string, supports multiple values) 
    "GeoLevel": ["B", "5"]

  • ResultCodes (string, supports multiple values) 

    "ResultCodes": ["AS17"]

  • Boolean-style filters updated to use true boolean values.

  • Boolean filters now accept true, false, or null instead of "0" / "1" string values.
  • Applies to MAK and New Movers.

  • Updated filters include:

    • POBoxStyleAddress 
      "POBoxStyleAddress": [null, false]
    • ZipIncludedIn3553 
      "ZipIncludedIn3553": [true, null]
    • DropInd 
      "DropInd": [false, null]
    • Throwback 
      "Throwback": [false, null]
    • DeliveryDaysFlag 
      "DeliveryDaysFlag": [true, null]
    • NonDeliveryDaysFlag 
      "NonDeliveryDaysFlag": [false, null]
    • NoStatInd 
      "NoStatInd": [true, null]
    • NoSecureLocation 
      "NoSecureLocation": [false, true]
    • DoorNotAccessible 
      "DoorNotAccessible": [false, true]
    • FalseTable 
      "FalseTable": [false, null]
    • MailResponsiveInd 
      "MailResponsiveInd": [true, null]

  • New business filter added:

  • PrimaryContactInd (bit) 

    "PrimaryContactInd": [true]

  • Enhanced result code responses.

  • API responses now return a descriptive message alongside the result code.
  • Example: 
    {
  "JobId": "abc123",
  "ResultCode": "LS01",
  "Message": "Success - Results found"
}

Fixed

  • Fixed an issue where radius- and shape-based queries could not be downloaded.
  • Fixed a bug where LE08 was returned on otherwise successful queries due to a silent royalty logging failure.
  • The request now correctly returns: 
    "LE08",
"Error - There was a problem inserting record into table"

Changed

  • Radius distance is now capped at 50 miles.
  • Requests exceeding this limit return: 
    "LE17",
"Error - Radius distance cannot exceed 50 miles"
  • Added new error codes for /Download endpoints:
  • LE14 — Download Error: JobId does not belong to the requesting customer
  • LE15 — Download Error: Requested row limit exceeds maximum allowed
  • LE16 — Download Error: Top must be a positive integer
  • Internal-only: Refactored query builder engine to fully parameterize all SQL queries.
  • Internal-only: Refactored Advanced Filter Options (AFO) connection logic so the SPA can use live AFO data.

Deprecated

  • None

Removed

  • None

Security

  • None

9.2.0.9

Released on: January 28, 2026

Added

  • Download (StreamFile) endpoint allowing customers to download results directly via /web/v1/Download/StreamFile.
  • Support for range-style filters that map to a min/max column pair, allowing customers to pass a single filter object.
  • EstimatedOpenForBusiness range-style filter using minimum / maximum values.
  • TitleCodes and TitleCodesInd filters added to the Business product.

Changed

  • Internal-only: Standardized centricity lists and mapping logic.
  • Internal-only: GetCount endpoints updated to log the correct product name.

Deprecated

  • None

Removed

  • None

Fixed

  • None

Security

  • None

9.2.0.7

Released on: January 12, 2026

Added

  • Internal refresh to ensure up-to-date data changes are reflected in real time.
  • Results per page support for pagination.
  • New error code GE15 (returned when users attempts to use a nonencrypted license key).
  • New error code LE12 (returned when both shape and radius are provided in the same query).

Changed

  • Business product filter / column names updated to align with Melissa canonical naming.
  • LocationEmployeeCount, EstimatedLocationEmployeeCount, and LocationSalesVolume filters now use numeric range conditions instead of string comparisons.
  • SecondarySicCodeIds filter matching updated to use like-string matching.
  • Several demographic filters now require numeric or boolean values instead of strings.

Deprecated

  • None

Removed

  • None

Fixed

  • None

Security

  • None

9.2.0.0

Released on: December 8, 2025

Added

  • DateAdded and AddressUpdatedDate filters added to MAK product.

Changed

  • Upgraded to .NET 9.0.

Deprecated

  • None

Removed

  • None

Fixed

  • None

Security

  • Upgraded to .NET 9.0

8.2.0.2

Released on: November 20, 2025

Added

  • Support for null value filters passed as the string "null", now interpreted as actual null values.
  • Full polygon support, including:
  • Single polygons
  • Multi-polygons
  • Polygons with inner holes
  • Standardized ShapeWKTs input to replace legacy shape handling.
  • Additional Business-related filters.
  • BoolStringConditions for handling three-state boolean values (true, false, null).

Changed

  • Business-related filters were updated and validated to align with MelissaColumnNames.
  • Shape handling has migrated from Shapes to ShapeWKTs.

Deprecated

  • The Shapes filter is deprecated and replaced by ShapeWKTs.

Removed

  • The legacy Shapes filter.

Fixed

  • Fixed ORDER BY behavior affecting Radius queries.

Security

  • None

7.2.1.9

Released on: August 28, 2025

Added

  • Support for the PreviousCensusKey filter and output column.

Changed

  • Counties and PreviousCounties now return as objects instead of simple arrays, for example:
{
  "CountyName": "Orange County",
  "State": "CA"
}

Deprecated

  • None

Removed

  • None

Fixed

  • None

Security

  • None

7.2.1.8

Released on: August 19, 2025

Added

  • Support for Previous-based columns (e.g., PreviousState), including standalone lookup logic.

  • Supplemental centricities for Previous-based columns.

  • Zipcode-based anchoring for Radius queries.

  • Postman collections and calls to improve testing and validation.

  • Internal endpoint GET /web/v1/GetBuyableFields (SPA-only, not customer-facing).

Changed

  • Centricity options and behavior aligned with official documentation.

  • Radius query unit changed from meters to miles.

  • Phone-related columns now leverage mdColumns where applicable.

  • Improved union logic for combined shape, radius, and centricity queries.

  • Performance groundwork completed, including index testing and DBA requests (e.g., FIPS, County).

Deprecated

  • None

Removed

  • None

Fixed

  • Fixed MAK CountyName calls.

Security

  • None