Mutation Operations
This reference doc is generated based on thisexample schema.
Mutations define the write operations for modifying data in a GraphQL schema.
All mutations are generated based on customer defined@table types.Customer defined mutations are not supported.
Data Connect Generated
mainTable_delete:MainTable_KeyOutput
✨ Delete a singleMainTable based onid,key orfirst and return its key (ornull if not found).
| Field | Type | Description |
|---|---|---|
id | UUID | The unique ID of the object. |
key | MainTable_Key | The key used to identify the object. |
first | MainTable_FirstRow | Fetch the first row based on the filters and ordering. |
mainTable_deleteMany:Int!
✨ DeleteMainTable objects matchingwhere conditions (orall, if true). Returns the number of rows deleted.
| Field | Type | Description |
|---|---|---|
where | MainTable_Filter | Filter condition to specify which rows to delete. |
all | Boolean | Set to true to delete all rows. |
mainTable_insert:MainTable_KeyOutput!
✨ Insert a singleMainTable into the table and return its key. Columns not specified indata will receive defaults (e.g.null).
| Field | Type | Description |
|---|---|---|
data | MainTable_Data! | Data object to insert into the table. |
mainTable_insertMany:[MainTable_KeyOutput!]!
✨ InsertMainTable objects into the table and return their keys. Columns not specified indata will receive defaults (e.g.null).
| Field | Type | Description |
|---|---|---|
data | [MainTable_Data!]! | List of data objects to insert into the table. |
mainTable_update:MainTable_KeyOutput
✨ Update a singleMainTable based onid,key orfirst, setting columns specified indata. Returns the key of the updatedMainTable ornull if not found.
| Field | Type | Description |
|---|---|---|
id | UUID | The unique ID of the object. |
key | MainTable_Key | The key used to identify the object. |
first | MainTable_FirstRow | Fetch the first row based on the filters and ordering. |
data | MainTable_Data! | Data object containing fields to be updated. |
mainTable_updateMany:Int!
✨ UpdateMainTable objects matchingwhere conditions (orall, if true) according todata. Returns the number of rows updated.
| Field | Type | Description |
|---|---|---|
where | MainTable_Filter | Filter condition to specify which rows to update. |
all | Boolean | Set to true to update all rows. |
data | MainTable_Data! | Data object containing fields to update. |
mainTable_upsert:MainTable_KeyOutput!
✨ Insert or update a singleMainTable into the table, based on the primary key. Returns the key of the newly inserted or existing updatedMainTable.
| Field | Type | Description |
|---|---|---|
data | MainTable_Data! | Data object to insert or update if it already exists. |
mainTable_upsertMany:[MainTable_KeyOutput!]!
✨ Insert or updateMainTable objects into the table, based on the primary key. Returns the key of the newly inserted or existing updatedMainTable.
| Field | Type | Description |
|---|---|---|
data | [MainTable_Data!]! | List of data objects to insert or update if it already exists. |
manyToManyJoinTable_delete:ManyToManyJoinTable_KeyOutput
✨ Delete a singleManyToManyJoinTable based onid,key orfirst and return its key (ornull if not found).
| Field | Type | Description |
|---|---|---|
key | ManyToManyJoinTable_Key | The key used to identify the object. |
first | ManyToManyJoinTable_FirstRow | Fetch the first row based on the filters and ordering. |
manyToManyJoinTable_deleteMany:Int!
✨ DeleteManyToManyJoinTable objects matchingwhere conditions (orall, if true). Returns the number of rows deleted.
| Field | Type | Description |
|---|---|---|
where | ManyToManyJoinTable_Filter | Filter condition to specify which rows to delete. |
all | Boolean | Set to true to delete all rows. |
manyToManyJoinTable_insert:ManyToManyJoinTable_KeyOutput!
✨ Insert a singleManyToManyJoinTable into the table and return its key. Columns not specified indata will receive defaults (e.g.null).
| Field | Type | Description |
|---|---|---|
data | ManyToManyJoinTable_Data! | Data object to insert into the table. |
manyToManyJoinTable_insertMany:[ManyToManyJoinTable_KeyOutput!]!
✨ InsertManyToManyJoinTable objects into the table and return their keys. Columns not specified indata will receive defaults (e.g.null).
| Field | Type | Description |
|---|---|---|
data | [ManyToManyJoinTable_Data!]! | List of data objects to insert into the table. |
manyToManyJoinTable_update:ManyToManyJoinTable_KeyOutput
✨ Update a singleManyToManyJoinTable based onid,key orfirst, setting columns specified indata. Returns the key of the updatedManyToManyJoinTable ornull if not found.
| Field | Type | Description |
|---|---|---|
key | ManyToManyJoinTable_Key | The key used to identify the object. |
first | ManyToManyJoinTable_FirstRow | Fetch the first row based on the filters and ordering. |
data | ManyToManyJoinTable_Data! | Data object containing fields to be updated. |
manyToManyJoinTable_updateMany:Int!
✨ UpdateManyToManyJoinTable objects matchingwhere conditions (orall, if true) according todata. Returns the number of rows updated.
| Field | Type | Description |
|---|---|---|
where | ManyToManyJoinTable_Filter | Filter condition to specify which rows to update. |
all | Boolean | Set to true to update all rows. |
data | ManyToManyJoinTable_Data! | Data object containing fields to update. |
manyToManyJoinTable_upsert:ManyToManyJoinTable_KeyOutput!
✨ Insert or update a singleManyToManyJoinTable into the table, based on the primary key. Returns the key of the newly inserted or existing updatedManyToManyJoinTable.
| Field | Type | Description |
|---|---|---|
data | ManyToManyJoinTable_Data! | Data object to insert or update if it already exists. |
manyToManyJoinTable_upsertMany:[ManyToManyJoinTable_KeyOutput!]!
✨ Insert or updateManyToManyJoinTable objects into the table, based on the primary key. Returns the key of the newly inserted or existing updatedManyToManyJoinTable.
| Field | Type | Description |
|---|---|---|
data | [ManyToManyJoinTable_Data!]! | List of data objects to insert or update if it already exists. |
manyToOneExample_delete:ManyToOneExample_KeyOutput
✨ Delete a singleManyToOneExample based onid,key orfirst and return its key (ornull if not found).
| Field | Type | Description |
|---|---|---|
id | UUID | The unique ID of the object. |
key | ManyToOneExample_Key | The key used to identify the object. |
first | ManyToOneExample_FirstRow | Fetch the first row based on the filters and ordering. |
manyToOneExample_deleteMany:Int!
✨ DeleteManyToOneExample objects matchingwhere conditions (orall, if true). Returns the number of rows deleted.
| Field | Type | Description |
|---|---|---|
where | ManyToOneExample_Filter | Filter condition to specify which rows to delete. |
all | Boolean | Set to true to delete all rows. |
manyToOneExample_insert:ManyToOneExample_KeyOutput!
✨ Insert a singleManyToOneExample into the table and return its key. Columns not specified indata will receive defaults (e.g.null).
| Field | Type | Description |
|---|---|---|
data | ManyToOneExample_Data! | Data object to insert into the table. |
manyToOneExample_insertMany:[ManyToOneExample_KeyOutput!]!
✨ InsertManyToOneExample objects into the table and return their keys. Columns not specified indata will receive defaults (e.g.null).
| Field | Type | Description |
|---|---|---|
data | [ManyToOneExample_Data!]! | List of data objects to insert into the table. |
manyToOneExample_update:ManyToOneExample_KeyOutput
✨ Update a singleManyToOneExample based onid,key orfirst, setting columns specified indata. Returns the key of the updatedManyToOneExample ornull if not found.
| Field | Type | Description |
|---|---|---|
id | UUID | The unique ID of the object. |
key | ManyToOneExample_Key | The key used to identify the object. |
first | ManyToOneExample_FirstRow | Fetch the first row based on the filters and ordering. |
data | ManyToOneExample_Data! | Data object containing fields to be updated. |
manyToOneExample_updateMany:Int!
✨ UpdateManyToOneExample objects matchingwhere conditions (orall, if true) according todata. Returns the number of rows updated.
| Field | Type | Description |
|---|---|---|
where | ManyToOneExample_Filter | Filter condition to specify which rows to update. |
all | Boolean | Set to true to update all rows. |
data | ManyToOneExample_Data! | Data object containing fields to update. |
manyToOneExample_upsert:ManyToOneExample_KeyOutput!
✨ Insert or update a singleManyToOneExample into the table, based on the primary key. Returns the key of the newly inserted or existing updatedManyToOneExample.
| Field | Type | Description |
|---|---|---|
data | ManyToOneExample_Data! | Data object to insert or update if it already exists. |
manyToOneExample_upsertMany:[ManyToOneExample_KeyOutput!]!
✨ Insert or updateManyToOneExample objects into the table, based on the primary key. Returns the key of the newly inserted or existing updatedManyToOneExample.
| Field | Type | Description |
|---|---|---|
data | [ManyToOneExample_Data!]! | List of data objects to insert or update if it already exists. |
oneToOneExample_delete:OneToOneExample_KeyOutput
✨ Delete a singleOneToOneExample based onid,key orfirst and return its key (ornull if not found).
| Field | Type | Description |
|---|---|---|
id | UUID | The unique ID of the object. |
key | OneToOneExample_Key | The key used to identify the object. |
first | OneToOneExample_FirstRow | Fetch the first row based on the filters and ordering. |
oneToOneExample_deleteMany:Int!
✨ DeleteOneToOneExample objects matchingwhere conditions (orall, if true). Returns the number of rows deleted.
| Field | Type | Description |
|---|---|---|
where | OneToOneExample_Filter | Filter condition to specify which rows to delete. |
all | Boolean | Set to true to delete all rows. |
oneToOneExample_insert:OneToOneExample_KeyOutput!
✨ Insert a singleOneToOneExample into the table and return its key. Columns not specified indata will receive defaults (e.g.null).
| Field | Type | Description |
|---|---|---|
data | OneToOneExample_Data! | Data object to insert into the table. |
oneToOneExample_insertMany:[OneToOneExample_KeyOutput!]!
✨ InsertOneToOneExample objects into the table and return their keys. Columns not specified indata will receive defaults (e.g.null).
| Field | Type | Description |
|---|---|---|
data | [OneToOneExample_Data!]! | List of data objects to insert into the table. |
oneToOneExample_update:OneToOneExample_KeyOutput
✨ Update a singleOneToOneExample based onid,key orfirst, setting columns specified indata. Returns the key of the updatedOneToOneExample ornull if not found.
| Field | Type | Description |
|---|---|---|
id | UUID | The unique ID of the object. |
key | OneToOneExample_Key | The key used to identify the object. |
first | OneToOneExample_FirstRow | Fetch the first row based on the filters and ordering. |
data | OneToOneExample_Data! | Data object containing fields to be updated. |
oneToOneExample_updateMany:Int!
✨ UpdateOneToOneExample objects matchingwhere conditions (orall, if true) according todata. Returns the number of rows updated.
| Field | Type | Description |
|---|---|---|
where | OneToOneExample_Filter | Filter condition to specify which rows to update. |
all | Boolean | Set to true to update all rows. |
data | OneToOneExample_Data! | Data object containing fields to update. |
oneToOneExample_upsert:OneToOneExample_KeyOutput!
✨ Insert or update a singleOneToOneExample into the table, based on the primary key. Returns the key of the newly inserted or existing updatedOneToOneExample.
| Field | Type | Description |
|---|---|---|
data | OneToOneExample_Data! | Data object to insert or update if it already exists. |
oneToOneExample_upsertMany:[OneToOneExample_KeyOutput!]!
✨ Insert or updateOneToOneExample objects into the table, based on the primary key. Returns the key of the newly inserted or existing updatedOneToOneExample.
| Field | Type | Description |
|---|---|---|
data | [OneToOneExample_Data!]! | List of data objects to insert or update if it already exists. |
stringTable_delete:StringTable_KeyOutput
✨ Delete a singleStringTable based onid,key orfirst and return its key (ornull if not found).
| Field | Type | Description |
|---|---|---|
id | UUID | The unique ID of the object. |
key | StringTable_Key | The key used to identify the object. |
first | StringTable_FirstRow | Fetch the first row based on the filters and ordering. |
stringTable_deleteMany:Int!
✨ DeleteStringTable objects matchingwhere conditions (orall, if true). Returns the number of rows deleted.
| Field | Type | Description |
|---|---|---|
where | StringTable_Filter | Filter condition to specify which rows to delete. |
all | Boolean | Set to true to delete all rows. |
stringTable_insert:StringTable_KeyOutput!
✨ Insert a singleStringTable into the table and return its key. Columns not specified indata will receive defaults (e.g.null).
| Field | Type | Description |
|---|---|---|
data | StringTable_Data! | Data object to insert into the table. |
stringTable_insertMany:[StringTable_KeyOutput!]!
✨ InsertStringTable objects into the table and return their keys. Columns not specified indata will receive defaults (e.g.null).
| Field | Type | Description |
|---|---|---|
data | [StringTable_Data!]! | List of data objects to insert into the table. |
stringTable_update:StringTable_KeyOutput
✨ Update a singleStringTable based onid,key orfirst, setting columns specified indata. Returns the key of the updatedStringTable ornull if not found.
| Field | Type | Description |
|---|---|---|
id | UUID | The unique ID of the object. |
key | StringTable_Key | The key used to identify the object. |
first | StringTable_FirstRow | Fetch the first row based on the filters and ordering. |
data | StringTable_Data! | Data object containing fields to be updated. |
stringTable_updateMany:Int!
✨ UpdateStringTable objects matchingwhere conditions (orall, if true) according todata. Returns the number of rows updated.
| Field | Type | Description |
|---|---|---|
where | StringTable_Filter | Filter condition to specify which rows to update. |
all | Boolean | Set to true to update all rows. |
data | StringTable_Data! | Data object containing fields to update. |
stringTable_upsert:StringTable_KeyOutput!
✨ Insert or update a singleStringTable into the table, based on the primary key. Returns the key of the newly inserted or existing updatedStringTable.
| Field | Type | Description |
|---|---|---|
data | StringTable_Data! | Data object to insert or update if it already exists. |
stringTable_upsertMany:[StringTable_KeyOutput!]!
✨ Insert or updateStringTable objects into the table, based on the primary key. Returns the key of the newly inserted or existing updatedStringTable.
| Field | Type | Description |
|---|---|---|
data | [StringTable_Data!]! | List of data objects to insert or update if it already exists. |
Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2026-01-21 UTC.