Q. How to get JSON, XML and Excel outputs without clicking the format buttons in a web browser?

  • put "&fmt=format_type" to the end of the original query string.
  • format_type available: json, xml, excel
  • (Example) List of Carrier Routes in ZIP Code "92688"
    Original query string: https://www.melissa.com/v2/lookups/mapcartzip/zipcode?zipcode=92688
    JSON format: https://www.melissa.com/v2/lookups/mapcartzip/zipcode?zipcode=92688&fmt=json
    XML format: https://www.melissa.com/v2/lookups/mapcartzip/zipcode?zipcode=92688&fmt=xml
    Excel format: https://www.melissa.com/v2/lookups/mapcartzip/zipcode?zipcode=92688&fmt=excel
  • (Example) Personator result of address "1 Civic Center Plz, Irvine CA 92606"
    Original query string: https://www.melissa.com/v2/lookups/personator/index?addressLine1=1+Civic+Center+Plaza&city=Irvine&state=CA&postalCode=92606
    JSON format: https://www.melissa.com/v2/lookups/personator/index?addressLine1=1+Civic+Center+Plaza&city=Irvine&state=CA&postalCode=92606&fmt=json
    XML format: https://www.melissa.com/v2/lookups/personator/index?addressLine1=1+Civic+Center+Plaza&city=Irvine&state=CA&postalCode=92606&fmt=xml

Q. How to get JSON, XML and Excel outputs without signing in a web browser? (Sign in programmatically)

  • put "&fmt=format_type&id=license_key_using_credits" to the end of the original query string.
  • format_type available: json, xml, excel
  • license_key_using_credits can be found at My Account page or in the query string in a web browser after you click the JSON or XML buttons after login.
  • Supported Lookups:
    Address Check, Address Search, Carrier Route Maps, Carrier Routes by ZIP Code, Distance Between ZIPs,
    Climate Average, Global Phone Check, IP Location, Nonprofit Organization,
    Personator, Personator Search, Property Info, ZIP Code MAP, ZIP Codes by City
  • (Example) List of Carrier Routes in ZIP Code "92688"
    Original query string: https://www.melissa.com/v2/lookups/mapcartzip/zipcode?zipcode=92688
    JSON format: https://www.melissa.com/v2/lookups/mapcartzip/zipcode?zipcode=92688&fmt=json&id=AnJ0iuPsrTcabdwHUddEd**nSAwewXQ0PC2dxudAZ-**
    XML format: https://www.melissa.com/v2/lookups/mapcartzip/zipcode?zipcode=92688&fmt=xml&id=AnJ0iuPsrTcabdwHUddEd**nSAwewXQ0PC2dxudAZ-**
    Excel format: https://www.melissa.com/v2/lookups/mapcartzip/zipcode?zipcode=92688&fmt=excel&id=AnJ0iuPsrTcabdwHUddEd**nSAwewXQ0PC2dxudAZ-**
  • (Example) Personator result of address "1 Civic Center Plz, Irvine CA 92606"
    Original query string: https://www.melissa.com/v2/lookups/personator/index?addressLine1=1+Civic+Center+Plaza&city=Irvine&state=CA&postalCode=92606
    JSON format: https://www.melissa.com/v2/lookups/personator/index?addressLine1=1+Civic+Center+Plaza&city=Irvine&state=CA&postalCode=92606&fmt=json&id=AnJ0iuPsrTcabdwHUddEd**nSAwewXQ0PC2dxudAZ-**
    XML format: https://www.melissa.com/v2/lookups/personator/index?addressLine1=1+Civic+Center+Plaza&city=Irvine&state=CA&postalCode=92606&fmt=xml&id=AnJ0iuPsrTcabdwHUddEd**nSAwewXQ0PC2dxudAZ-**