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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Extract data from google analytics Api

Hi 

 

I have added  tGoogleAnalyticsRealtimeInput  custom component in talend and after that i have created the job like this below.0683p000009MPeR.pngTgooglerealtimeinput job

 

and please see the component details page below i gave user account email id also but not shared in below  screen shot0683p000009MPeV.pngcomponent details

After executing it is redirected to browser and asking to allow for GA_fetcher page and closed it after that i am getting the below error message ( please share the material for tgoogleanalyticsrealtimeinput component)

 

Starting job Tgoogle_realtime_api at 17:45 10/04/2019.

[statistics] connecting to socket on port 3895
[statistics] connected
Apr 10, 2019 5:45:31 PM com.google.api.client.util.store.FileDataStoreFactory setPermissionsToOwnerOnly
WARNING: unable to change permissions for everybody: C:\Users\sthoo\OneDrive\Desktop\Talend\
Apr 10, 2019 5:45:31 PM com.google.api.client.util.store.FileDataStoreFactory setPermissionsToOwnerOnly
WARNING: unable to change permissions for owner: C:\Users\sthoo\OneDrive\Desktop\Talend\ 
2019-04-10 17:45:31.705:INFO::Logging to STDERR via org.mortbay.log.StdErrLog
2019-04-10 17:45:31.706:INFO::jetty-6.1.x
2019-04-10 17:45:31.721:INFO:0683p000009M9p6.pngtarted SocketConnector@localhost:52983
Please open the following address in your browser:
https://accounts.google.com/o/oauth2/auth?client_id= (...... readonly)
Attempting to open that address in the default browser now...
2019-04-10 17:45:53.193:INFO:0683p000009M9p6.pngtopped SocketConnector@localhost:52983
WARN:Got error:403 Forbidden
{
"code" : 403,
"errors" : [ {
"domain" : "usageLimits",
"message" : "Access Not Configured. Google Analytics API has not been used in project xxxxxxxxxx before or it is disabled. Enable it by visiting  then retry. If you enabled this API recently, wait a few minutes for the action to propagate to our systems and retry.",
"reason" : "accessNotConfigured",
"extendedHelp" : "
} ],
"message" : "Access Not Configured. Google Analytics API has not been used in project  before or it is disabled. Enable it by visiting  then retry. If you enabled this API recently, wait a few minutes for the action to propagate to our systems and retry."
}
ERROR0683p000009M9p6.pngtop processing because of error does not allow retry.
Exception in component tGoogleAnalyticsRealtimeInput_1 (Tgoogle_realtime_api)
com.google.api.client.googleapis.json.GoogleJsonResponseException: 403 Forbidden
{
"code" : 403,
"errors" : [ {
"domain" : "usageLimits",
"message" : "Access Not Configured. Google Analytics API has not been used in project  before or it is disabled. Enable it by visiting then retry. If you enabled this API recently, wait a few minutes for the action to propagate to our systems and retry.",
"reason" : "accessNotConfigured",
"extendedHelp" : 
} ],
"message" : "Access Not Configured. Google Analytics API has not been used in before or it is disabled. Enable it by visiting then retry. If you enabled this API recently, wait a few minutes for the action to propagate to our systems and retry."
}
at com.google.api.client.googleapis.json.GoogleJsonResponseException.from(GoogleJsonResponseException.java:145)
at com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:113)
at com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:40)
at com.google.api.client.googleapis.services.AbstractGoogleClientRequest$1.interceptResponse(AbstractGoogleClientRequest.java:321)
at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:1056)
at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:419)
at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:352)
at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.execute(AbstractGoogleClientRequest.java:469)
at de.jlo.talendcomp.google.analytics.realtime.GoogleAnalyticsRealtimeInput.doExecute(GoogleAnalyticsRealtimeInput.java:417)
at de.jlo.talendcomp.google.analytics.realtime.GoogleAnalyticsRealtimeInput.executeDataQuery(GoogleAnalyticsRealtimeInput.java:340)
at de.jlo.talendcomp.google.analytics.realtime.GoogleAnalyticsRealtimeInput.executeQuery(GoogleAnalyticsRealtimeInput.java:401)
at test.tgoogle_realtime_api_0_1.Tgoogle_realtime_api.tGoogleAnalyticsRealtimeInput_1Process(Tgoogle_realtime_api.java:1176)
at test.tgoogle_realtime_api_0_1.Tgoogle_realtime_api.runJobInTOS(Tgoogle_realtime_api.java:1994)
at test.tgoogle_realtime_api_0_1.Tgoogle_realtime_api.main(Tgoogle_realtime_api.java:1843)
[statistics] disconnected

Job Tgoogle_realtime_api ended at 17:45 10/04/2019. [exit code=1]

 

 

For the above error(message" : "Access Not Configured. Google Analytics API has not been used in project )

For this also i am trying to enable but i am getting the error again (

Unable to find the resource you requested)
There was an error while loading /apis/api/analytics.googleapis.com/overview?project=XXXXXXXXXXXXX  Please try again.
 

 

 

 

 

( please share the material for tgoogleanalyticsrealtimeinput component for authentication method: Client ID for native application)

 

Thanks

Madhu

 

 

 

Labels (4)
4 Replies
Anonymous
Not applicable
Author

Please give reply for the above thread and please send the material and help me with the below error message.

Anonymous
Not applicable
Author

Hello,

We have replied to your another topic about:https://community.talend.com/t5/Design-and-Development/Extracting-data-from-Google-Analytics/m-p/157...

Could you please stick to one topic so that we can pay more individule attention to your issue.

Best regards

Sabrina

Anonymous
Not applicable
Author

Hi Sabrina,

 

Please reply for the tGoogleAnalyticsRealtimeInput component in that Authentication Method: Client ID for Native Application .

Please provide the material for tGoogleAnalyticsRealtimeInput component in that Authentication Method: Client ID for Native Application and if you have service account document also both will be helpful

 

Thanks

Madhu

Anonymous
Not applicable
Author

Hello,

tGoogleAnalyticsRealtimeInput is a custom component written by talend community user. We don't have the source code of these components.  It is the ownership of the person who built it.

Best regards

Sabrina