Hello all,
I have written a function that will lookup city, state and county based off a zip code entry however I keep running into issues here. I contacted zoho support and they told me that there is no way for them to look up how much of the limit I have used however I noticed we have zoho enterprise edition and should have at least 200 calls. Below is the code I used and I counted the number of errors I had which is 106 records that didn't get updated. I checked the other 94 records and they weren't updated either. Not sure what else to do here. The code does work if I go into the system and updated a single record so not sure what's going on here. Any help is appreciated.
- pinresp=((getUrl("http://maps.googleapis.com/maps/api/geocode/xml?address=" + input.zipcode))).toString();
- city = pinresp.executeXPath("/GeocodeResponse/result/address_component[2]/long_name/text()");
- county = pinresp.executeXPath("/GeocodeResponse/result/address_component[3]/long_name/text()");
- state = pinresp.executeXPath("/GeocodeResponse/result/address_component[4]/long_name/text()");
- pAppId=toString(input.Application_Log_Id);
- upresp = zoho.crm.updateRecord("CustomModule5",pAppId,{ "City" : city, "County" : county, "State" : state });