Firebase SQL Connect API (firebasedataconnect:v1)

2026-10-07

7 new methods

Additions

    Methods
  • ▼ ▲ firebasedataconnect.projects.locations.services.postgrest.postgrestInsert

      Flat Path : v1/projects/{projectsId}/locations/{locationsId}/services/{servicesId}/postgrest/{postgrestId}

      Parameter Order :

    • firebasedataconnectService
    • firebasedataconnectTable
    • Path : v1/{+firebasedataconnectService}/postgrest/{+firebasedataconnectTable}

      Scopes : https://www.googleapis.com/auth/cloud-platform

      HTTP Method : POST

      Parameters :

        firebasedataconnectTable

          Pattern : ^.*$

          Required : Yes

          Description : Required. The name of the table to insert into.

          Location : path

          Type : string

        firebasedataconnectService

          Location : path

          Type : string

          Description : Required. The resource name of the service, in the format: `projects/{project}/locations/{location}/services/{service}`

          Pattern : ^projects/[^/]+/locations/[^/]+/services/[^/]+$

          Required : Yes

      Description : Executes a dynamic INSERT (create) or UPSERT mutation on a target table.

  • ▼ ▲ firebasedataconnect.projects.locations.services.postgrest.postgrestDelete

      Parameter Order :

    • firebasedataconnectService
    • firebasedataconnectTable
    • HTTP Method : DELETE

      Parameters :

        firebasedataconnectService

          Type : string

          Description : Required. The resource name of the service, in the format: `projects/{project}/locations/{location}/services/{service}`

          Location : path

          Pattern : ^projects/[^/]+/locations/[^/]+/services/[^/]+$

          Required : Yes

        firebasedataconnectTable

          Pattern : ^.*$

          Location : path

          Type : string

          Required : Yes

          Description : Required. The name of the table to delete from.

      Path : v1/{+firebasedataconnectService}/postgrest/{+firebasedataconnectTable}

      Flat Path : v1/projects/{projectsId}/locations/{locationsId}/services/{servicesId}/postgrest/{postgrestId}

      Description : Executes a dynamic DELETE mutation on rows matching the URL filters.

      Scopes : https://www.googleapis.com/auth/cloud-platform

  • ▼ ▲ firebasedataconnect.projects.locations.services.postgrest.postgrestUpdate

      Parameter Order :

    • firebasedataconnectService
    • firebasedataconnectTable
    • Path : v1/{+firebasedataconnectService}/postgrest/{+firebasedataconnectTable}

      Scopes : https://www.googleapis.com/auth/cloud-platform

      HTTP Method : PATCH

      Parameters :

        firebasedataconnectTable

          Location : path

          Pattern : ^.*$

          Required : Yes

          Type : string

          Description : Required. The name of the table to update.

        firebasedataconnectService

          Required : Yes

          Pattern : ^projects/[^/]+/locations/[^/]+/services/[^/]+$

          Location : path

          Description : Required. The resource name of the service, in the format: `projects/{project}/locations/{location}/services/{service}`

          Type : string

      Description : Executes a dynamic UPDATE (modify) mutation on rows matching the URL filters.

      Flat Path : v1/projects/{projectsId}/locations/{locationsId}/services/{servicesId}/postgrest/{postgrestId}

  • ▼ ▲ firebasedataconnect.projects.locations.services.postgrest.postgrestUpsert

      Parameter Order :

    • firebasedataconnectService
    • firebasedataconnectTable
    • Flat Path : v1/projects/{projectsId}/locations/{locationsId}/services/{servicesId}/postgrest/{postgrestId}

      Path : v1/{+firebasedataconnectService}/postgrest/{+firebasedataconnectTable}

      HTTP Method : PUT

      Parameters :

        firebasedataconnectService

          Required : Yes

          Location : path

          Type : string

          Description : Required. The resource name of the service, in the format: `projects/{project}/locations/{location}/services/{service}`

          Pattern : ^projects/[^/]+/locations/[^/]+/services/[^/]+$

        firebasedataconnectTable

          Location : path

          Type : string

          Pattern : ^.*$

          Required : Yes

          Description : Required. The name of the table to upsert into.

      Description : Executes a dynamic UPSERT (replace or create) mutation on a target table identified by primary key filters.

      Scopes : https://www.googleapis.com/auth/cloud-platform

  • ▼ ▲ firebasedataconnect.projects.locations.services.postgrest.postgrestSelect

      Path : v1/{+firebasedataconnectService}/postgrest/{+firebasedataconnectTable}

      HTTP Method : GET

      Parameters :

        firebasedataconnectService

          Required : Yes

          Description : Required. The resource name of the service, in the format: `projects/{project}/locations/{location}/services/{service}`

          Type : string

          Pattern : ^projects/[^/]+/locations/[^/]+/services/[^/]+$

          Location : path

        firebasedataconnectTable

          Description : Required. The name of the table to select from.

          Location : path

          Pattern : ^.*$

          Required : Yes

          Type : string

      Scopes : https://www.googleapis.com/auth/cloud-platform

      Flat Path : v1/projects/{projectsId}/locations/{locationsId}/services/{servicesId}/postgrest/{postgrestId}

      Description : Executes a dynamic SELECT (read) query on a target PostgreSQL table. Projections, filters, sorting, and embeddings are mapped from the HTTP URL query parameters.

      Parameter Order :

    • firebasedataconnectService
    • firebasedataconnectTable
  • ▼ ▲ firebasedataconnect.projects.locations.services.postgrest.rpc.postgrestCallFunction

      Description : Executes a PostgreSQL database function.

      Flat Path : v1/projects/{projectsId}/locations/{locationsId}/services/{servicesId}/postgrest/rpc/{rpcId}

      Parameter Order :

    • firebasedataconnectService
    • firebasedataconnectFunction
    • HTTP Method : POST

      Parameters :

        firebasedataconnectService

          Required : Yes

          Type : string

          Pattern : ^projects/[^/]+/locations/[^/]+/services/[^/]+$

          Location : path

          Description : Required. The resource name of the service, in the format: `projects/{project}/locations/{location}/services/{service}`

        firebasedataconnectFunction

          Pattern : ^.*$

          Required : Yes

          Type : string

          Description : Required. The name of the database function.

          Location : path

      Scopes : https://www.googleapis.com/auth/cloud-platform

      Path : v1/{+firebasedataconnectService}/postgrest/rpc/{+firebasedataconnectFunction}

  • ▼ ▲ firebasedataconnect.projects.locations.services.postgrest.rpc.postgrestQueryFunction

      Flat Path : v1/projects/{projectsId}/locations/{locationsId}/services/{servicesId}/postgrest/rpc/{rpcId}

      HTTP Method : GET

      Parameters :

        firebasedataconnectFunction

          Required : Yes

          Location : path

          Description : Required. The name of the database function.

          Type : string

          Pattern : ^.*$

        firebasedataconnectService

          Description : Required. The resource name of the service, in the format: `projects/{project}/locations/{location}/services/{service}`

          Location : path

          Pattern : ^projects/[^/]+/locations/[^/]+/services/[^/]+$

          Required : Yes

          Type : string

      Scopes : https://www.googleapis.com/auth/cloud-platform

      Description : Executes a read-only PostgreSQL database function.

      Path : v1/{+firebasedataconnectService}/postgrest/rpc/{+firebasedataconnectFunction}

      Parameter Order :

    • firebasedataconnectService
    • firebasedataconnectFunction