Supabase doesnt return all JSONB data
I have following query
And logging its result for column
I get
And each of these objects should look like so (they lacks settings):
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_configurationdefault_configurationI 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
}
}
],
}
}