414 Request Status - Too large Request URL

I have a column with a big array that consists of cached IDs (on the 1st screenshot). I get values from it. And use these values to get records from another table that haven't cached.

In other words, after getting a big array values I fetch records from another table with a condition: if the column value is not in that big array (means it hasn't been cached).

Part of request looks this way:
"url": "https://krppyyichhwmuvastgik.supabase.co/rest/v1/kisis_forms?select=%2A&tg_id=not.in.%28%22547384285%22%2C...

AND OTHER VALUES......"

So it's too big. How could I fix that? I have no options:
  1. This array represents cached values
  2. I must only show user the data that hasn't seen previously (means not in that big array of cached values)
  3. Then it means that I could only fetch with a filter that basically says COLUMN not in (a lot of IDs). Request is going to be huge anyways.
image.png
image.png
Was this page helpful?