N8n node (Supabase) exact match but won't GET

[centuryegg]

Hi all,

I’ve a node that is to GET Many row operation and have determined that the input to the node has an exact match with my Supabase table, however, it is not Getting that row.

Is it an issue because it contains parentheses?

Input had 3 items; output 2 items. Missing item contains parantheses.

I have attached the screenshots for the input and output on the node (screenshot 1 and 2), as well as screenshot 3 (which shows data is there in Supabase).

Thank you all in advance for helping,

[jabbson]

Hey @centuryegg, try

{{ $json.fund_name_to_lookup.toJsonString() }}

[centuryegg]

@jabbson

{{ $json.fund_name_to_lookup.toJsonString() }}

Thanks Jabbson, i’ve tried and thus far it only yielded the same results as before.

[jabbson]

Repro’ed in my setup - doen’t work without the .toJsonString(), but with it - works just fine.

If this doesn’t work for you, there must be a real mismatch in the text - check for extra spaces or unprintable chars in the database text.