Example JSON Result

[
     {
        "Cmf": "77770000",
        "vendorid": 623412300777889997,
        "vendornumber": 52848900,
        "name": "Lightspeed Vendor",
        "productdesc": "",
        "isactive": 1,
        "vendor1099": 0,
        "isforeign": 0,
        "vendoraddress1": "1234 S Main Street",
        "vendoraddress2": "",
        "city": "New York",
        "state": "NY",
        "zip": "10001",
        "country": "USA",
        "contact": "John Smith",
        "phone": "681-524-9820",
        "email": "vendor@vendoremail.com",
        "fax": "681-524-9822",
        "hasdistribution": 0,
        "distributiondesc": "",
        "lastmodifieddate": "2022-09-15T17:04:08.687",
        "lastmodifiedby": "LIGHTSPEED",
        "accountingstore": "LS Accounting",
        "associatedstore": "3PA Powersports"
    }
]