Cannot fetch data

[comataani]

Query
db.status.aggregate(
[ { $match: { api: "api details" } }, { "$group": { _id: "$environment", count: { "$sum": 1 } } } ]
);

error in response:
"Unexpected token $ in JSON at position 8"

can you help me whats wrong in this

[vladostp]

Hi comataani,

Try to execute this query
db.status.aggregate(
[ { "$match": { "api": "api details" } }, { "$group": { "_id": "$environment", "count": { "$sum": 1 } } } ]
);

[comataani]

Not able to execute that query even from mongo client.
but i tried this query i am able to execute it from mongo db but in grafanna i am getting the following error
db.status.aggregate(
{"$group" : {"_id": {"environment":"$environment"}, "count": { "$sum": 1 } } },
{"$match": {"count" : {"$gt": 10} } },
{"$project": {"environment":1} }
)