Disclaimer

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, School District Map
  • (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-**
Disclaimer: Melissa Lookups API services are often changed and improved; while best attempts are made to preserve the structure of existing JSON/XML objects, material changes may be made without advance warning. Melissa strives to maintain consistent up-time for the Lookups API services, however, no guarantees are made as to occasional interruptions in availability. Further, Melissa takes reasonable best efforts to provide accurate data through the Lookups API services; however, no warranty is given as to the accuracy of any individual piece of data.
6.24.1 | green4west2 | 3.235.78.122 | | |