Trouble getting Supabase query to work

[steve_synopsis]

I am running an API Endpoint query with a filter on my Supabase table in Postman and it generates the correct result but when I run it through the API URL/Headers in Thunkable, the filter does not work

What am I missing?

Thanks
Steve

[samclever]

It must be how the data is stored. Are you trying to get a list of all the retailers? If so you need to parse the object data even further.

[steve_synopsis]

I just want data for retailerID = 1. I can do this via the URL in Postman, so I am assuming that it should work the same if I create the URL in Thunkable and call the API via the URL block.

[jared]

@samclever

It must be how the data is stored.

Not an issue here. @steve_synopsis You need to get object from Json. Not Json from object.

You need to convert the Json string being passed back into an object before trying to access the properties held within.

see this example app that i’ve built

or see these blocks

[steve_synopsis]

My issue is the filtering - if I view the response it shows all of the records.

The retailerID.eq.1 should filter the table to only respond with retailer ID 1 which is what happens in postman or if I run it directly in a browser.

[jared]

That’s because filters go in the url. Not the header