# Tulip table API how to filter on a linked record colum **URL:** https://community.tulip.co/t/tulip-table-api-how-to-filter-on-a-linked-record-colum/13574 **Category:** Product Suggestions **Tags:** connectors, api **Created:** [January 21, 2025, 4:17pm UTC](https://community.tulip.co/t/tulip-table-api-how-to-filter-on-a-linked-record-colum/13574 "2025-01-21T16:17:14Z") **Posts on this page:** 6 **Page:** 1
### Author: ![paul.genoud](https://avatars.discourse-cdn.com/v4/letter/p/f14d63/32.png) [@paul.genoud](https://community.tulip.co/u/paul.genoud) #### Post date: [January 21, 2025, 4:17pm UTC](https://community.tulip.co/t/tulip-table-api-how-to-filter-on-a-linked-record-colum/13574/1 "2025-01-21T16:17:14Z")
Hi all, I try to to set up a connector with TULIP Table API to GET the records of a table that have linked records colums. I try to filter on the linked record colum to have only the records where the linked colum is empty. It seems that my query parameters are not set correctly but I don’t understand why. ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/0/0df093f778965ea2af18f09ebf6831fdcccfd4a4.png) Thanks for your help ! Paul ---
### Author: ![Beth](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/beth/32/5987_2.png) [@Beth](https://community.tulip.co/u/Beth) #### Post date: [January 22, 2025, 2:36pm UTC](https://community.tulip.co/t/tulip-table-api-how-to-filter-on-a-linked-record-colum/13574/2 "2025-01-22T14:36:17Z")
Hi Paul - You are correct that there isn’t anything wrong with your set up here - this is actually a limitation with linked records. Unfortunately you cannot filter on a linked record column and the response and 422 error are expected in this scenario. A possible workaround is to query both tables separately and then do the joining / filtering yourself. If you’d like, I can turn this into a Product Request so that way it gets into our backlog and can be considered for future improvements! Let me know 🙂 ---
### Author: ![paul.genoud](https://avatars.discourse-cdn.com/v4/letter/p/f14d63/32.png) [@paul.genoud](https://community.tulip.co/u/paul.genoud) #### Post date: [January 22, 2025, 3:24pm UTC](https://community.tulip.co/t/tulip-table-api-how-to-filter-on-a-linked-record-colum/13574/3 "2025-01-22T15:24:18Z")
Hi Beth, Thank you for your feedback ! I will try the workaround. But yes I think it is a good idea to turn this into a Product Request. Thanks, Paul ---
### Author: ![tokotu](https://avatars.discourse-cdn.com/v4/letter/t/5fc32e/32.png) [@tokotu](https://community.tulip.co/u/tokotu) #### Post date: [January 23, 2025, 12:11pm UTC](https://community.tulip.co/t/tulip-table-api-how-to-filter-on-a-linked-record-colum/13574/4 "2025-01-23T12:11:03Z")
Hi @paul.genoud , could you accomplish this using JSONPath, to filter in output instead of using query parameter? ---
### Author: ![tokotu](https://avatars.discourse-cdn.com/v4/letter/t/5fc32e/32.png) [@tokotu](https://community.tulip.co/u/tokotu) #### Post date: [January 24, 2025, 4:06pm UTC](https://community.tulip.co/t/tulip-table-api-how-to-filter-on-a-linked-record-colum/13574/5 "2025-01-24T16:06:52Z")
What i mean is something like this : ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/7/7abbeecf23a9a1e26de21b556ffb3684ca3faad2.png) In this example you get two resultsets : one with non linked records and the other with linked records. ---
### Author: ![paul.genoud](https://avatars.discourse-cdn.com/v4/letter/p/f14d63/32.png) [@paul.genoud](https://community.tulip.co/u/paul.genoud) #### Post date: [January 24, 2025, 6:51pm UTC](https://community.tulip.co/t/tulip-table-api-how-to-filter-on-a-linked-record-colum/13574/6 "2025-01-24T18:51:30Z")
Hi tokotu ! Thanks a lot ! It works perfectly fine ! ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/e/e008d6399ec7e912ec25be92832960c56509db65.png) You made my day ! Paul