I’m the process of evaluating HelpSpot and I have a problem/question using Livelookup to retrieve information from a MySQL database.
Basically, I’m using the file “live_lookup_mysql.php” as guideline but what it seems not to be working is the initial “LIVE LOOKUP LOGIC” where the script is supposed to receive the field(s) from HelpSpot. So, I fill in the customer id (1001) in the customer tab and then I hit the LiveLookup tab but the result from Livelookup is always empty (no customers found).
Now, if I just go to the script and hardcode the filter variable like:
$filter = ‘customer_id=1001’
Then, Livelookup works like a charm (of course, always retrieving the info for the user with id 1001)… my point here is just to prove that once the $filter variable is set to a correct value, the script interaction with the remote mysql db retrieving information works fine.
My Livelookup configuration:
Automatically run: no (I run it hitting the livelookup tab)
Lookup via: HTTP GET
Path to script: http://… (it’s set correctly since the script works when $filter is hardcoded)
XML char encod: iso-8859-1 (which matches the script)