[{"branchName":"Charlotte","city":"Charlotte","country":"US","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":47,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/static_images/Mayer-Charlotte.jpg"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":47,"fieldName":"WAREHOUSE_STATES","customFieldvalue":"0"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":47,"fieldName":"WorkingHours"}],"distance":0.0,"email":"charlotte@mayerelectric.com","faxNum":"(704) 529-0255","latitude":"35.22719","locality":"Charlotte, NC 28208-5410","longitude":"-80.9199","note":"For emergencies only, please contact our main switchboard and you will hear instructions on how to contact us after hours or call 980-207-9012.","phone":"(704) 529-0529","state":"NC","street":"4201 Taggart Creek Road","tollFreeNum":"","warehouseImage":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/static_images/Mayer-Charlotte.jpg","workHour":"M-F 6:30am-4:30pm","zip":"28208-5410"},{"branchName":"Durham","city":"Durham","country":"US","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":43,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/static_images/Mayer-Durham.jpg"}],"distance":0.0,"email":"durham@mayerelectric.com","faxNum":"(919) 383-6473","latitude":"36.01715","locality":"Durham, NC 27705","longitude":"-78.93976","note":"Emergency contact: Robert Spizzo mobile (919) 491-1104.","phone":"(919) 383-1541","state":"NC","street":"3140 Hillsborough Road","tollFreeNum":"","warehouseImage":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/static_images/Mayer-Durham.jpg","workHour":"Monday-Friday 7:00am-5:00pm","zip":"27705"},{"branchName":"Greensboro","city":"Greensboro","country":"US","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":42,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/static_images/Mayer-Greensboro.jpg"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":42,"fieldName":"WAREHOUSE_STATES","customFieldvalue":"0"}],"distance":0.0,"email":"greensboro@mayerelectric.com","faxNum":"(336) 842-6085","latitude":"36.08273","locality":"Greensboro, NC 27406","longitude":"-79.7583","note":"For emergencies only, please contact our main switchboard and you will hear instructions on how to contact us after hours (or) Eddie Jones (Branch Mgr.) 336-908-1236, Chad Hatcher (Operations Mgr.) 336-362-0424","phone":"(336) 275-9603","state":"NC","street":"2510 Greengate Drive","tollFreeNum":"","warehouseImage":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/static_images/Mayer-Greensboro.jpg","workHour":"Monday-Friday 7:00am-5:00pm","zip":"27406"},{"branchName":"Greenville","city":"Greenville","country":"US","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":44,"fieldName":"WorkingHours"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":44,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/static_images/Mayer-Greenville-NC.jpg"}],"distance":0.0,"email":"greenvillenc@mayerelectric.com","faxNum":"(252) 756-0963","latitude":"35.57725","locality":"Greenville, NC 27834","longitude":"-77.39088","note":"George Futrell (Branch Mgr) 252-503-5281, Brian Murphy (Operations Mgr) 919-730-2720","phone":"(252) 756-5506","state":"NC","street":"1512 Hooker Road","tollFreeNum":"","warehouseImage":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/static_images/Mayer-Greenville-NC.jpg","workHour":"Monday-Friday 7:00am-5:00pm","zip":"27834"},{"branchName":"Wilmington","city":"Wilmington","country":"US","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":50,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/static_images/Mayer-Wilmington.jpg"}],"distance":0.0,"email":"wilmington@mayerelectric.com","faxNum":"(910) 251-1867","latitude":"34.250369","locality":"Wilmington, NC 28405","longitude":"-77.919243","note":"Emergency Contact:Mike Futrell Cell (910) 620-1602","phone":"(910) 251-9700","state":"NC","street":"1150 N 23rd Street","tollFreeNum":"","warehouseImage":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/static_images/Mayer-Wilmington.jpg","workHour":"Monday-Friday 7:00am-5:00pm","zip":"28405"}]

database

$googleSpreadSheetUrl