Record data model

View field support, webhooks, and list parameters for each integration on the Supported Integrations page.

FieldTypeRequiredDescription
idstringNo
created_atstring (date-time)No(ISO-8601 / YYYY-MM-DDTHH:MM:SSZ format)
updated_atstring (date-time)No(ISO-8601 / YYYY-MM-DDTHH:MM:SSZ format)
database_idstringNosource Database ID
table_idstringNosource Database Table ID
fieldsobjectYes
fields.stringstringNo
fields.numbernumberNo
fields.booleanbooleanNo
fields.datestringNo
fields.selectionstring[]No
fields.is_nullbooleanNo
row_numbernumberNo

TypeScript

TypeScript
export type DatastoreRecord = {
	id?: string;
	created_at?: string-time; // (ISO-8601 / YYYY-MM-DDTHH:MM:SSZ format)
	updated_at?: string-time; // (ISO-8601 / YYYY-MM-DDTHH:MM:SSZ format)
	database_id?: string; // source Database ID
	table_id?: string; // source Database Table ID
	fields: Record <string, { 
		string?: string;
		number?: number;
		boolean?: boolean;
		date?: string;
		selection?: any;
		is_null?: boolean; 
	}> ;
	row_number?: number;
	raw?: any;
} 

Zod

Zod
import { z } from 'zod';

export const ZodDatastoreRecord = z.object({
	id: z.string().optional(),
	created_at: z.string-time().optional().describe("(ISO-8601 / YYYY-MM-DDTHH:MM:SSZ format)"),
	updated_at: z.string-time().optional().describe("(ISO-8601 / YYYY-MM-DDTHH:MM:SSZ format)"),
	database_id: z.string().optional().describe("source Database ID"),
	table_id: z.string().optional().describe("source Database Table ID"),
	fields: z.record(z.string(), z.object({ 
			string: z.string().optional(),
			number: z.number().optional(),
			boolean: z.boolean().optional(),
			date: z.string().optional(),
			selection: z.unknown().optional(),
			is_null: z.boolean().optional()
})),
	row_number: z.number().optional(),

});

Python

Python
import dataclasses

@dataclasses.dataclass
class DatastoreRecord:
	id: Optional[str]
	"""(ISO-8601 / YYYY-MM-DDTHH:MM:SSZ format)"""
	created_at: Optional[str]
	"""(ISO-8601 / YYYY-MM-DDTHH:MM:SSZ format)"""
	updated_at: Optional[str]
	"""source Database ID"""
	database_id: Optional[str]
	"""source Database Table ID"""
	table_id: Optional[str]
	fields: PropertyDatastoreRecordFields
	row_number: Optional[int]
Are we missing anything? Let us know
Was this page helpful?