Menu
Firestore.projects.databases.documents.run Query
Runs a query.
POST
/v1/{parent}:runQueryUse it in a workflow
- Add a step and choose the Firestore connector.
- Pick the Firestore.projects.databases.documents.run Query action (under projects).
- Fill in the fields below, then reference the result from later steps as
{{firestoreProjectsDatabasesDocumentsRunQuery.response.data}}.
Request
Path parameters
Query parameters
Request body
Enter the body as JSON in the step's Body field.
{
"newTransaction": {
"readOnly": {
"readTime": "string"
},
"readWrite": {
"retryTransaction": "string"
}
},
"readTime": "string",
"structuredQuery": {
"endAt": {
"before": false,
"values": [
{
"arrayValue": {
"values": [
null
]
},
"booleanValue": false,
"bytesValue": "string",
"doubleValue": 0,
"geoPointValue": {
"latitude": 0,
"longitude": 0
},
"integerValue": "string",
"mapValue": {
"fields": {}
},
"nullValue": "NULL_VALUE",
"referenceValue": "string",
"stringValue": "string",
"timestampValue": "string"
}
]
},
"from": [
{
"allDescendants": false,
"collectionId": "string"
}
],
"limit": 0,
"offset": 0,
"orderBy": [
{
"direction": "DIRECTION_UNSPECIFIED",
"field": {
"fieldPath": "string"
}
}
],
"select": {
"fields": [
{
"fieldPath": "string"
}
]
},
"startAt": {
"before": false,
"values": [
{
"arrayValue": {
"values": [
null
]
},
"booleanValue": false,
"bytesValue": "string",
"doubleValue": 0,
"geoPointValue": {
"latitude": 0,
"longitude": 0
},
"integerValue": "string",
"mapValue": {
"fields": {}
},
"nullValue": "NULL_VALUE",
"referenceValue": "string",
"stringValue": "string",
"timestampValue": "string"
}
]
},
"where": {
"compositeFilter": {
"filters": [
{}
],
"op": "OPERATOR_UNSPECIFIED"
},
"fieldFilter": {
"field": {
"fieldPath": "string"
},
"op": "OPERATOR_UNSPECIFIED",
"value": {
"arrayValue": {
"values": [
null
]
},
"booleanValue": false,
"bytesValue": "string",
"doubleValue": 0,
"geoPointValue": {
"latitude": 0,
"longitude": 0
},
"integerValue": "string",
"mapValue": {
"fields": {}
},
"nullValue": "NULL_VALUE",
"referenceValue": "string",
"stringValue": "string",
"timestampValue": "string"
}
},
"unaryFilter": {
"field": {
"fieldPath": "string"
},
"op": "OPERATOR_UNSPECIFIED"
}
}
},
"transaction": "string"
}
Response
Returns 200 with an object. Read it in later steps with {{firestoreProjectsDatabasesDocumentsRunQuery.response.data.<field>}}.
{
"document": {
"createTime": "string",
"fields": {},
"name": "string",
"updateTime": "string"
},
"done": false,
"readTime": "string",
"skippedResults": 0,
"transaction": "string"
}
Need more? See the Firestore guide for connection setup and behaviour shared by every action.
Was this page helpful?