© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•3mo ago•
7 replies
Floppy Disk

Supabase doesnt return all JSONB data

I have following query
export const getOrgCrmListByOrgId = async (orgId: Tables<"organisation">["id"]) => {
    return await supabase
        .from('crm')
        .select(`*,crm_config(*),crm_project(*), organisation_crm!inner(*)`)
        .eq('organisation_crm.organisation_id', orgId)
        .throwOnError()
        .then(res => res.data);
}
export const getOrgCrmListByOrgId = async (orgId: Tables<"organisation">["id"]) => {
    return await supabase
        .from('crm')
        .select(`*,crm_config(*),crm_project(*), organisation_crm!inner(*)`)
        .eq('organisation_crm.organisation_id', orgId)
        .throwOnError()
        .then(res => res.data);
}

And logging its result for column
default_configuration
default_configuration

I get
"default_configuration": {
      "parameter": {
        "crm": [
          {
            "id": "Api Key",
            "name": "Api Key"
          }
        ],
      }
    },
"default_configuration": {
      "parameter": {
        "crm": [
          {
            "id": "Api Key",
            "name": "Api Key"
          }
        ],
      }
    },

And each of these objects should look like so (they lacks settings):
{
  "parameter": {
    "crm": [
      {
        "id": "Api Key",
        "name": "Api Key",
        "settings": {
          "isPrivate": true,
          "isRequiredForExport": true
        }
      }
    ],
  }
}
{
  "parameter": {
    "crm": [
      {
        "id": "Api Key",
        "name": "Api Key",
        "settings": {
          "isPrivate": true,
          "isRequiredForExport": true
        }
      }
    ],
  }
}
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Why supabase JSONB inserts so slow?
SupabaseSSupabase / help-and-questions
3d ago
Query data in jsonb values array
SupabaseSSupabase / help-and-questions
4y ago
Does supabase return discord discriminator?
SupabaseSSupabase / help-and-questions
4y ago
Return data on insert
SupabaseSSupabase / help-and-questions
4y ago