Run GQL query from Google Cloud Workflows

Question

I have a simple GQL query, SELECT * FROM PacerFeed WHERE pollInterval >= 0 that I want to run in a GCP Workflow wit the Firestore connector.

What is the database ID in the parent field? Is there a way I can just provide the whole query rather than the yaml'd fields? If not, what is the correct yaml args for this query?

    - getFeeds:
        call: googleapis.firestore.v1.projects.databases.documents.runQuery

        // These args are not correct, just demonstrative.
        args:
          parent: projects/{projectId}/databases/{database_id}/documents
          body:
            structuredQuery:
              from: [PacerFeed]
              select: '*'
              where: pollInterval >= 0
        result: got

PS can someone with more pts add a 'google-cloud-workflows' tag?

Answer 1

As in the comments, Jim pointed out what over a week of back and forth with GCP support could not. The db must be in Firestore Native mode.

I suggest not using GCP Workflows at all. The documentation sucks, there is not schema, the only thing GCP Support can do is tell you to hire a MSP to fill the doc gaps and point you to an example ... that does not include the parent field.