I’ve been banging my head against this for several hours. The “Get many” node on Grist filter function doesn’t seem to work. I’ve set the filter both “hardcoded” and using an input from a previous step. In both instances, the filter returns no results. I’ve ensured the data types are the same, but still no dice.
Ensure to copy your n8n workflow and paste it in the code block, that is in between the pairs of triple backticks, which also could be achieved by clicking </> (preformatted text) in the editor and pasting in your workflow.
```
<your workflow>
```
That implies to any JSON output you would like to share with us.
I tested the filter option on Grist node and encountered no issue. The only reasons for not returning the items are
no match found (could be due to extra trailing characters in either GSheet or Grist)
type mismatch (string vs numeric, for example)
Could you check the output of GSheet in the JSON view and see how the data is presented there. Do the same for Grist without filters and see how the data is presented in there too. You might spot the discrepancies between the tables in both services.
For troubleshooting purposes, the compassion could be done by running the workflow like below as an example
Adjust the references to the SKU on both systems in Edit Fields nodes accordingly and see the result in Compare Datasets node. Make sure to select Return All option.
