API query works in preview but not on live public site

[Jagan]

@victoria same issue

API in public app throws 400 error, same api works fine in logged in mode

@Paulo I understand what you guys are suspecting. The api doesn't use any user information (like getting username or userid from token, auth headers etc.) to run the query. select po.id, po.name, po."displayName", po.description, po."recurringPrice", po."nonRecurringPrice", pi."imageObjectId", json_agg(json_build_object('characteristic', characteristic, 'isPresent', "isPresent") order by "isPresent" desc) as characteristics, SUM(CASE WHEN psc."isPresent" = 'Yes' THEN 1 ELSE…