Create Reference Table

Create a reference table in the authenticated organization.

items is a list of rows, each with a non-empty data array of
(field_name, value) entries. Entries are deduplicated within a row; two rows may
carry the same pair.

fields is read-only -- derived from the entries in first-seen order, so row and
entry order set the eventual SQL predicate order. operation and grouping are
accepted but ignored: the service always stores the current defaults, because the
SQL builder that will read them does not exist yet.

Each field_name must be a column of nocsf_unified_events that can be matched by
exact value, and each value must be a possible value for that column's type. Both
are 400s. The restriction is what stops a typo becoming a reference table that saves
cleanly and then breaks every rule using it at query time.

visibility is optional. public is accepted from any organization, but only
shares the table when Nebulock owns it -- on your own table it is recorded and
changes nothing, since cross-organization reads are gated on ownership. private is
a Nebulock-curated state and is a 400 for anyone else.

The items may arrive as a CSV instead. Send the request as multipart/form-data
with a payload field holding this JSON object and a file field holding the CSV;
the format and every rejection are the ones
POST /reference-tables/{id}/csv-upload documents. Sending both items and a file
is a 400 -- they are two spellings of one field. JSON callers are unaffected.

Recent Requests
Log in to see full request history
TimeStatusUser Agent
Retrieving recent requests…
LoadingLoading…
Body Params

POST /reference-tables body.

The draft spec called the name field name here and title in the response and in
the clone body; title wins, matching rules_main.title.

string
required
length between 1 and 256
string
required
length between 3 and 64

Required, and set once -- there is no route that changes it. Used in SQL as ref_table('').

enum

Optional publish state. 'public' is accepted from any organization; it only shares the table when Nebulock owns it. 'private' is Nebulock-curated only and is a 400 otherwise.


Publish state of a portal-owned table.

Only meaningful for tables owned by the internal portal org; a customer-owned table
carries None, which means "not applicable" rather than "private". A tenant table
is always and only visible to its own org, and there is no state that changes that.

array | null

READ-ONLY. Derived from items and ignored if sent -- accepted only so a client can PATCH back an object it read unmodified.

items
array of objects

Item rows; each needs at least one data entry

Items
Headers
string
required

Your API Key ID

string

Your API Key Secret

string
enum
Defaults to application/json

Generated from available request content types

Allowed:
Responses

Language
Credentials
LoadingLoading…
Response
Click Try It! to start a request and see the response here! Or choose an example:
application/json