# To capture value from a database table in a select widget

**URL:** <https://community.ofelia.com/t/to-capture-value-from-a-database-table-in-a-select-widget/9669>\
**Category:** Q&A\
**Created:** [29 May 2019 13:58 UTC](https://community.ofelia.com/t/to-capture-value-from-a-database-table-in-a-select-widget/9669 "2019-05-29T13:58:25Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jessica.lopes\_137458](https://avatars.discourse-cdn.com/v4/letter/j/74df32/32.png) [@jessica.lopes\_137458](https://community.ofelia.com/u/jessica.lopes_137458)\
**Post date:** [29 May 2019 13:58 UTC](https://community.ofelia.com/t/to-capture-value-from-a-database-table-in-a-select-widget/9669/1 "2019-05-29T13:58:25Z")

</div>

I need to load a list of data from an auxiliary table created in the database inside my select object. How can I do this using an API?

---

<div class="post-metadata">

**Author:** ![system](https://europe1.discourse-cdn.com/flex013/uploads/community_bonitasoft/original/2X/6/6b7b18c0478f2645369e82e009b65e3b97f2cc12.svg) [@system](https://community.ofelia.com/u/system)\
**Post date:** [3 June 2019 18:35 UTC](https://community.ofelia.com/t/to-capture-value-from-a-database-table-in-a-select-widget/9669/2 "2019-06-03T18:35:29Z")

</div>

If you cannot store those data using the Business Data Model (BDM) feature of Bonita then I recommend to use the [REST API extension SQL data source](https://github.com/Bonitasoft-Community/rest-api-sql-data-source) available as a community contribution to get the data from your database.

You can then call this REST API extension using a Bonita form variable initialize with a REST GET API call.