Firestore - Query

Hi all, some can help me with structuredQuery?

n8n return an error but not so clear

im, trying to do a simple query in a collection:

the json is that:

{
"structuredQuery": {
    "from": {
        "collectionId": "aggiudicazioni",
        "allDescendants": tue
    },
    "where": {
        "fieldFilter": {
            "field": {
                "fieldPath": "idCatalogo"
            },
            "op": "EQUAL",
            "value": {
                "integerValue": 1007,
            }
        }
    }
}

}

but i have this error

ERROR: Unexpected token } in JSON at position 391

solved:

{
   "structuredQuery":{
  "where":{
     "fieldFilter":{
        "field": {
         "fieldPath":"idCatalogo"
        },
        "op":"EQUAL",
        "value":{
           "integerValue":1007
        }
     }
  },
  "from":[
     {
        "collectionId":"aggiudicazioni"
     }
  ]
   }
}

Hey @samuele_coppede!

Welcome to the community :tada:

I am glad that you were able to find a solution!

A tool like JSON Prettifier helps me a lot when I get such errors. Hope you find it useful :slight_smile: