Backend Integration with exZact
Couple days ago we received an email from a consulting firm in Mexico asking how to use our JSON feed to integrate data into their CRM system. We send back the following PHP script:
<?
function jsonFeed($username, $password, $tableName, $nvp = ”)
{
$url = “https://www.iformbuilder.com/exzact“;
echo $url;
$jsonEndpoint = “$url/dataJSON.php”;
if ($nvp!=”) $nvpStr = “&$nvp”;
else $nvpStr = ”;
$nvpreq = “USERNAME=$username&PASSWORD=$password&TABLE_NAME=$tableName$nvpStr”;
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $jsonEndpoint);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, $nvpreq);
$httpResponse = curl_exec($ch);
if(!$httpResponse) {
echo ‘Error: ‘.curl_error($ch).’(’.curl_errno($ch).’)';
}
$dataFeed = json_decode($httpResponse, true);return $dataFeed;
}$d = jsonFeed(”demo”, “demoPassword”, “demoTableName”);
print_r($d);
?>
Here is what Anton had to say after implementing it:
I’m very exciting about this platform, it is the first that I try for iPhone and I can say its the best I’ve seen so far (website wise) and the most usable one plus it allows me to develop around it using any coding language to integrate to my legacy CRM systems. Integration was key to us and this platform demonstrated to be the perfect choice for us. ExZact was a no brainer!.
Anton Krall
Director General
Intruder Consulting
Wish you all the best Anton!
Sep 26, 2009
After more testing, We have now integrated ExZact to our CRM using MySQL as the middle man, inserting data directly from the json script into MySQL where the CRM pulls information from. We’ve also developed some scripts that makes use of prowl (the iPhone growl client) and now everytime a new form is entered, We can send out messages to all iPhone users letting them know of the event.
ExZact is the best data collect product out there because not only is a stable and well tested platform but because it lets you put together thing around it. Many other options have user friendly website that present integrated solutions at a much higher cost and they dont let you do anything outside the box. ExZact fives you the barebones tools that you need to code or develope software that interacts with it and for me that is way better than any closed-solution.
If you have any questions regarding the integration of ExZact with outside systems, please feel free to drop me a line through the ExZact Team or our website and I’ll try to help as much as I can.
Anton Krall
Director General
Intruder Consulting
http://www.intruder.com.mx
Mexico City, Mexico