How to filter data by lookup field with API?

Hi,

The workaround for filtering lookup fields through the API is the same as the one mentioned in Unable to filter on lookup fields?

You create an additional column of the type Formula and use the join() and totext() functions. It is the join() function that converts the array of the formula to a string. And that string can be filtered with the API.

Regards
Frederik