Function useDeleteTableRows

apps/sim/hooks/queries/tables.ts:1044–1086

({ workspaceId, tableId }: RowMutationContext)

 * Returns both deleted ids and failure details for partial-failure UI.
 */
export function useDeleteTableRows({ workspaceId, tableId }: RowMutationContext) {
  const queryClient = useQueryClient()

  return useMutation({
    mutationFn: async (rowIds: string[]): Promise<TableRowsDeleteResult> => {
      const uniqueRowIds = Array.from(new Set(rowIds))

      // The delete contract caps `rowIds` at MAX_BULK_OPERATION_SIZE, so large
      // selections (e.g. "select all") are sent as sequential chunks.
      const chunkSize = TABLE_LIMITS.MAX_BULK_OPERATION_SIZE
      const deletedRowIds: string[] = []
      const missingRowIds: string[] = []
      for (let i = 0; i < uniqueRowIds.length; i += chunkSize) {
        const chunk = uniqueRowIds.slice(i, i + chunkSize)
        const response = await requestJson(deleteTableRowsContract, {
          params: { tableId },
          body: { workspaceId, rowIds: chunk },
        })
        deletedRowIds.push(...(response.data.deletedRowIds || []))
        missingRowIds.push(...(response.data.missingRowIds || []))
      }

      if (missingRowIds.length > 0) {
        const failureCount = missingRowIds.length
        const totalCount = uniqueRowIds.length
        const successCount = deletedRowIds.length
        const firstMissing = missingRowIds[0]
        throw new Error(
          `Failed to delete ${failureCount} of ${totalCount} row(s)${successCount > 0 ? ` (${successCount} deleted successfully)` : ''}. Row not found: ${firstMissing}`
        )
      }

      return { deletedRowIds }
    },
    onError: (error) => {
      if (isValidationError(error)) return
      toast.error(error.message, { duration: 5000 })
    },
    onSettled: () => {
      invalidateRowCount(queryClient, tableId)
    },
  })
}

interface DeleteTableRowsAsyncVariables {
  /** Active filter; omit for a whole-table "select all". */