Big Query plugin for Google Sheet

[Shahin]

HI there, 

when i try to use BQ plugin i constantly get this error:

Invalid project ID 'xxxxxxx'. Project IDs must contain 6-63 lowercase letters, digits, or dashes. IDs must start with a letter and may not end with a dash.

the dataset name in BQ is a number (=view id in GA)

I´ve used this query in the Gsheet plugin

SELECT fullVisitorId FROM [732xxxxx.ga_sessions_201xxxxx] LIMIT 1000

any idea how to solve the issue?

thank you.

Shahin

[Mikael Thuneberg]

No idea, that error is coming from Google, not our system.

--
You received this message because you are subscribed to the Google Groups "Supermetrics" group.
To unsubscribe from this group and stop receiving emails from it, send an email to automateanalyt...@googlegroups.com.
Visit this group at https://groups.google.com/group/automateanalytics.
To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/8830fd48-4f5c-4b95-8c4f-631c1ef57651%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Shahin]

uhmm, the exact same query works in BQ...

[Mikael Thuneberg]

But not in their API apparently..

To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/23156edd-c686-4d1c-ba25-b42dd8ab5d50%40googlegroups.com.

[Shahin]

HI, 

i will escalate the issue to our Google Support, can you please explain what the problem with their API is?

thank you!

Shahin

[Shahin]

HI can you please tell me what method you´re using to call the google API?

i would like to escalate this issue to our Google Support, 

is it possible that you´re switching ProjectId and ClientID in your call? see here

thank you.

[Mikael Thuneberg]

Does this still occur if you try now?

--

You received this message because you are subscribed to the Google Groups "Supermetrics" group.
To unsubscribe from this group and stop receiving emails from it, send an email to automateanalyt...@googlegroups.com.
Visit this group at https://groups.google.com/group/automateanalytics.

To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/5a35c980-70c0-41a0-a0f8-8ebc3cdf6fca%40googlegroups.com.

[Shahin]

yes, still there.

Shouldn´t the project id include also the part after the ":" ?

[Clinton Deacon]

Hello

We have added some additional logging to our system so we can try to understand exactly what is happening. So if you could try again and let us know when you have, we'll take a look again.

To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/367d4513-0b10-4025-b495-e6b11b7280cd%40googlegroups.com.

[mi...@bueller.us]

Hi Clinton,

I'm getting this error as well.

Please let me know if there is any specific data I can provide that will help you troubleshoot this.

To test if my BQ set up and authentication works with third-party solutions, I tested my query with the OWOX add-on for Google Sheets and after authenticating the same BQ account that I have set up in SM, OWOX returns the data requested by the query without throwing the "Invalid project ID" error.

Thanks for your help and attention to this.

Best,

Mike

[Clinton Deacon]

Could you send the full query?

Kind Regards

Clinton Deacon

Senior Application Developer

http://www.supermetrics.com

To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/87dfa02e-d87e-4d53-94b7-7805b27b0b62%40googlegroups.com.