company-member-sites-v2026-10

Read the rows of a table of a site's database

A page of one table’s rows, newest first, with the table’s row count. The sites gateway reads them as the admin, with no table rule applied. Every call is logged with the admin, the site and the table, before the gateway is asked.

Needs member_site_data.view, the permission to read what members wrote, application_themes.view, the permission of the site detail page, and a signed-in admin. An admin who edits themes but was never given member_site_data.view is refused with 403; a company grants it to the roles that moderate. A site of any owner in the company is served, a member’s included, because a company admin oversees a member’s site: reading and deleting what its members wrote is the moderation the member sites contract provides. It answers 404 for every caller that passes those checks when the site has no active database, when its schema has no such table, and until the sites gateway is released to the company. A droplet installation token and an OAuth client token are refused with 403.

GET

api

company

v2026-10

member-sites

{id}

data

{table}

Read the rows of a table of a site's database

curl --request GET \
  --url https://api.fluid.app/api/company/v2026-10/member-sites/{id}/data/{table} \
  --header 'Authorization: Bearer <token>'

import requests

url = "https://api.fluid.app/api/company/v2026-10/member-sites/{id}/data/{table}"

headers = {"Authorization": "Bearer <token>"}

response = requests.get(url, headers=headers)

print(response.text)

const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};

fetch('https://api.fluid.app/api/company/v2026-10/member-sites/{id}/data/{table}', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://api.fluid.app/api/company/v2026-10/member-sites/{id}/data/{table}",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "GET",
  CURLOPT_HTTPHEADER => [
    "Authorization: Bearer <token>"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

package main

import (
	"fmt"
	"net/http"
	"io"
)

func main() {

	url := "https://api.fluid.app/api/company/v2026-10/member-sites/{id}/data/{table}"

	req, _ := http.NewRequest("GET", url, nil)

	req.Header.Add("Authorization", "Bearer <token>")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}

require 'uri'
require 'net/http'

url = URI("https://api.fluid.app/api/company/v2026-10/member-sites/{id}/data/{table}")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Get.new(url)
request["Authorization"] = 'Bearer <token>'

response = http.request(request)
puts response.read_body

{
  "rows": [
    {
      "id": "0199537f-0000-7000-8000-0000000000a1",
      "title": "Hello",
      "created_by": "42",
      "created_at": "2026-11-05T10:00:00.000Z",
      "updated_at": "2026-11-05T10:00:00.000Z"
    }
  ],
  "status": 200,
  "meta": {
    "request_uuid": "3b8f1d27-6c4e-4a91-8e5d-2f7c9a1b0e64",
    "timestamp": "2026-11-05T10:05:00Z",
    "pagination": {
      "limit": 25,
      "offset": 0,
      "count": 1
    }
  }
}

{}

{}

{
  "error": {
    "message": "<string>",
    "details": {}
  },
  "status": 123,
  "meta": {
    "request_uuid": "<string>",
    "timestamp": "2023-11-07T05:31:56Z"
  }
}

{
  "error": {
    "message": "<string>",
    "details": {}
  },
  "status": 123,
  "meta": {
    "request_uuid": "<string>",
    "timestamp": "2023-11-07T05:31:56Z"
  }
}

{
  "error": {
    "message": "<string>",
    "details": {}
  },
  "status": 123,
  "meta": {
    "request_uuid": "<string>",
    "timestamp": "2023-11-07T05:31:56Z"
  }
}

{
  "error": {
    "message": "<string>",
    "details": {}
  },
  "status": 123,
  "meta": {
    "request_uuid": "<string>",
    "timestamp": "2023-11-07T05:31:56Z"
  }
}

Authorizations

Authorization

string

header

required

A company admin credential for your company, or a droplet installation token with the website scope for reads, except on the share routes, which refuse a droplet token.

Path Parameters

string<uuid>

required

The site's id.

table

string

required

The table's name, as the tables route lists it.

Pattern: ^[a-z][a-z0-9_]{0,62}$

Query Parameters

limit

integer

Rows per page. Default 25, maximum 100.

Required range: 1 <= x <= 100

offset

integer

Rows to skip. Default 0.

Required range: 0 <= x <= 1000000

Response

A page of rows.

A page of one table's rows, newest first.

rows

object[]

required

The rows on this page. Each is an object of the table's columns and its four system columns, with the values the sites gateway answers (integer above 2^53 as a string, json as JSON).

status

integer

required

The HTTP status.

meta

object

required

Show child attributes

Read the rows of a table of a site's database

curl --request GET \
  --url https://api.fluid.app/api/company/v2026-10/member-sites/{id}/data/{table} \
  --header 'Authorization: Bearer <token>'

import requests

url = "https://api.fluid.app/api/company/v2026-10/member-sites/{id}/data/{table}"

headers = {"Authorization": "Bearer <token>"}

response = requests.get(url, headers=headers)

print(response.text)

const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};

fetch('https://api.fluid.app/api/company/v2026-10/member-sites/{id}/data/{table}', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://api.fluid.app/api/company/v2026-10/member-sites/{id}/data/{table}",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "GET",
  CURLOPT_HTTPHEADER => [
    "Authorization: Bearer <token>"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

package main

import (
	"fmt"
	"net/http"
	"io"
)

func main() {

	url := "https://api.fluid.app/api/company/v2026-10/member-sites/{id}/data/{table}"

	req, _ := http.NewRequest("GET", url, nil)

	req.Header.Add("Authorization", "Bearer <token>")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}

require 'uri'
require 'net/http'

url = URI("https://api.fluid.app/api/company/v2026-10/member-sites/{id}/data/{table}")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Get.new(url)
request["Authorization"] = 'Bearer <token>'

response = http.request(request)
puts response.read_body

{
  "rows": [
    {
      "id": "0199537f-0000-7000-8000-0000000000a1",
      "title": "Hello",
      "created_by": "42",
      "created_at": "2026-11-05T10:00:00.000Z",
      "updated_at": "2026-11-05T10:00:00.000Z"
    }
  ],
  "status": 200,
  "meta": {
    "request_uuid": "3b8f1d27-6c4e-4a91-8e5d-2f7c9a1b0e64",
    "timestamp": "2026-11-05T10:05:00Z",
    "pagination": {
      "limit": 25,
      "offset": 0,
      "count": 1
    }
  }
}

{}

{}

{
  "error": {
    "message": "<string>",
    "details": {}
  },
  "status": 123,
  "meta": {
    "request_uuid": "<string>",
    "timestamp": "2023-11-07T05:31:56Z"
  }
}

{
  "error": {
    "message": "<string>",
    "details": {}
  },
  "status": 123,
  "meta": {
    "request_uuid": "<string>",
    "timestamp": "2023-11-07T05:31:56Z"
  }
}

{
  "error": {
    "message": "<string>",
    "details": {}
  },
  "status": 123,
  "meta": {
    "request_uuid": "<string>",
    "timestamp": "2023-11-07T05:31:56Z"
  }
}

{
  "error": {
    "message": "<string>",
    "details": {}
  },
  "status": 123,
  "meta": {
    "request_uuid": "<string>",
    "timestamp": "2023-11-07T05:31:56Z"
  }
}

Overview

Storefront

Commerce

Checkout

Member API

Messaging

People

Payments

DAM

Website

Portal

Mobile app

Content and tools

Analytics

Sales channels

Settings

FairShare SDK

Droplets

Developers

Unsorted endpoints

Portal & Widgets

Read the rows of a table of a site's database

Authorizations

Path Parameters

Query Parameters

Response