EndPoint List Projects

Name

list_projects

Lists Projects that the caller has permission on and satisfy the specified filter. [API reference]

Parameter	Label	Required	Options	Description
SearchFilter	SearchFilter	NO		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*

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
projectId	`DT_WSTR`	`nvarchar(255)`	255	`False`
name	`DT_WSTR`	`nvarchar(255)`	255	`False`
projectNumber	`DT_WSTR`	`nvarchar(255)`	255	`False`
lifecycleState	`DT_WSTR`	`nvarchar(255)`	255	`False`
createTime	`DT_DBTIMESTAMP`	`datetime`		`False`

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Use Google BigQuery Connector in API Source component to read data or in API Destination component to read/write data:

Google BigQuery

List Projects

Google BigQuery

List Projects

Use these SQL queries in your ODBC application data source:

Lists Projects for which user has access

SELECT * FROM list_projects

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Lists Projects for which user has access

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM list_projects';

EXEC (@MyQuery) AT [LINKED_SERVER_TO_GOOGLE_BIGQUERY_IN_DATA_GATEWAY];