I am trying to pulling data from google analytics ...
# troubleshooting
m
I am trying to pulling data from google analytics extractor and load into redshift but facing this error, can anybody has idea about what's the problem.
j
Which Google Analytics version are you using?
d
@monika_rajput It says
Invalid value at 'report_requests[0].view_id'
in the logs. Is your
view_id
setting set correctly?
j
I ran into the same issue when using the google analytics tap. One problem could be the fact that you supplied the property id as an int
24040634
instead of a str
"24040634"
. Another problem could be the fact that you are using GA4, which isn't supported by the google analytics taps.
m
Thank you so much @jules_huisman @douwe_maan i was supplied view_id in int form. Error resolved😀
d
@jules_huisman @monika_rajput Good catch,
view_id
should be a string even though https://hub.meltano.com/extractors/google-analytics#settings suggests
view_id: 188274549
with an int! I've submitted an MR for the docs: https://gitlab.com/meltano/hub/-/merge_requests/55
I think https://gitlab.com/meltano/tap-google-analytics could be smarter and support both int and string `view_id`s. Feel free to create an issue there or submit a merge request with a fix 🙂