Error getting access and refresh token from google using post request

Hello community,

I tried to connect to a private google sheet using the example workflow "01_Data_Access/05_REST_Web_Services/05_Private_Google_Sheet-meets-Excel"

and it doesn't work. Here's the link for the will they blend post showing and explaining the example Workflow: http://www.knime.org/blog/GoogleSheet-meets-Excel

The first error I got was from the post request node, that there are two columns with the name "body" so I inserted a Column rename node to rename the column from the "Post Request Wizard" to bodyForPost. After fixing this I get constantly from the post request no JSON Column and the Status 400, which means "bad request" and the content type is

application/json; charset=UTF-8

		<p>The body of the post request coming&nbsp;from the wizard node is the following:</p>

		<table>
			<tbody>
				<tr>
					<td>code=4/fVXAVEmiZl2uoOKRcxqvxkY53ZYdGhiSM03mFRvChfw&amp;client_id=140307685204-o4fvqbi6avb0h93smbms0qg565omdukr.apps.googleusercontent.com&amp;client_secret=TOu********&amp;redirect_uri=urn:ietf:wg:oauth:2.0:oob&amp;grant_type=authorization_code</td>
				</tr>
			</tbody>
		</table>
		</td>
	</tr>
</tbody>

Is there anybody who could run this example workflow and perhaps help me what's going wrong?

Thank you

bengo
 

Hi bengo, 

Could you please provide the workflow so I could see the problem? 

Best,

Anna

Hello Anna,

thanks for answering.

Attached you can find my workflow without the client secret. I hope you can work with it, otherwise I have to create something like a google test account or perhaps you know a better way without everybody getting access to my account.

Greetings,
bengo