How to populate the Select Widget from external DB (MySQL)?

Q&A
1

Hi there, 

I am new to Bonita. I am trying to populate the select widget with data from an external database (MySQL). 
I created a connector in, Set the query, Created a Variable. The output of the query is already stored in the variable. In the UI design i am getting the resultes with the following REST API : ../API/bpm/caseVariable/{{task.caseId}}/example.   I named this variable newVar/

The result comes as a variable. It has the name = EXAMPLE, description = "", type= "java.util.List", value: "[[iPhone 7, 01], [iPhone 8 , 02], [iPhone X, 04]]".
If I write newVar.value in the Avaliable Values, in return I get the following result: 

[

[

i

P

h

o

n

e

 

0

1

....
...

All the items that coming in the value.


Can anyone tell me what am I doing wrong? I have tried to manipulate with the result but it does not work.

2

Hello,

Could you export and HAR result please ?

I'm afraid the standard REST API does not handle LIST variable (it was the case in 7.8 release for example).

You can use the REST API CONTEXT to fit this need

https://community.bonitasoft.com/project/restapicontext