Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ALEX1977ALEX
Partner - Creator
Partner - Creator

You Tube API with Sense

Hi everyone

i include my You tube activity into sense

==>Everything is ok  but i cannot load my different video_id

in order to resume:

metrics='views,likes,dislikes,comments,shares,estimatedMinutesWatched',
dimensions='day',

==>It is OK

but i want to change dimensions with dimensions='video' like mentionned with this link

Dimensions  |  YouTube Analytics and Reporting APIs  |  Google Developers

i've got an issue 

(Connector error: The remote server returned an error: (400) Bad Request.)

Script ok:

LOAD
dim_day as [Report.dim_day],
metric_views as [Report.metric_views],
metric_likes as [Report.metric_likes],
metric_dislikes as [Report.metric_dislikes],
metric_comments as [Report.metric_comments],
metric_shares as [Report.metric_shares],
metric_estimatedMinutesWatched as [Report.estimatedMinutesWatched]
;

SELECT
dim_day,
metric_views,
metric_likes,
metric_dislikes,
metric_comments,
metric_shares,
metric_estimatedMinutesWatched

FROM Report
WITH PROPERTIES (
ids='channel==MINE',
startDate='01-09-2020',
endDate='15-11-2022',
metrics='views,likes,dislikes,comments,shares,estimatedMinutesWatched',
dimensions='day',
filters='',
sort='',
maxResults=''
);

Thank you 

 

Labels (2)
1 Reply
ALEX1977ALEX
Partner - Creator
Partner - Creator
Author

do you have already try to use YouTube api with Sense?