Endpoint List Projects
Name
list_projects
Description
Lists Projects that the caller has permission on and satisfy the specified filter. [API reference]
Parameters
| Parameter | Required | Options |
|---|---|---|
|
Name:
Label: SearchFilter An expression for filtering the results of the request. Filter rules are case insensitive. If multiple fields are included in a filter query, the query will return results that match any of the fields. Some eligible fields for filtering are: name, id, labels.{key} (where key is the name of a label), parent.type, parent.id, lifecycleState. Example: name:how* |
Output Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Description |
|---|---|---|---|---|
| projectId |
DT_WSTR
|
nvarchar(255)
|
255 | |
| name |
DT_WSTR
|
nvarchar(255)
|
255 | |
| projectNumber |
DT_WSTR
|
nvarchar(255)
|
255 | |
| lifecycleState |
DT_WSTR
|
nvarchar(255)
|
255 | |
| createTime |
DT_DBTIMESTAMP
|
datetime
|
If the column you are looking for is missing, consider customizing Google BigQuery Connector.
Input Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Description | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Examples
SSIS
Use Google BigQuery Connector in API Source or in API Destination SSIS Data Flow components to read or write data.
API Source
API Source - Google BigQuery
Read / write Google BigQuery data inside your app without coding using easy to use high performance API Connector
Google BigQuery
List Projects
| Optional Parameters | |
|---|---|
| SearchFilter | |
API Destination
API Destination - Google BigQuery
Read / write Google BigQuery data inside your app without coding using easy to use high performance API Connector
Google BigQuery
List Projects
| Optional Parameters | |
|---|---|
| SearchFilter | |
ODBC application
Use these SQL queries in your ODBC application data source:
List Projects
Lists Projects for which user has access
SELECT * FROM list_projectsSQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
List Projects
Lists Projects for which user has access
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM list_projects';
EXEC (@MyQuery) AT [LS_TO_GOOGLE_BIGQUERY_IN_GATEWAY];