# Multi primary key & one record

**URL:** <https://community.dreamfactory.com/t/multi-primary-key-one-record/3190>\
**Category:** REST API\
**Created:** [September 6, 2016, 10:20am UTC](https://community.dreamfactory.com/t/multi-primary-key-one-record/3190 "2016-09-06T10:20:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![radodr](https://avatars.discourse-cdn.com/v4/letter/r/e47c2d/32.png) [@radodr](https://community.dreamfactory.com/u/radodr)\
**Post date:** [September 6, 2016, 10:20am UTC](https://community.dreamfactory.com/t/multi-primary-key-one-record/3190/1 "2016-09-06T10:20:04Z")

</div>

Hi,  
is it posible to get one record from db service (mysql) with get api ?  
`(/db/_table/{table_name}/{id} getRadtaxidbRecord() - Retrieve one record by identifier)`

I can state param `id_field` for pk column names separated with comma (e.g. `id_pai,id_comp`), but how can I enter Identifier of the record to retrieve?

I know, I can use `/db/_table/{table_name} getRadtaxidbRecords() - Retrieve one or more records` with filter, but I just curios if it is possible with primary key.

Thank you.

---

<div class="post-metadata">

**Author:** ![formerstaff](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/formerstaff/32/1133_2.png) [@formerstaff](https://community.dreamfactory.com/u/formerstaff)\
**Post date:** [September 9, 2016, 2:27pm UTC](https://community.dreamfactory.com/t/multi-primary-key-one-record/3190/2 "2016-09-09T14:27:33Z")

</div>

We do not currently support composite keys as identifiers, but you can get an individual record by an individual column value or with filtering, as you indicated.

There is a feature request for this and it should be completed in an upcoming development sprint.

---

<div class="post-metadata">

**Author:** ![radodr](https://avatars.discourse-cdn.com/v4/letter/r/e47c2d/32.png) [@radodr](https://community.dreamfactory.com/u/radodr)\
**Post date:** [September 9, 2016, 10:13pm UTC](https://community.dreamfactory.com/t/multi-primary-key-one-record/3190/3 "2016-09-09T22:13:10Z")

</div>

thank you for response.  
In upcoming version it will be fine, because filtering and receive just one record identified by primary key (multi key) is big difference for developer… especially with lookup keys - pk is row owner lookup key and id is for identity in row owner context.  
Thank you for your work 🙂

---

<div class="post-metadata">

**Author:** ![Julian\_Kallidat](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/julian_kallidat/32/1213_2.png) [@Julian\_Kallidat](https://community.dreamfactory.com/u/Julian_Kallidat)\
**Post date:** [February 19, 2019, 10:31am UTC](https://community.dreamfactory.com/t/multi-primary-key-one-record/3190/4 "2019-02-19T10:31:08Z")

</div>

Is this possible meanwhile?  
I am trying but without luck. I didn’t find something in the wiki…

Thank you in advance.