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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Json format issue when comes from Google Analytics

I try to add a JSON file in the repository. This Json file comes from Google Analytics API.
This file is well formed but I can declare it in the directory due to the error ""{0}" is not found or the json format is incorrect."
Please find below the content of my Json file.
{
"kind": "analytics#gaData",
"id": " https://www.googleapis.com/analytics/v3/data/ga?ids=ga:xxxx&dimensions=ga:medium,ga:source&metrics=g...0683p000009MAB6.png",
"query": {
"start-date": "2013-03-01",
"end-date": "2013-03-31",
"ids": "ga:xxxx",
"dimensions": "ga:medium,ga:source",
"metrics": ,
"sort": ,
"start-index": 1,
"max-results": 999
},
"itemsPerPage": 999,
"totalResults": 139,
"selfLink": " https://www.googleapis.com/analytics/v3/data/ga?ids=ga:xxxx&dimensions=ga:medium,ga:source&metrics=g...0683p000009MAB6.png",
"profileInfo": {
"profileId": "xxxx",
"accountId": "yyyy",
"webPropertyId": "UA-aaaa",
"internalWebPropertyId": "zzzz",
"profileName": "Production",
"tableId": "ga:xxxx"
},
"containsSampledData": false,
"columnHeaders": ,
"totalsForAllResults": {
"ga 0683p000009MAB6.pngageviews": "1234",
"ga:visits": "123",
"ga:visitors": "12"
},
"rows": ,
,
,

]
}
Labels (3)
1 Reply
Anonymous
Not applicable
Author

Probably you can avoid parsing it by using the tGoogleAnalyticsInput component from talend exchange:
http://www.talendforge.org/exchange/index.php?eid=537&product=tos&action=view&nav=0,1,1
This component use the Java API to Google Analytics and parse everything for you.
The next advantage is, you don't have to define for every query a new json metadata schema.