How can I use the Airtable API to fetch only rows that include a certain linked record? I tried the following approach:
const output = executeFilter('linkField', 'uid456');
hey, try using filterByFormula formatting. e.g your query should be something like filterByFormula={linkField}=‘uid456’. idk if it works better for u.
Based on my own experience working on a similar problem, I found that creating a URL-encoded query using the filterByFormula parameter can lead to more consistent results. I modified my API calls to embed the complete formula in the URL, making sure the syntax exactly corresponds to my table configurations. This approach helped in avoiding potential discrepancies that might occur when directly referencing the linked record value. It is essential to properly escape any quotes in the resulting string and verify that the formula fits Airtable’s requirements.