Hi @webstar,
GCP stands for Google Cloud Platform and Console is just interface I would say. Here is print screen.
Also take a look at this a bit more detailed walkthrough in this topic with additional links:
Br,
Ivan
Hi @webstar,
GCP stands for Google Cloud Platform and Console is just interface I would say. Here is print screen.
Also take a look at this a bit more detailed walkthrough in this topic with additional links:
Br,
Ivan
Unfortunately that walk-through is for gsuite organization -
-We need a walkthru for NON G Suite users as they can ONLY create External which has a completely different downstream options set. The issue is that I dont see any way to publish OAUTH- Do I need that?
Hi @webstar,
not quite sure what gsuite organization is but quite sure Iām not in one. Or at least mail I used for set up
Also regardless of that menus and options should be quite similar.
Br,
Ivan
The options are not similar at all actually - after a few runs i was able to get this to work the following is necessary ā Give A service account access to the data then use API key and download the p2 file on your desktop ā
Thereās a rather definitive fork in the road in the tutorial and thereās two directions with various impacts explained by Google. Posted on the walkthrough. I imagine itās a similar setup, just different consequences depending on the usage of the data.
screen shot of blog discussing knime google authentication api key node.
I believe these have more to do with āappsā using the sensitive data in the wrong setting which would then require a security review which can yada yada yada. Given desires are to query data on a desktop, I donāt think itās a big deal.
Best,
T
Thanks - -there is a definitive fork for sure ā however the external choice makes a big difference what happens "nextā -when choosing this fork. MY connection with Google Analytics is working and I DID not complete that section ā neither External nor internal
Thatās awesome, so you donāt need to add anything here, just make a service account and hit play?
Iām following a fork path due to obligations but will make an adjustment to the blog if it makes sense. Thanks for the help, iād hate to send people down this pipeline if itās not relevant. Appreciate your help.
Best,
T
I confirm that I followed the tuto without completing the internal/external section and the Google API connection is working fine.
Thanks, I could connect the Google Authentication (API Key), but not with the normal google authentication node. However, even though I was able to create and read a google sheet, I couldnāt see it at the google sheets interface. I need to show (to a class) the interactivity between google sheets and Knime, making a formula on google sheets, and read it again. Could you help me?
Tyler - sorry for the delayed reply - I do think it makes sense to make an adjustment to the blog, but this is my opinion. It is very easy to get stuck if you try to follow the path shown due to the fact that it might appear as though you are waiting for google to approve your connection-- we can connect directly if that is helpful
Yes - you have to skip that part if you are a free user!
The problem is that if youāre using a service account, the account acts as a separate entity, so the Sheets you are writing wonāt automatically be shared with your own account.
The workflow Share Spreadsheet To Account (KNIME 4.1) showcases how you can share a Sheet written to a service account with a list of other users.
We have an update on the Google Authentication situation.
For Google Sheets and Google Drive, you should now be able to use the Google Authentication node again. For it to work you have to make sure to deselect the Google Analytics scopes in the nodeās configuration dialog. Google applied some restrictions, so that authentication does not work when requesting the Google Analytics scopes at the moment.
For Google Analytics, for the time being, you have to continue using the Google Authentication (API Key) node.
Sorry for the inconvenience.
Will update it this weekend, thanks for the help.
Agreed on scopes being what you troubleshoot the most at the startup.
I would highly recommend developing all the āscopeā tools as necessary, label it, and never do it again.
Iāve unselected anything to do with Google Analytics. The have tried playing around with the various remaining selections. (Google Sheets Read, Google Sheets and Google Drive Read) and other single and double combinations - but it still doesnāt work.
Once I click authenticate it brings me to google sign in
I choose my account
Google then asks about permissions / access - I click allow
inside the browser it looks like it is working. āReceived verification code. You may now close this window.ā
i go back to knime and it gives me a timeout error. "Authentication failed. SocketTimeoutException: connect time out
please help
Welcome to the community @onizuka023.
The Authentication pass through doesnāt seem to work for me too. Above I posted about needing a gsuite account to setup the google authentication node, however I was incorrect and Iāve updated the blog.
You can use this to setup the google api authentication node, which will allow you to use these nodes regularly, without the authentication piece that I believe expires after a certain amount of hours.
Discussed here too. KNIME Google Authentication API Key Walkthrough
hi Tyler
I did the API setup but I get stuck on the - give the service account created access to the google sheets. My company does not allow the sharing of files outside of the company. And therefore the gserviceaccount.com is blocked / not a whitelisted domain.
This is why I had to go the Google Authentication route.
Is there any other alternative? Why does this node not work as designed. / On older versions of KNIME it previously worked.
thanks
That makes sense, sorry to hear about the environment problems. Sounds like your IT team needs to make an exception if this is the intended route for the environment. I would work with the head of engineering and ask if this is okay. Get approvals from the top and then request it be whitelisted.
Before meeting with decision makers, I like to have a POC available, to show the value and setup process if needed.
Thought more about it, have you asked where the source of the data is coming from because I have a feeling that will remove this gsuite gate.
i think itās more about KNIME and the node that works for some, but not for all. going the route of hey company change your policy is more difficult than KNIME fixing things on their end. Iām almost certain Iām not the only person who has an uphill battle with corporate. but my work around now is - google to excel, excel to db.