Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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?