[Freeswitch-users] get info from DB into channel variable in xml dialplan

[Abaci]

I was wondering if there is a way to do it using curl without lua

On 6/18/2012 5:00 PM, Avi Marcus wrote:
> lua is a lightweight option that can do sql or curl.
>
> -Avi
>
>
> On Mon, Jun 18, 2012 at 11:50 PM, Abaci <abaci64 at gmail.com 
> <mailto:abaci64 at gmail.com>> wrote:
>
>     We are looking for a way to set a few variables in the XML
>     dialplan with information stored in a MySQL DB, the simplest seems
>     to be to use mod_odbc_query which will set channel variables (see
>     http://wiki.freeswitch.org/wiki/Mod_odbc_query#APP), problem is
>     that we prefer not to access the DB directly from xml.
>     The other option is to use mod_curl which gets the result into a
>     channel variable named 'curl_response_data', problem is that we
>     have multiple values that we need in separate channel variables,
>     and I can't find any documentation on how to do that, is there any
>     way to do this using json etc?
>
>
>
>
>     _________________________________________________________________________
>     Professional FreeSWITCH Consulting Services:
>     consulting at freeswitch.org <mailto:consulting at freeswitch.org>
>     http://www.freeswitchsolutions.com
>
>     
>     
>
>     Official FreeSWITCH Sites
>     http://www.freeswitch.org
>     http://wiki.freeswitch.org
>     http://www.cluecon.com
>
>     Join Us At ClueCon - Aug 7-9, 2012
>
>     FreeSWITCH-users mailing list
>     FreeSWITCH-users at lists.freeswitch.org
>     <mailto:FreeSWITCH-users at lists.freeswitch.org>
>     http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>     UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>     http://www.freeswitch.org
>
>
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> Join Us At ClueCon - Aug 7-9, 2012
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20120618/8be2c12f/attachment-0001.html