For Developers

Q. How to get JSON, XML and Excel files without clicking the button?

  • put "&fmt=format_type" to the end of the original query string.
  • format_types 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?fullName=&company=&addressLine1=1+Civic+Center+Plaza&city=Irvine&state=CA&postalCode=92606&melissaAddressKey=&phoneNumber=&emailAddress=&socialSecurity=&freeForm=
    JSON format: https://www.melissa.com/v2/lookups/personator/index?fullName=&company=&addressLine1=1+Civic+Center+Plaza&city=Irvine&state=CA&postalCode=92606&melissaAddressKey=&phoneNumber=&emailAddress=&socialSecurity=&freeForm=&fmt=json
    XML format: https://www.melissa.com/v2/lookups/personator/index?fullName=&company=&addressLine1=1+Civic+Center+Plaza&city=Irvine&state=CA&postalCode=92606&melissaAddressKey=&phoneNumber=&emailAddress=&socialSecurity=&freeForm=&fmt=xml
v2019071901 | green12 | 54.81.69.220