Returns legacy custom objects, including creation, update, and identifier details.

Table-Specific Information

The Legacy Custom Objects API is deprecated and has limited access. Accounts not already using the Legacy API cannot start using it.

Beginning January 2026, accounts already utilizing the Legacy API will no longer be able to create new objects. Beginning June 2026, the legacy API will be sunset entirely.

Select

The LegacyCustomObjects table supports the ObjectName column in the WHERE clause, which supports the = operator. For example:

SELECT * FROM LegacyCustomObjects WHERE ObjectName = 'house'

Insert

You can insert any field into the LegacyCustomObjects table that is not read-only. The fields of the property are present in the LegacyCustomObjectField view.

To insert Properties details for a custom object, use the #TEMP table to insert the fields of the property. For example:

INSERT INTO LegacyCustomObjectField#TEMP (FieldName, Type, Description, Required) VALUES ('NumOfRooms', 'integer', 'The number of rooms.', true)
INSERT INTO LegacyCustomObjectField#TEMP (FieldName, Type, Description, Required) VALUES ('NumOfBaths', 'integer', 'The number of baths.', true)
INSERT INTO LegacyCustomObjectField#TEMP (FieldName, Type, Description, Required) VALUES ('Balcony', 'boolean', 'Whether or not balcony is there.', true)
INSERT INTO LegacyCustomObjectField#TEMP (FieldName, Type, Description) VALUES ('PropertyAge', 'string', 'Old or new construction.')
INSERT INTO LegacyCustomObjects (ObjectName, Properties) VALUES ('house', LegacyCustomObjectField#TEMP)

Update

You can update only the Properties column in the LegacyCustomObjects table. The fields of the property are present in the LegacyCustomObjectField view.

To update the properties details for a custom object, use the #TEMP table to insert the fields of the property. For example:

INSERT INTO LegacyCustomObjectField#TEMP (FieldName, Type, Description, Required) VALUES ('CarParking', 'string', 'Whether or not car parking is available', true)");
INSERT INTO LegacyCustomObjectField#TEMP (FieldName, Required) VALUES ('balcony', false)");
UPDATE LegacyCustomObjects SET Properties = 'LegacyCustomObjectField#TEMP' WHERE ObjectName = 'house'");

Delete

To delete a custom object, ObjectName is required.

DELETE FROM LegacyCustomObjects WHERE ObjectName = 'house'

Columns

Name	Type	ReadOnly	References	Description
ObjectName [KEY]	String	True		A user-defined unique identifier. Writable on create only.
CreatedAt	Datetime	True		The date and time the object type was created.
UpdatedAt	Datetime	True		The date and time the object type was last updated.
Version	String	True		The version of this schema.
Properties	String	True		A JSON schema describing the properties of the object record, up to 32 KB in size.