[SOLVED] Error with Python SDK database.get_document

I'm trying to get data from the database but I've always a generic runtime error, I've tried with php code but I don't find where I'm wrong

The code is on the screenshot

TL;DR

The user had an error with the Python SDK `database.get_document` function. After making a few changes to their code, they were able to successfully get the desired result. The solution involved printing the error as a string and adding a try/except block to catch exceptions. The user also posted their updated code for reference.

would you please try to wrap your code with a try/except to catch any exception?

Tried but when I test I got only runtime error

what's your updated code?

copying and pasting here would be easier

thank you for waiting

import os import json

from appwrite.client import Client from appwrite.services.databases import Databases from appwrite.services.users import Users from appwrite.id import ID from appwrite.query import Query

def main(req, res): payload = json.loads(req.variables.get('APPWRITE_FUNCTION_EVENT_DATA')) client = Client() client.set_endpoint(req.variables.get("APPWRITE_ENDPOINT")) client.set_project(req.variables.get("APPWRITE_PROJECT_ID")) client.set_key(req.variables.get("APPWRITE_API_KEY"))

TypeScript

#Get Users collection id
database_id = req.variables.get('DATABASE_ID')
users_collection_id = req.variables.get('USERS_COLLECTION_ID')
database = Databases(client)
users = Users(client)
db_result = users.get(payload['userId'])

try:
    result = database.get_document(database_id, users_collection_id, payload['userId'])

    if result is None:
        database.create_document(
            database_id, 
            users_collection_id, 
            ID.custom(id=payload['userId']),
            data={
                'userId': payload['userId'],
                'name': db_result['name'],
                'email': db_result["email"],
        })
except Exception as e:
    print(e)

FYI, it's best to wrap code in backticks to format a bit nicer. You can use 1 backtick for inline code (https://www.markdownguide.org/basic-syntax/#code) and 3 backticks for multiline code (https://www.markdownguide.org/extended-syntax/#syntax-highlighting.

Would you please make sure res.json() or res.send() is called exactly once before exiting?

TypeScript


import os
import json

from appwrite.client import Client
from appwrite.services.databases import Databases
from appwrite.services.users import Users
from appwrite.id import ID
from appwrite.query import Query

def main(req, res):
    payload = json.loads(req.variables.get('APPWRITE_FUNCTION_EVENT_DATA'))
    client = Client()
    client.set_endpoint(req.variables.get("APPWRITE_ENDPOINT"))
    client.set_project(req.variables.get("APPWRITE_PROJECT_ID"))
    client.set_key(req.variables.get("APPWRITE_API_KEY"))
    
    #Get Users collection id
    database_id = req.variables.get('DATABASE_ID')
    users_collection_id = req.variables.get('USERS_COLLECTION_ID')
    database = Databases(client)
    users = Users(client)
    db_result = users.get(payload['userId'])
    
    try:
        result = database.get_document(database_id, users_collection_id, payload['userId'])
    
        if result is None:
            database.create_document(
                database_id, 
                users_collection_id, 
                ID.custom(id=payload['userId']),
                data={
                    'userId': payload['userId'],
                    'name': db_result['name'],
                    'email': db_result["email"],
            })
    except Exception as e:
        print(e)

Thank you I didn't remember it

did that solve your problem?

Nope, in that message I'm referring to markdown😂

I tried again with same code but I hadn't any logs, nothing, I can't find where is the problem in the code

what's your updated code?

also, try to only print strings so: print(str(e))

Nothing, now because the try catch it says completed but no response are recorded

what's your updated code?

Same only with the change from print(e) to print(str(e))

Would you please make sure res.json() or res.send() is called exactly once before exiting?

res.json

Now with the same exactly code, I got the result

Maybe I miswrite a character, idk

Thank you for help!

[SOLVED] Error with Python SDK database.get_document

Reply

Reply to this thread by joining our Discord

Reply on Discord

The code is on the screenshot

Need support?

Join our Discord

Get premium support

[SOLVED] Error with Python SDK database.get_document

The code is on the screenshot

Recommended threads

Need support?

Join our Discord

Get premium support