Finesse screen pop from SQL database

[oliverpowell]

We have a customer that will have a SQL database that they want Finesse to contact with a ANI to bring back certain account details?

I guess I can use a screen pop gadget to use values from callvariables, then form a http request for the data, but can anyone suggest a form in which to view the response?

[dekwan · Accepted solution]

How about creating a custom gadget? Take a look at the Screenpop Sample Gadget from the Finesse Sample Gadgets page (If you are using a version prior to Finesse 11.0, go to the archives page) to see how to pull the ANI value. This sample gadget uses a callvariable to do a browser search. This concept can be extended to fit your needs.

You can build a custom gadget where you grab the ANI value and do the HTTP request to the SQL database. Then using javascript, you can parse the response and display the values in the custom gadget.

[bruce.finney]

Denis,

Do you happen to have an example of making the HTTP request to the SQL database?  Everything else I've figured out how to do.

Thanks

[dekwan]

Hi Bruce,

Unfortunately I don't.

Thanx,

Denise

[smeegada1]

Hi Bruce,

I have the same requirment and taught of checking how yours is done.Any info is appreciated.