Remote error from mongot :: caused by :: "text" must be a document,

[Saravana_Srinivasan]

def search_by_occasion( occasion_names, age_floor, age_ceiling, output_hash):

    try:

        result = None
        user_collection = pymongo.collection.Collection(g.db, "gemift_product_db")
        result = user_collection.aggregate([{ "$search": { "index": "gemift_product_db", "text": [{ "$query": ["birthday"], "path":"occasion" }] }}])
        output_hash = copy.deepcopy(result)
        print ("The result is ", result)
        return True
    except errors.PyMongoError as e:
        current_app.logger.error(e)
        print ("The error is ", e)
        return False
    except Exception as e:
        current_app.logger.error(e)
        print ("The generic exception is ", e)
        return False

I get the following error when I execute the above code

Remote error from mongot :: caused by :: “text” must be a document, full error: {‘operationTime’: Timestamp(1633678006, 1), ‘ok’: 0.0, ‘errmsg’: ‘Remote error from mongot :: caused by :: “text” must be a document’, ‘code’: 8, ‘codeName’: ‘UnknownError’, ‘$clusterTime’: {‘clusterTime’: Timestamp(1633678006, 1), ‘signature’: {‘hash’: b’\xb8\xc9\x1a\x0f\x15\x05$,\x9a\x8d\x834\xf3\xd0\xc3\x9f\xa6\xf8\xe4#’, ‘keyId’: 6951462280051556353}}}

Appreciate the help

[Marcus (Marcus Eagan)]

Hi Sravana, Welcome to the MongoDB community forum! There are a lot of great folks in here.

Your query is pretty close, but you passed text as a List in the query above. Below, I’ve modified it to the correct syntax and included a github repo I threw together for Python about a year ago. Let me know if you have questions.

@Saravana_Srinivasan

def search_by_occasion( occasion_names, age_floor, age_ceiling, output_hash):

    try:

        result = None
        user_collection = pymongo.collection.Collection(g.db, "gemift_product_db")
        result = user_collection.aggregate([{ "$search": { "index": "gemift_product_db", "text": { "$query": ["birthday"], "path":"occasion" } }}])
        output_hash = copy.deepcopy(result)
        print ("The result is ", result)
        return True
    except errors.PyMongoError as e:
        current_app.logger.error(e)
        print ("The error is ", e)
        return False
    except Exception as e:
        current_app.logger.error(e)
        print ("The generic exception is ", e)
        return False

Basic example of Python and Atlas Search

If you go to the search tester in the Atlas UI, you can also see a basic example generated when you cliock view syntax and switch to the python language. I hope this helps. Let us know.

[Saravana_Srinivasan]

Thanks Marcus. It works. Let me go through your example code. I am hitting issues after issues, but having fun learning Now I need to find out how to solve mongodb cannot pickle SSL context . Running flask, python and flask_pymongo. As someone new to Atlas search (and seriously evaluating for a startup), lack of documentation and examples are slowing down. I, however, appreciate your immediate response. I will continue to use this forum for my questions.

Saravana

[Marcus (Marcus Eagan)]

My example is not a great one, but it is a useful python resource. I probably need to update it sometime soon. I will keep you posted. Good luck at your startup!