what is the correct way to update a child document part of relation?

Hi, I am trying to get hold of using relationships with Python SDK (appwrite 1.3.7). I was successfully able to create and retrieve the documents. However I am having problems with updating the created document. If I don't pass the $id attribute along with the child payload, duplicates are being created. If I pass $id along with the payload it results in user unauthorised to perform this action error. Passing only IDs as an array works as expected but what if these child documents also has some updates? Do we have to update them separately and update the parent ?

Please note the user creating the documents has read/update/delete permission on both parent and child.

The relation is many to many.

TL;DR

The user is experiencing issues when trying to update a child document in a relation using the Python SDK (appwrite 1.3.7). If the `$id` attribute is not passed with the child payload, duplicates are created. If the `$id` is passed, an "unauthorized to perform this action" error occurs. The user wants to know if there is a way to update both the parent and child documents together. The relation is many-to-many. Solution: To update the child document, include the `$id` attribute in the nested JSON. Ensure that the user has read/update/delete permissions on both the parent and child

weird..you should only get that error if the user doesn't have access to the child document.... you definitely need to include $id in the nested JSON..

what's your code (the one with the nested $id)?

@Steven I am following the same example as in the docs

TypeScript

await databases.updateDocument(
    'marvel',
    'movies',
    'spiderman',
    {
        title: 'Spiderman',
        year: 2002,
        reviews: [
            {$id: <doc_id>, author: 'Bob', text: 'Great movie!' },
            { $id: <doc_id>, author: 'Alice', text: 'Loved it to the core!' },
            { author: 'Dave', text: 'Wonderful movie!' }
        ]
    }
);

Here the third review is the new one and the other two are old reviews that were created when the document was created. The text field has been updated in the existing child documents.