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.
Thanks for your help !
Paul
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 
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
Hi @paul.genoud ,
could you accomplish this using JSONPath, to filter in output instead of using query parameter?
What i mean is something like this :
In this example you get two resultsets : one with non linked records and the other with linked records.
