data retrieved from external DB display on finese desktop page

[jaheshkhan]

I want to retrieve data from external Database based on calling number agent receive and display the data on finese agent destop page. Calling number will be there in the external database.

I already done with call variable layout. but Database multiple data records with same number. they want to display all those details on the agent desktop page.

I know how to retrieve data from external database. but dont know how to display that data on agent page while agent receive call?

Do I need to do it with gadget?

is there any other way?

Sample Database dataset: 

usernumber	sex	Dateofbirth	Registrationno	username	Primary
0573335555	M	17/02/1976	1234	john	Y
0573335555	F	18/03/1980	1235	sally	N
0573335555	M	19/04/2000	1235	Mathew	N
0573335555	F	20/05/2002	1235	May	N

[bill.king1]

Is this what you're looking to do, to use ECC variables for instance and not just Peripheral Variables?

https://www.cisco.com/c/en/us/support/docs/contact-center/unified-contact-center-express/213873-configure-uccx-custom-call-variable-layo.html

[jaheshkhan]

This I already accomplished.

but in that I can only show main record of the data.

under same calling number there will be more number of records.

so in that case how ill display. here the challenge is that we dont know number of database records . it can 4 rows of data another may have 10 rows of data etc.

So we cannnot define call variables like that. it should display on another page and display from gadget.. This is what I understand.. if there is another way, its really helpful..

I have given a sample below:

usernumber	sex	Dateofbirth	Registrationno	username
0573335555	M	17/02/1976	1234	john
0573335555	F	18/03/1980	1235	sally
0573335555	M	19/04/2000	1235	Mathew
0573335555	F	20/05/2002	1235	May

[david.macias]

You absolutely need to do this as a gadget to trigger based on call arrival and some CTI data. This is probably your best starting point (https://github.com/CiscoDevNet/finesse-sample-code/tree/master/ExternalRestApiSampleGadget) You're going to have to have an API in front of the DB to make this all work.

david