ODBC Driver for YouTube Analytics

Build 23.0.8839

VideoCategories

Query YouTube VideoCategories. A VideoCategory resource identifies a category that has been or could be associated with uploaded Videos.

Table Specific Information

Select

You can specify exactly one of the following columns: Id or Region. If you do not specify any filtering criteria, by default you will get results for the US Region. An extra optional parameter is Language.

SELECT * FROM VideoCategories WHERE Region = 'JP'
The IN operator can be used to filter on multiple Ids:
SELECT Id, Kind, Etag, ChannelId, Title, Assignable
FROM   VideoCategories
WHERE  (ID IN ('1', '2', '10'))

Columns

Name Type Dimension DefaultMetric DefaultDimension Description
Id [KEY] String The unique identifier for the video category.
ChannelId String The YouTube channel that created the video category.
Title String The title of the video category.
Assignable Boolean Indicates whether videos can be associated with the category.
Region String The country from which to retrieve video categories.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
Language String Specifies the language that should be used for text values in the API response. The default value is en_US.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839