Issue 716 in google-gdata: Execution of authentication request returned unexpected result: 404

393 views
Skip to first unread message

google...@googlecode.com

unread,
May 26, 2015, 4:39:24 PM 5/26/15
to gdata-dotnet-...@googlegroups.com
Status: New
Owner: ----

New issue 716 by APUS...@gmail.com : Execution of authentication request
returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

What steps will reproduce the problem?
1. After the "GA_Service.Credentials = new GDataCredentials (strGAUserName,
strGAPassword);"
2.var token = GA_Service.QueryAuthenticationToken();
3. GA_Service.SetAuthenticationToken(token);

What is the expected output? What do you see instead?

It was working fine, but now i get this error after 10 times of data pull.


What version of the product are you using? On what operating system?
Google.GData.Analytics V 2.2.0.0

Please provide any additional information below.


--
You received this message because this project is configured to send all
issue notifications to this address.
You may adjust your notification preferences at:
https://code.google.com/hosting/settings

google...@googlecode.com

unread,
May 26, 2015, 5:30:18 PM 5/26/15
to gdata-dotnet-...@googlegroups.com

Comment #1 on issue 716 by evilstee...@gmail.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

I am having the very same problem - my code has been working for two years
without any issues. Same exception:

Unhandled Exception: Google.GData.Client.GDataRequestException: Execution
of aut hentication request returned unexpected result: 404 at
Google.GData.Client.Utilities.getAuthException(TokenCollection tokens, Htt
pWebResponse response) at
Google.GData.Client.Utilities.QueryClientLoginToken(GDataCredentials gc, S
tring serviceName, String applicationName, Boolean fUseKeepAlive, IWebProxy
prox yServer, Uri clientLoginHandler) at
Google.GData.Client.GDataGAuthRequest.QueryAuthToken(GDataCredentials gc)
at Google.GData.Client.GDataGAuthRequest.EnsureCredentials() at
Google.GData.Client.GDataRequest.EnsureWebRequest() at
Google.GData.Client.GDataGAuthRequest.EnsureWebRequest() at
Google.GData.Client.GDataRequest.Execute() at
Google.GData.Client.GDataGAuthRequest.Execute(Int32 retryCounter) at
Google.GData.Client.GDataGAuthRequest.Execute() at
Google.GData.Client.Service.Query(Uri queryUri, DateTime ifModifiedSince,
String etag, Int64& contentLength) at
Google.GData.Client.Service.Query(FeedQuery feedQuery) at
Google.GData.Documents.DocumentsService.Query(DocumentsListQuery feedQuery
) at GoogleLogger.GoogleService.getLastXECLogRows(String folderName, String
fileName, Int32 rows)

This is occurring on my production system, so it's a huge problem for us.

google...@googlecode.com

unread,
May 26, 2015, 5:36:25 PM 5/26/15
to gdata-dotnet-...@googlegroups.com

Comment #2 on issue 716 by evilstee...@gmail.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

This site is down:
https://developers.google.com/accounts/RegistrationForWebApps

google...@googlecode.com

unread,
May 26, 2015, 6:27:42 PM 5/26/15
to gdata-dotnet-...@googlegroups.com

Comment #3 on issue 716 by k...@kuwaitculturela.org : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

I am getting a similar issue. Getting 404'ed when it was working fine just
prior to 14:53 PST. I'm using Google.GData.Spreadsheets 2.2.0.0

google...@googlecode.com

unread,
May 26, 2015, 6:50:39 PM 5/26/15
to gdata-dotnet-...@googlegroups.com

Comment #4 on issue 716 by evilstee...@gmail.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

I take it you guys all use the GData API still? I have been digging around
and it seems that there is a new API:

https://developers.google.com/drive/web/quickstart/quickstart-cs

I really hope that the old GData API is still supported or we'll have to
rewrite everything. BTW the new Drive API is not supported by .Net 3.5 - so
this is a huge disaster for me.

google...@googlecode.com

unread,
May 26, 2015, 9:02:03 PM 5/26/15
to gdata-dotnet-...@googlegroups.com

Comment #5 on issue 716 by APUS...@gmail.com : Execution of authentication
request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

yes .. it was working fine until 3 PM ET today .. then BOOM!!!!!

anyone found the solution???

google...@googlecode.com

unread,
May 26, 2015, 9:25:27 PM 5/26/15
to gdata-dotnet-...@googlegroups.com

Comment #6 on issue 716 by ad...@dloweb.com : Execution of authentication
request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

I have the same problem. Authentication is not working for me at all. I
really don't want to rewrite everything either.

google...@googlecode.com

unread,
May 26, 2015, 9:54:30 PM 5/26/15
to gdata-dotnet-...@googlegroups.com

Comment #7 on issue 716 by lhfied...@gmail.com : Execution of authentication
request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

I'm seeing the same issue ...

Type
Google.GData.Client.GDataRequestException

Message
Execution of authentication request returned unexpected result: 404

Stack ...
at Google.GData.Client.Utilities.getAuthException(TokenCollection tokens,
HttpWebResponse response) at
Google.GData.Client.Utilities.QueryClientLoginToken(GDataCredentials gc,
String serviceName, String applicationName, Boolean fUseKeepAlive,
IWebProxy proxyServer, Uri clientLoginHandler) at
Google.GData.Client.GDataGAuthRequest.QueryAuthToken(GDataCredentials gc)
at Google.GData.Client.GDataGAuthRequest.EnsureCredentials() at
Google.GData.Client.GDataRequest.EnsureWebRequest() at
Google.GData.Client.GDataGAuthRequest.EnsureWebRequest() at
Google.GData.Client.GDataRequest.Execute() at
Google.GData.Client.GDataGAuthRequest.Execute(Int32 retryCounter) at
Google.GData.Client.Service.Query(Uri queryUri, DateTime ifModifiedSince,
String etag, Int64& contentLength) at
Google.GData.Client.Service.Query(FeedQuery feedQuery) at
Google.GData.Spreadsheets.SpreadsheetsService.Query(SpreadsheetQuery
feedQuery)

google...@googlecode.com

unread,
May 26, 2015, 10:57:47 PM 5/26/15
to gdata-dotnet-...@googlegroups.com

Comment #8 on issue 716 by aynch...@gmail.com : Execution of authentication
request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

Also experiencing the error with em client accessing Google contacts. Works
for email and calendar, but not for contacts since 12 pm PST today.

google...@googlecode.com

unread,
May 26, 2015, 10:58:48 PM 5/26/15
to gdata-dotnet-...@googlegroups.com

Comment #9 on issue 716 by yuceloz...@gmail.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

Also Sample Applications give the same error. Anybody get error on version
2.1 ?

google...@googlecode.com

unread,
May 26, 2015, 11:11:08 PM 5/26/15
to gdata-dotnet-...@googlegroups.com

Comment #10 on issue 716 by wang.zha...@gosugroup.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

I get same issue today. hurry!

google...@googlecode.com

unread,
May 26, 2015, 11:39:49 PM 5/26/15
to gdata-dotnet-...@googlegroups.com

Comment #11 on issue 716 by eron...@gmail.com : Execution of authentication
request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

Same here, i'm using GData API v2.2

google...@googlecode.com

unread,
May 26, 2015, 11:47:39 PM 5/26/15
to gdata-dotnet-...@googlegroups.com

Comment #12 on issue 716 by dmonkey1...@gmail.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

There is a note on the sheets API page
( https://developers.google.com/google-apps/spreadsheets/authorize ) saying
that OAuth1.0 will be killed off on May 5th and you have to use the OAuth
2.0 service.

google...@googlecode.com

unread,
May 27, 2015, 12:51:57 AM 5/27/15
to gdata-dotnet-...@googlegroups.com

Comment #13 on issue 716 by alex....@cantaloupesys.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

I am also started this issue around 12pm PDT.

Google.GData.Client.GDataRequestException: Execution of authentication
request returned unexpected result: 404
at Google.GData.Client.Utilities.getAuthException(TokenCollection
tokens, HttpWebResponse response)
at Google.GData.Client.Utilities.QueryClientLoginToken(GDataCredentials
gc, String serviceName, String applicationName, Boolean fUseKeepAlive,
IWebProxy proxyServer, Uri clientLoginHandler)
at Google.GData.Client.GDataGAuthRequest.QueryAuthToken(GDataCredentials
gc)
at
Google.GData.Client.GDataGAuthRequestFactory.QueryAuthToken(GDataCredentials
gc)
at Google.GData.Client.Service.QueryClientLoginToken()

google...@googlecode.com

unread,
May 27, 2015, 1:32:53 AM 5/27/15
to gdata-dotnet-...@googlegroups.com

Comment #14 on issue 716 by sunny198...@gmail.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

Please update if someone find solution.

google...@googlecode.com

unread,
May 27, 2015, 1:38:26 AM 5/27/15
to gdata-dotnet-...@googlegroups.com

Comment #15 on issue 716 by sunny198...@gmail.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

Please update if someone find solution.I am getting this issue when try to
read group names,till yesterday everything was working fine.
Following is the exception which i am getting:

at Google.GData.Client.Utilities.getAuthException(TokenCollection tokens,
HttpWebResponse response)
at Google.GData.Client.Utilities.QueryClientLoginToken(GDataCredentials
gc, String serviceName, String applicationName, Boolean fUseKeepAlive,
IWebProxy proxyServer, Uri clientLoginHandler)
at Google.GData.Client.GDataGAuthRequest.QueryAuthToken(GDataCredentials
gc)
at Google.GData.Client.GDataGAuthRequest.EnsureCredentials()
at Google.GData.Client.GDataRequest.EnsureWebRequest()
at Google.GData.Client.GDataGAuthRequest.EnsureWebRequest()
at Google.GData.Client.GDataRequest.Execute()
at Google.GData.Client.GDataGAuthRequest.Execute(Int32 retryCounter)
at Google.GData.Client.GDataGAuthRequest.Execute()
at Google.GData.Client.Service.Query(Uri queryUri, DateTime
ifModifiedSince, String etag, Int64& contentLength)
at Google.GData.Client.Service.Query(Uri queryUri, DateTime
ifModifiedSince)
at Google.GData.Client.Service.Query(FeedQuery feedQuery)
at Google.GData.Client.Feed`1.get_AtomFeed()
at Google.GData.Client.Feed`1.<get_Entries>d__0.MoveNext()
at IMAPCommands.GetGroups.PrintAllGroups(ContactsRequest cr) in
e:\back\TestFolder\IMAPCommands\IMAPCommands\GetGroups.cs:line 18
at IMAPCommands.Program.Main(String[] args) in
e:\back\TestFolder\IMAPCommands\IMAPCommands\Program.cs:line 22
at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[]
args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence
assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext
executionContext, ContextCallback callback, Object state, Boolean
preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext
executionContext, ContextCallback callback, Object state, Boolean
preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext
executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()

google...@googlecode.com

unread,
May 27, 2015, 1:44:29 AM 5/27/15
to gdata-dotnet-...@googlegroups.com

Comment #16 on issue 716 by off...@e-cosmetorium.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

I have exactly the same problem... My production systems depends on google
docs and I have a major disaster now. Any knows if google is working on
that ?

google...@googlecode.com

unread,
May 27, 2015, 1:49:00 AM 5/27/15
to gdata-dotnet-...@googlegroups.com

Comment #17 on issue 716 by off...@e-cosmetorium.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

Guys isn't it somehow connected with the information:
'OAuth 1.0 is no longer supported and will be disabled on May 5, 2015'
https://developers.google.com/google-apps/spreadsheets/authorize

Anyone migrate code to use OAuth 2.0 and thus solved the problem?

google...@googlecode.com

unread,
May 27, 2015, 1:51:03 AM 5/27/15
to gdata-dotnet-...@googlegroups.com

Comment #18 on issue 716 by sunny198...@gmail.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

But today is 27 May.

google...@googlecode.com

unread,
May 27, 2015, 1:52:23 AM 5/27/15
to gdata-dotnet-...@googlegroups.com

Comment #19 on issue 716 by sunny198...@gmail.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

But today is 27 May :-), Why it is reflecting after almost 20 days.

google...@googlecode.com

unread,
May 27, 2015, 1:57:10 AM 5/27/15
to gdata-dotnet-...@googlegroups.com

Comment #20 on issue 716 by off...@e-cosmetorium.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

No idea why it may take an effect 20 days later.
Any one who have code snippet in .NET with the authentication OAuth 2.0 , I
try to solve it on production as fast as I can now.

Thanks

google...@googlecode.com

unread,
May 27, 2015, 2:38:05 AM 5/27/15
to gdata-dotnet-...@googlegroups.com

Comment #21 on issue 716 by pallavi....@paxcel.net : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

Anybody has a fix ? Please let us know immediately

google...@googlecode.com

unread,
May 27, 2015, 2:42:00 AM 5/27/15
to gdata-dotnet-...@googlegroups.com

Comment #22 on issue 716 by sangeeth...@gmail.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716



While fetching gmail contact details m getting "Execution of authentication
request returned unexpected result: 404" Exception ... please kindly help
me to sort out this issue as earlier as possible.


Below mention is my Code
RequestSettings rs = new RequestSettings("MyNetwork Web Application!",
TEmailID, Tpass);
rs.AutoPaging = true;
ContactsRequest cr = new ContactsRequest(rs);
Feed<Contact> f = cr.GetContacts();

google...@googlecode.com

unread,
May 27, 2015, 3:55:04 AM 5/27/15
to gdata-dotnet-...@googlegroups.com

Comment #23 on issue 716 by evilstee...@gmail.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

Clearly we'll need to use OAuth2 but the only examples I've run across use
copy/pasting a URL into a web browser and retrieving it, and then pasting
it into the command line:

https://developers.google.com/google-apps/spreadsheets/authorize

I'm running an application outside of a web browser, so that's not an
option. We need to find an OAuth2 example that works without manually
accepting a token.

google...@googlecode.com

unread,
May 27, 2015, 4:05:21 AM 5/27/15
to gdata-dotnet-...@googlegroups.com

Comment #24 on issue 716 by sangeeth...@gmail.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

M using GContacts Data API provided by Google to retrieve contacts from
gmail ... using asp.net c#(VS2010). Please guide me how to solve this
problem.

what is this OAuth2?

google...@googlecode.com

unread,
May 27, 2015, 6:38:51 AM 5/27/15
to gdata-dotnet-...@googlegroups.com

Comment #25 on issue 716 by a.kopa...@oorraa.net : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

I've managed to solve this by using this solution with Service Account with
oAuth2.0
http://stackoverflow.com/questions/13664731/accessing-older-gdata-apis-spreadsheet-api-using-oauth-2-and-a-service-account

The solution:
1. Create Project and Google Service Account in
https://console.developers.google.com/project
2. Generate your p12 key.
3. Allow APIs in Developer console you want to use (basically we are going
to use old API, so you can skip this step, but just in case)
4. Use the code below (.NET Framework 4.5!):

using System.Security.Cryptography.X509Certificates;
using Google.GData.Client;
using Google.GData.Extensions;
using Google.GData.Spreadsheets;
using Google.Apis.Auth.OAuth2;

string keyFilePath = @"C:\key.p12"; // found in developer console
string serviceAccountEmail = " youra...@developer.gserviceaccount.com ";
// found in developer console
var certificate = new X509Certificate2(keyFilePath, "notasecret",
X509KeyStorageFlags.Exportable);

ServiceAccountCredential credential = new ServiceAccountCredential(new
ServiceAccountCredential.Initializer(serviceAccountEmail) //create
credential using certigicate
{
Scopes = new[] { " https://spreadsheets.google.com/feeds/ " }
//this scopr is for spreadsheets, check google scope FAQ for others
}.FromCertificate(certificate));

credential.RequestAccessTokenAsync(System.Threading.CancellationToken.None).Wait();
//request
token

var requestFactory = new GDataRequestFactory("Some Name");
requestFactory.CustomHeaders.Add(string.Format("Authorization: Bearer {0}",
credential.Token.AccessToken));

SpreadsheetsService myService = new SpreadsheetsService("You App Name");
//create your old service
myService.RequestFactory = requestFactory; //add new request factory to
your old service

SpreadsheetQuery query = new SpreadsheetQuery(); //do the job as you done
it before
SpreadsheetFeed feed = myService.Query(query);

google...@googlecode.com

unread,
May 27, 2015, 6:49:11 AM 5/27/15
to gdata-dotnet-...@googlegroups.com

Comment #26 on issue 716 by a.kopa...@oorraa.net : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

Also don't forget to grant " youra...@developer.gserviceaccount.com "
access to your spreadsheet document as you grant permissions for usual
users by pressing Share.

google...@googlecode.com

unread,
May 27, 2015, 7:31:16 AM 5/27/15
to gdata-dotnet-...@googlegroups.com

Comment #27 on issue 716 by magda.se...@gmail.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

Looks like this is the right direction for me as well, but now i'm getting
exception when I call Query method.



var query = new SpreadsheetQuery();
query.Title ="some title";
var feed = Service.Query(query);//<- exception

Any idea what could be wrong, or what should I do to check it out?

[XmlException: Root element is missing.]
System.Xml.XmlTextReaderImpl.Throw(Exception e) +69
System.Xml.XmlTextReaderImpl.ParseDocumentContent() +5674146
System.Xml.XmlTextReaderImpl.Read() +213
System.Xml.XmlTextReader.Read() +13
Google.GData.Client.BaseFeedParser.MoveToStartElement(XmlReader reader)
+174
Google.GData.Client.AtomFeedParser.Parse(Stream streamInput, AtomFeed
feed) +117

[ClientFeedException: Parsing failed]
Google.GData.Client.AtomFeedParser.Parse(Stream streamInput, AtomFeed
feed) +202
Google.GData.Client.AtomFeed.Parse(Stream stream, AlternativeFormat
format) +273
Google.GData.Client.Service.CreateAndParseFeed(Stream inputStream, Uri
uriToUse) +207
Google.GData.Client.Service.Query(FeedQuery feedQuery) +417
Google.GData.Spreadsheets.SpreadsheetsService.Query(SpreadsheetQuery
feedQuery) +42
ECosmetorium.Web.BLL.ManagerSpreadsheet.GetSpreadSheet(String url) in
c:\Users\Administrator\Source\Workspaces\Clip -
Prototype\ECosmetorium.Web\BLL\ManagerSpreadsheet.cs:1104
ECosmetorium.Web.BLL.ManagerSpreadsheet.GetListFeed(String
spreadsheetUrl, String worksheetname) in
c:\Users\Administrator\Source\Workspaces\Clip -
Prototyp\BLL\ManagerSpreadsheet.cs:902
ECosmetorium.Web.BLL.ManagerSpreadsheet.LoadAllProducts() in
c:\Users\Administrator\Source\Workspaces\Clip -
Prototype\ECosmetorium.Web\BLL\ManagerSpreadsheet.cs:406
b.BLL.ManagerSpreadsheet..ctor() in
c:\Users\Administrator\Source\Workspaces\Clip -
PrototypeLL\ManagerSpreadsheet.cs:56
eb.Pages.ExportOptimaInvoices.Page_Load(Object sender, EventArgs e) in
c:\Users\Administrator\Source\WoProPages\ExportOptimaInvoices.aspx.cs:25
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender,
EventArgs e) +51
System.Web.UI.Control.OnLoad(EventArgs e) +92
System.Web.UI.Control.LoadRecursive() +54
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +772

google...@googlecode.com

unread,
May 27, 2015, 10:38:40 AM 5/27/15
to gdata-dotnet-...@googlegroups.com

Comment #28 on issue 716 by APUS...@gmail.com : Execution of authentication
request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

thanks Kopa.

I followed all the steps you mention, i get the below
error. "<internalReason>Login Required</internalReason>"

Google.GData.Client.GDataRequestException was unhandled
HResult=- 2146233088
Message=Execution of request failed:
https://www.google.com/analytics/feeds/data?max-results=10000&dimensions=ga:dimension2,ga:source,ga:medium,ga:campaign,ga:keyword,ga:date,ga:hour&end-date=2015-05-23&ids=ga:19249406&metrics=ga:sessions,ga:goalCompletionsAll,ga:goal2Completions,ga:goal3Completions,ga:goal9Completions,ga:goal10Completions,ga:goal13Completions,ga:goal14Completions&sort=ga:date,ga:hour&start-date=2015-05-22
Source=Google.GData.Client
ResponseString=<?xml version="1.0" encoding="UTF-8"?><errors
xmlns=" http://schemas.google.com/g/2005 "><error><domain>GData</domain><code>required</code><location
type="header">Authorization</location><internalReason>Login
Required</internalReason></error></errors>

google...@googlecode.com

unread,
May 27, 2015, 11:48:29 AM 5/27/15
to gdata-dotnet-...@googlegroups.com

Comment #29 on issue 716 by isherw...@trunkclub.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

how do I get the dll for using Google.Apis.Auth.OAuth2? I'm trying to edit
this http://www.statslice.com/leveraging-google-docs-with-ssis to get it
working again. The change completely busted it.

google...@googlecode.com

unread,
May 27, 2015, 11:51:31 AM 5/27/15
to gdata-dotnet-...@googlegroups.com

Comment #30 on issue 716 by Sherwood...@gmail.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

how do I get the dll for using Google.Apis.Auth.OAuth2;. I'm trying to fix
http://www.statslice.com/leveraging-google-docs-with-ssis to get it working
again. Any help would be great

Ashish Sharma

unread,
May 27, 2015, 1:44:35 PM 5/27/15
to gdata-dotnet-...@googlegroups.com, codesite...@google.com, google...@googlecode.com

google...@googlecode.com

unread,
May 27, 2015, 1:46:20 PM 5/27/15
to gdata-dotnet-...@googlegroups.com

Comment #31 on issue 716 by evilstee...@gmail.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

Alright, I figured it out. Step by step instructions as follows - also see
the code I provided below. FYI, this runs in .Net 3.5 and unlike the
solution offered previously there are no new dependencies. You should be up
and running in no time.

1. If you haven't yet create your OAuth 2.0 credentials - I assume you
already know how to get those but here:
a) Log into your Google developer console:
http://console.developers.google.com
b) Create a project
c) Create your credentials - use 'installed application'
d) add the APIs that you need - I think Drive API is definitely
required. I also added Drive SDK just in case.
2. Copy the code below into VS and edit the first Main() method with your
client key and secret key.
3. Run the app and copy both the new access token and the refresh token.
Put those and your remaining credentials into the second Main() method
below.
4. You now should be able to run the second Main() method (just reverse the
naming). From now on that will be all you need - there is no need to re-run
the first Main() method.

BTW, the first Main() method below was found here:
https://developers.google.com/google-apps/spreadsheets/authorize

CODE:

using System;
using Google.GData.Client;
using Google.GData.Spreadsheets;
using Google.GData.Documents;
using System.Configuration;
using System.Collections.Specialized;

namespace GoogleSpreadsheet
{
class GoogleOAutho2
{

private static String folderName = "crazy.ivan";


static void Main(string[] args)
{

////////////////////////////////////////////////////////////////////////////
// STEP 1: Configure how to perform OAuth 2.0

////////////////////////////////////////////////////////////////////////////

// TODO: Update the following information with that obtained from
// https://code.google.com/apis/console . After registering
// your application, these will be provided for you.

string CLIENT_ID = "your_client_id";

// This is the OAuth 2.0 Client Secret retrieved
// above. Be sure to store this value securely. Leaking this
// value would enable others to act on behalf of your application!
string CLIENT_SECRET = "your_secret_key"

// Space separated list of scopes for which to request access.
string SCOPE = " https://www.googleapis.com/auth/drive
https://spreadsheets.google.com/feeds https://docs.google.com/feeds ";

// This is the Redirect URI for installed applications.
// If you are building a web application, you have to set your
// Redirect URI at https://code.google.com/apis/console .
string REDIRECT_URI = "urn:ietf:wg:oauth:2.0:oob";

string TOKEN_TYPE = "refresh";


////////////////////////////////////////////////////////////////////////////
// STEP 2: Set up the OAuth 2.0 object

////////////////////////////////////////////////////////////////////////////

// OAuth2Parameters holds all the parameters related to OAuth 2.0.
OAuth2Parameters parameters = new OAuth2Parameters();

// Set your OAuth 2.0 Client Id (which you can register at
// https://code.google.com/apis/console ).
parameters.ClientId = CLIENT_ID;

// Set your OAuth 2.0 Client Secret, which can be obtained at
// https://code.google.com/apis/console .
parameters.ClientSecret = CLIENT_SECRET;

// Set your Redirect URI, which can be registered at
// https://code.google.com/apis/console .
parameters.RedirectUri = REDIRECT_URI;


////////////////////////////////////////////////////////////////////////////
// STEP 3: Get the Authorization URL

////////////////////////////////////////////////////////////////////////////

// Set the scope for this particular service.
parameters.Scope = SCOPE;

parameters.AccessType = "offline"; // IMPORTANT and was missing in the
original

parameters.TokenType = TOKEN_TYPE; // IMPORTANT and was missing in the
original


// Get the authorization url. The user of your application must visit
// this url in order to authorize with Google. If you are building a
// browser-based application, you can redirect the user to the
authorization
// url.
string authorizationUrl =
OAuthUtil.CreateOAuth2AuthorizationUrl(parameters);
Console.WriteLine(authorizationUrl);
Console.WriteLine("Please visit the URL above to authorize your OAuth "
+ "request token. Once that is complete, type in your access code to "
+ "continue...");
parameters.AccessCode = Console.ReadLine();


////////////////////////////////////////////////////////////////////////////
// STEP 4: Get the Access Token

////////////////////////////////////////////////////////////////////////////

// Once the user authorizes with Google, the request token can be
exchanged
// for a long-lived access token. If you are building a browser-based
// application, you should parse the incoming request token from the url
and
// set it in OAuthParameters before calling GetAccessToken().
OAuthUtil.GetAccessToken(parameters);
string accessToken = parameters.AccessToken;
string refreshToken = parameters.RefreshToken;
Console.WriteLine("OAuth Access Token: " + accessToken + "\n");
Console.WriteLine("OAuth Refresh Token: " + refreshToken + "\n");


////////////////////////////////////////////////////////////////////////////
// STEP 5: Make an OAuth authorized request to Google

////////////////////////////////////////////////////////////////////////////

// Initialize the variables needed to make the request
GOAuth2RequestFactory requestFactory =
new GOAuth2RequestFactory(null, "MySpreadsheetIntegration-v1",
parameters);
SpreadsheetsService service = new
SpreadsheetsService("MySpreadsheetIntegration-v1");
service.RequestFactory = requestFactory;

// Make the request to Google
// See other portions of this guide for code to put here...

// Instantiate a SpreadsheetQuery object to retrieve spreadsheets.
Google.GData.Spreadsheets.SpreadsheetQuery query = new
Google.GData.Spreadsheets.SpreadsheetQuery();

// Make a request to the API and get all spreadsheets.
SpreadsheetFeed feed = service.Query(query);

// Iterate through all of the spreadsheets returned
foreach (SpreadsheetEntry entry in feed.Entries)
{
// Print the title of this spreadsheet to the screen
Console.WriteLine(entry.Title.Text);
}
Console.ReadLine();

}


// once you copied your access and refresh tokens
// then you can run this method directly from now on...
static void MainX(string[] args)
{
GOAuth2RequestFactory requestFactory = RefreshAuthenticate();

SpreadsheetsService service = new
SpreadsheetsService("MySpreadsheetIntegration-v1");
service.RequestFactory = requestFactory;

// Instantiate a SpreadsheetQuery object to retrieve spreadsheets.
Google.GData.Spreadsheets.SpreadsheetQuery query = new
Google.GData.Spreadsheets.SpreadsheetQuery();

// Make a request to the API and get all spreadsheets.
SpreadsheetFeed feed = service.Query(query);

// Iterate through all of the spreadsheets returned
foreach (SpreadsheetEntry entry in feed.Entries)
{
// Print the title of this spreadsheet to the screen
Console.WriteLine(entry.Title.Text);
}
Console.ReadLine();



public static GOAuth2RequestFactory RefreshAuthenticate() {
OAuth2Parameters parameters = new OAuth2Parameters(){
RefreshToken
= "the_refresh_token_you_copied_from_the_CLI_running_the_first_method";
AccessToken
= "the_access_token_you_copied_from_the_CLI_running_the_first_method";
ClientId = "your_client_id";
ClientSecret = "your_dirty_little_secret";
Scope = " https://www.googleapis.com/auth/drive
https://spreadsheets.google.com/feeds ",
AccessType = "offline",
TokenType = "refresh"
};
string authUrl = OAuthUtil.CreateOAuth2AuthorizationUrl(parameters);
return new GOAuth2RequestFactory(null, "evilspeculator", parameters);
}
}
}

Hope that works for you guys - best of luck!

google...@googlecode.com

unread,
May 27, 2015, 11:21:22 PM 5/27/15
to gdata-dotnet-...@googlegroups.com

Comment #32 on issue 716 by fernando...@gmail.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

I get same issue with this code. Anybody has a fix?... please


Dim gkey As String = "?key=" & PublicAPIkey


Dim dataFeedUrl As String
= " https://www.google.com/analytics/feeds/data " + gkey
Dim service As Google.GData.Analytics.AnalyticsService = New
Google.GData.Analytics.AnalyticsService("All Web Site Data")
service.setUserCredentials(username, pass)



Dim query1 As DataQuery = New DataQuery(dataFeedUrl)

query1.Ids = "ga:99999999"
query1.Metrics = "ga:users"


query1.GAStartDate = DateTime.Now.ToString("yyyy-MM-dd")
query1.GAEndDate = DateTime.Now.ToString("yyyy-MM-dd")
query1.StartIndex = 1

Dim dataFeedVisits As DataFeed = service.Query(query1)

For Each entry As DataEntry In dataFeedVisits.Entries

Dim st As String = entry.Title.Text
Dim ss As String = entry.Metrics(0).Value
visits = ss
Next

google...@googlecode.com

unread,
May 28, 2015, 12:26:59 AM 5/28/15
to gdata-dotnet-...@googlegroups.com

Comment #33 on issue 716 by it-produ...@cantaloupesys.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

I posted detailed steps with the screenshots on Stackoverflow to lay out
the solution that worked for me.

http://stackoverflow.com/a/30497154/732945

Ashish Sharma

unread,
May 28, 2015, 5:17:21 AM 5/28/15
to gdata-dotnet-...@googlegroups.com, google...@googlecode.com, codesite...@google.com
Hi,


I am getting the same error.. can any one help me...


Error LINE in DataFeedExample function is  :     feed = asv.Query(query);


public class DataFeedExample
{

    private const String CLIENT_USERNAME = " x...@gmail.com ";
    private const String CLIENT_PASS = "xxxxxxxx";
    private const String TABLE_ID = "ga:xxxxx";

    public DataFeed feed;
    public DataFeed feed2;

    public static void Main(String[] args)
    {
        DataFeedExample example;

        try
        {
            example = new DataFeedExample();
        }
        catch (AuthenticationException e)
        {
            Console.Error.WriteLine("Authentication failed : " + e.Message);
            return;
        }
        catch (Google.GData.Client.GDataRequestException e)
        {
            Console.Error.WriteLine("Authentication failed : " + e.Message);
            return;
        }

        //example.printFeedData();
        //example.printFeedDataSources();
        //example.printFeedAggregates();
        //example.printSegmentInfo();
        //example.printDataForOneEntry();

        //Console.WriteLine(example.getEntriesAsTable());
    }

    /**
     * Creates a new service object, attempts to authorize using the Client Login
     * authorization mechanism and requests data from the Google Analytics API.
     */
    public DataFeedExample()
    {
        // Configure GA API.
        AnalyticsService asv = new AnalyticsService("gaExportAPI_acctSample_v2.4");

        // Client Login Authorization.
        asv.setUserCredentials(CLIENT_USERNAME, CLIENT_PASS);

        // GA Data Feed query uri.
        String baseUrl = " https://www.googleapis.com/analytics/v2.4/data ";
        var dateAsString = DateTime.Now.ToString("yyyy-MM-dd");
        DataQuery query = new DataQuery(baseUrl);
        query.Ids = TABLE_ID;
       // query.Dimensions = "ga:source,ga:medium";
        query.Metrics = "ga:sessions";
        //query.Segment = "gaid::-11";
      //  query.Filters = "ga:medium==referral";
       // query.Sort = "-ga:visits";
     //   query.NumberToRetrieve = 5;
        query.GAStartDate = "2015-03-16";
        query.GAEndDate = dateAsString;
        Uri url = query.Uri;
        Console.WriteLine("URL: " + url.ToString());


        // Send our request to the Analytics API and wait for the results to
        // come back.

        feed = asv.Query(query);


    }

    /**
     * Prints the important Google Analytics relates data in the Data Feed.
     */
    public void printFeedData()
    {
        Console.WriteLine("\n-------- Important Feed Information --------");
        Console.WriteLine(
          "\nFeed Title      = " + feed.Title.Text +
          "\nFeed ID         = " + feed.Id.Uri +
          "\nTotal Results   = " + feed.TotalResults +
          "\nSart Index      = " + feed.StartIndex +
          "\nItems Per Page  = " + feed.ItemsPerPage
          );
    }

    /**
     * Prints the important information about the data sources in the feed.
     * Note: the GA Export API currently has exactly one data source.
     */
    public void printFeedDataSources()
    {

        DataSource gaDataSource = feed.DataSource;
        Console.WriteLine("\n-------- Data Source Information --------");
        Console.WriteLine(
          "\nTable Name      = " + gaDataSource.TableName +
          "\nTable ID        = " + gaDataSource.TableId +
          "\nWeb Property Id = " + gaDataSource.WebPropertyId +
          "\nProfile Id      = " + gaDataSource.ProfileId +
          "\nAccount Name    = " + gaDataSource.AccountName);
    }

    /**
     * Prints all the metric names and values of the aggregate data. The
     * aggregate metrics represent the sum of the requested metrics across all
     * of the entries selected by the query and not just the rows returned.
     */
    public string printFeedAggregates()
    {
        string val = "";
        Aggregates aggregates = feed.Aggregates;

        foreach (Metric metric in aggregates.Metrics)
        {
            Console.WriteLine(
              "\nMetric Name  = " + metric.Name +
              "\nMetric Value = " + metric.Value +
              "\nMetric Type  = " + metric.Type +
              "\nMetric CI    = " + metric.ConfidenceInterval);
            val = metric.Value;
        }
        return val;
    }

    /**
     * Prints segment information if the query has an advanced segment defined.
     */
    public void printSegmentInfo()
    {
        if (feed.Segments.Count > 0)
        {
            Console.WriteLine("\n-------- Advanced Segments Information --------");
            foreach (Segment segment in feed.Segments)
            {
                Console.WriteLine(
                    "\nSegment Name       = " + segment.Name +
                    "\nSegment ID         = " + segment.Id +
                    "\nSegment Definition = " + segment.Definition.Value);
            }
        }
    }

    /**
     * Prints all the important information from the first entry in the
     * data feed.
     */
    public void printDataForOneEntry()
    {
        Console.WriteLine("\n-------- Important Entry Information --------\n");
        if (feed.Entries.Count == 0)
        {
            Console.WriteLine("No entries found");
        }
        else
        {
            DataEntry singleEntry = feed.Entries[0] as DataEntry;

            // Properties specific to all the entries returned in the feed.
            Console.WriteLine("Entry ID    = " + singleEntry.Id.Uri);
            Console.WriteLine("Entry Title = " + singleEntry.Title.Text);

            // Iterate through all the dimensions.
            foreach (Dimension dimension in singleEntry.Dimensions)
            {
                Console.WriteLine("Dimension Name  = " + dimension.Name);
                Console.WriteLine("Dimension Value = " + dimension.Value);
            }

            // Iterate through all the metrics.
            foreach (Metric metric in singleEntry.Metrics)
            {
                Console.WriteLine("Metric Name  = " + metric.Name);
                Console.WriteLine("Metric Value = " + metric.Value);
                Console.WriteLine("Metric Type  = " + metric.Type);
                Console.WriteLine("Metric CI    = " + metric.ConfidenceInterval);
            }
        }
    }

    /**
     * Get the data feed values in the feed as a string.
     * @return {String} This returns the contents of the feed.
     */
    public String getEntriesAsTable()
    {
        if (feed.Entries.Count == 0)
        {
            return "No entries found";
        }
        DataEntry singleEntry = feed.Entries[0] as DataEntry;

        StringBuilder feedDataLines = new StringBuilder("\n-------- All Entries In A Table --------\n");

        // Put all the dimension and metric names into an array.
        foreach (Dimension dimension in singleEntry.Dimensions)
        {
            String[] args = { dimension.Name, dimension.Value };
            feedDataLines.AppendLine(String.Format("\n{0} \t= {1}", args));
        }
        foreach (Metric metric in singleEntry.Metrics)
        {
            String[] args = { metric.Name, metric.Value };
            feedDataLines.AppendLine(String.Format("\n{0} \t= {1}", args));
        }

        feedDataLines.Append("\n");
        return feedDataLines.ToString();
    }
}











On Wednesday, 27 May 2015 02:09:24 UTC+5:30, google...@googlecode.com wrote:
Status: New
Owner: ----

New issue 716 by APUS...@gmail.com : Execution of authentication request  
What steps will reproduce the problem?
1. After the "GA_Service.Credentials = new GDataCredentials (strGAUserName,  
strGAPassword);"
2.var token = GA_Service.QueryAuthenticationToken();
3. GA_Service.SetAuthenticationToken(token);

What is the expected output? What do you see instead?

It was working fine, but now i get this error after 10 times of data pull.


What version of the product are you using? On what operating system?
Google.GData.Analytics V 2.2.0.0

Please provide any additional information below.

google...@googlecode.com

unread,
May 28, 2015, 5:42:16 AM 5/28/15
to gdata-dotnet-...@googlegroups.com

Comment #34 on issue 716 by sangeeth...@gmail.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

Please help me how to retrieve gmail contact details(Only Email ID) in
c#.net (windows service)

I created new project and got client ID, Client Secret code, generated
p12key but still not able to fetch records.. i created project with
service account type.

google...@googlecode.com

unread,
May 28, 2015, 8:06:00 AM 5/28/15
to gdata-dotnet-...@googlegroups.com

Comment #35 on issue 716 by evilstee...@gmail.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

@Alex - yeah, saw that - brilliant and thanks for doing that. I found a
solution that works for me. Not sure why Sangeeth and Fernando are still
having issues - just follow the steps outlined and that ought to fix it.

google...@googlecode.com

unread,
May 28, 2015, 8:31:11 AM 5/28/15
to gdata-dotnet-...@googlegroups.com

Comment #36 on issue 716 by sangeeth...@gmail.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

Please Fine my Code:
Am still getting error.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using ASPSnippets.GoogleAPI;
using System.Web.Script.Serialization;
using System.Data;
using Google.GData.Extensions.Apps;
using Google.GData.Client;
using Google.Contacts;

public partial class Default2 : System.Web.UI.Page
{
private static string clientId;
private static string clientSecret;
private static string domain;
private static string applicationName = "Test-OAuth2";
private static string redirectUri
= " http://localhost:51598/WebSite1/Default2.aspx ";
private static string scopes = " https://www.google.com/m8/feeds/ ";
protected void Page_Load(object sender, EventArgs e)
{
clientId
= " 51382749591-acdara9kbhlrvo529ivnhbigsvd0m0rb.apps.googleusercontent.com ";
clientSecret = "IZGxIUoGpGjBqYFqDpNabicv";
domain = "";
OAuth2Parameters parameters = new OAuth2Parameters()
{
ClientId = clientId,
ClientSecret = clientSecret,
RedirectUri = redirectUri,
Scope = scopes
};

string url = OAuthUtil.CreateOAuth2AuthorizationUrl(parameters);
Console.WriteLine("Authorize URI: " + url);
parameters.AccessCode = Console.ReadLine();
parameters.AccessCode = "Authorize URI: " + url;

OAuthUtil.GetAccessToken(parameters);

// Testing OAuth 2.0 with a Request-based library
RunContactsSample(parameters);


}
private static void RunContactsSample(OAuth2Parameters parameters)
{
try
{
RequestSettings settings = new RequestSettings(applicationName,
parameters);
ContactsRequest cr = new ContactsRequest(settings);

Feed<Contact> f = cr.GetContacts();
foreach (Contact c in f.Entries)
{
Console.WriteLine(c.Name.FullName);
}
}
catch (Exception a)
{
Console.WriteLine("A Google Apps error occurred.");
Console.WriteLine();

google...@googlecode.com

unread,
May 28, 2015, 8:33:12 AM 5/28/15
to gdata-dotnet-...@googlegroups.com

Comment #37 on issue 716 by sangeeth...@gmail.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

Please Find my code
Am still getting error.
Help me plz


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using ASPSnippets.GoogleAPI;
using System.Web.Script.Serialization;
using System.Data;
using Google.GData.Extensions.Apps;
using Google.GData.Client;
using Google.Contacts;

public partial class Default2 : System.Web.UI.Page
{
private static string clientId;
private static string clientSecret;
private static string domain;
private static string applicationName = "Test-OAuth2";
private static string redirectUri
= " http://localhost:51598/WebSite1/Default2.aspx ";
private static string scopes = " https://www.google.com/m8/feeds/ ";
protected void Page_Load(object sender, EventArgs e)
{
clientId = "clientid";
clientSecret = "secret code";

google...@googlecode.com

unread,
May 29, 2015, 12:15:22 AM 5/29/15
to gdata-dotnet-...@googlegroups.com

Comment #38 on issue 716 by w3jgvo...@gmail.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

Hi, evilstee... your solution looks pretty good, well commented, etc. We
have the user visiting a URL manually (outside our application, via web
browser) and pasting in the "authorization code" that he receives from
Google OAuth. I am wondering if that can be automated? In my case, I know
the user's Google login and password because... the user is me! It's a
personal app just for me. I would like to automate that exchange and skip
the manual copy-and-paste of the authorization code. Any ideas?

google...@googlecode.com

unread,
May 29, 2015, 1:00:00 AM 5/29/15
to gdata-dotnet-...@googlegroups.com

Comment #39 on issue 716 by alex....@cantaloupesys.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

w3jgvo - you need to use Service Account to automate it. Check #33, this
does not require manual copy-paste.

google...@googlecode.com

unread,
May 29, 2015, 7:24:37 AM 5/29/15
to gdata-dotnet-...@googlegroups.com

Comment #40 on issue 716 by carlosma...@gmail.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

#33 it's with service account, not for Blogger API. Any ideas?

google...@googlecode.com

unread,
May 29, 2015, 10:31:08 AM 5/29/15
to gdata-dotnet-...@googlegroups.com

Comment #41 on issue 716 by amitkana...@gmail.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

authentication to google was working fine but now it throwing error: An
unhandled exception of type 'Google.GData.Client.GDataRequestException'
occurred in Google.GData.Client.dll

Additional information: Execution of authentication request returned
unexpected result: 404
please solve it as soon as possible

google...@googlecode.com

unread,
May 30, 2015, 2:00:19 PM 5/30/15
to gdata-dotnet-...@googlegroups.com

Comment #42 on issue 716 by fernando...@gmail.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

Thanks Alex. Yeah, #33 it's the solution.

google...@googlecode.com

unread,
Jun 1, 2015, 10:02:01 AM 6/1/15
to gdata-dotnet-...@googlegroups.com

Comment #43 on issue 716 by anton.sm...@friendsurance.de : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716


I implement the solution from #33 in Script task in SSIS, but ny execute i
receive message "Could not load file or
assembly 'Google.Apis.Auth.PlatformServices, Version=1.9.1.12399,
Culture=neutral, PublicKeyToken=null' or one of its dependencies. The
system cannot find the file specified."

i think it because the reference Google.Apis.Auth.PlatformServices from
Nuget has not strong name and cannot install to GAC.

Please help me, what need I do?

google...@googlecode.com

unread,
Jun 2, 2015, 7:21:19 AM 6/2/15
to gdata-dotnet-...@googlegroups.com

Comment #44 on issue 716 by johncus...@arantico.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716


Thanks #31 for the solution provided. This works fine for me for accessing
docs/spreadsheets.
However, I am getting the following error when I try to upload a document
to the google drive:
"When performing a write operation with AllowWriteStreamBuffering set to
false, you must either set ContentLength to a non-negative number or set
SendChunked to true."

My code for uploading documents is:

GOAuth2RequestFactory requestFactory = RefreshAuthenticate();
DocumentsService service = new
DocumentsService("MyDocumentsListIntegration-v1"); service.RequestFactory =
requestFactory;
DocumentEntry entry =
service.UploadDocument("C:\TempGoogleDocFolder\Test.docx", "Test");

The RefreshAuthenticate() function is coded as described above in #31.


Any ideas what is causing this or how it can be resolved?

google...@googlecode.com

unread,
Jun 5, 2015, 12:58:31 AM 6/5/15
to gdata-dotnet-...@googlegroups.com

Comment #45 on issue 716 by amitgson...@gmail.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

protected void Page_Load(object sender, EventArgs e)
{

if (Session["Access_Token"] != null)
{
//For Google Contacts in case of page reload or 'Import from
Gmail button' reclicked

//Same button's click event has been fired using Javascript
ScriptManager.RegisterStartupScript(this,
this.GetType(), "googleContactclick", "<script>GoogleContacts();;</Script>",
false);

//In GoogleContacts() javascript I've fired button's click
event.
}

else if (Request.QueryString["code"] != null)
{
//For Google Contacts while returning from Google SignIN page
OAuth2Parameters parameters = new OAuth2Parameters();
parameters.ClientId = "";
parameters.ClientSecret = "";
parameters.RedirectUri
= " http://localhost:56943/WebSite4/page3.aspx ";
//parameters.Scope = " https://www.google.com/m8/feeds ";
parameters.Scope
= " https://www.googleapis.com/auth/contacts.readonly ";
parameters.ResponseType = "code";
parameters.AccessCode = Request.QueryString["code"];
string accecode = parameters.AccessCode;
OAuthUtil.GetAccessToken(parameters);

Session["Access_Token"] = parameters.AccessToken;
string aaa = parameters.AccessToken;
//Response.Redirect("~/YourCurrentPage.aspx");
RequestSettings rs = new RequestSettings("MyApplicationName",
Session["Access_Token"].ToString());
rs.AutoPaging = true;
ContactsRequest cr = new ContactsRequest(rs);

//Function that retrieves all my google contacts and binds to
the grid.
BindGoogleGrid(cr);
}
}
public void BindGoogleGrid(ContactsRequest cr)
{

string Fullname = "";
string EmailID = "";
string FirstName = "";
string LastName = "";

try
{
Feed<Contact> f = cr.GetContacts();

DataSet dtImportedContacts = new DataSet();

DataTable dtName = new DataTable();


//dtName.Columns.Add("Name");
dtName.Columns.Add("FirstName");
dtName.Columns.Add("LastName");
dtName.Columns.Add("EmailID");

foreach (Contact entry in f.Entries)
{

//EMail email = entry.Emails[0];
if (entry.Emails.Count > 0)
{
//for fetching EmailID
foreach (EMail email in entry.Emails)
{
if (email != null)
{
EmailID = entry.Emails[0].Address;
if (EmailID == string.Empty)
EmailID = "";
}
else
{
EmailID = "";
}
}

//For fetching Contact Name
if (entry.Name != null)
{
Name name = entry.Name;

if (!string.IsNullOrEmpty(name.FullName))
{
Fullname = name.FullName;
var Name = name.FullName.Split(' ');

if (Name.Length >= 2)
{
FirstName = Name[0];
LastName = Name[1];
}

else
{
FirstName = Name[0];
LastName = "";
}

}

else
{
FirstName = "";
LastName = "";
}

}

else
{
FirstName = "";
LastName = "";
}

dtName.Rows.Add(FirstName, LastName, EmailID);
}
}


dtImportedContacts.Tables.Add(dtName);

if (dtImportedContacts.Tables[0].Rows.Count < 0)
{

//lbl.Text = "No Contacts Found";

}

else
{
// ImgBtnGImportAdd.Visible = true;

GridView1.DataSource = dtImportedContacts;
GridView1.DataBind();


}

}

catch (Exception ex)
{
// lbl.Text = ex.Message;
}
}



protected void Button1_Click(object sender, EventArgs e)
{
if (Session["Access_Token"] != null)
{
RequestSettings rs = new RequestSettings("MyApplicationName",
Session["Access_Token"].ToString());
rs.AutoPaging = true;
ContactsRequest cr = new ContactsRequest(rs);

//Function that retrieves all my google contacts and binds to
the grid.
BindGoogleGrid(cr);
}

else //no auth data, print link
{

OAuth2Parameters parameters = new OAuth2Parameters();

parameters.ClientId = "";
parameters.ClientSecret = "";
parameters.RedirectUri
= " http://localhost:56943/WebSite4/page3.aspx ";
parameters.Scope = " https://www.google.com/m8/feeds ";
parameters.ResponseType = "code";


Response.Redirect(OAuthUtil.CreateOAuth2AuthorizationUrl(parameters));

}
}



This code is working well with webApplication(Aap.Net)
Please help me how to make this code run with dekstop Application(Windows
Form)..
Its urgent for me my working system got stopped

google...@googlecode.com

unread,
Jun 5, 2015, 2:53:15 AM 6/5/15
to gdata-dotnet-...@googlegroups.com

Comment #46 on issue 716 by Spartan1...@gmail.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

#43 It can't find the new dlls. I resolved this by copying them to the Binn
folder of the DTS execution program (default: C:\Program Files
(x86)\Microsoft SQL Server\120\DTS\Binn\). I believe by registering them in
the GAC this problem would also be resolved.

google...@googlecode.com

unread,
Jun 5, 2015, 9:52:46 AM 6/5/15
to gdata-dotnet-...@googlegroups.com

Comment #47 on issue 716 by Carlos.R...@celoxica.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

#33 - Does anybody know how to get this working with the SpreadsheetService
from the python gdata libraries?

I've got this far:

flow = OAuth2WebServerFlow(CLIENT_ID, CLIENT_SECRET, OAUTH_SCOPE,
redirect_uri=REDIRECT_URI)
authorize_url = flow.step1_get_authorize_url()
code = raw_input('Enter verification code: ').strip()
credentials = flow.step2_exchange(code)

But I can't see how to use the credentials with SpreadsheetService. The
examples in the docs show how to use the credentials with the Drive API,
like this:

# Create an httplib2.Http object and authorize it with our credentials
http = httplib2.Http()
http = credentials.authorize(http)

drive_service = build('drive', 'v2', http=http)

But again SpreadsheetService doesn't seem to have a way to set the
authorized http object.

Any clues much appreciated.

google...@googlecode.com

unread,
Jul 2, 2015, 5:49:52 AM 7/2/15
to gdata-dotnet-...@googlegroups.com

Comment #48 on issue 716 by varsha.a...@umail.uom.ac.mu : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

i need to save user accounts on google api. I need a .net code to do the
authorization first then need to code to do the saving part.

google...@googlecode.com

unread,
Jul 8, 2015, 4:21:28 AM 7/8/15
to gdata-dotnet-...@googlegroups.com

Comment #49 on issue 716 by dujunsheng: Execution of authentication request
returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

Google is changing as the old Microsoft! Only I can do is give up.

google...@googlecode.com

unread,
Jul 22, 2015, 8:51:48 AM 7/22/15
to gdata-dotnet-...@googlegroups.com

Comment #50 on issue 716 by sangeeth...@gmail.com : Execution of
authentication request returned unexpected result: 404
https://code.google.com/p/google-gdata/issues/detail?id=716

please help me how to read google document from google drive ...
am getting this error
Execution of request failed:
https://docs.google.com/feeds/default/private/full

below mentioned is my code :
OAuth2Parameters parameters = new OAuth2Parameters();
parameters.ClientId = CLIENT_ID;
parameters.ClientSecret = CLIENT_SECRET;
parameters.RedirectUri = REDIRECT_URI;
parameters.Scope = SCOPE;
parameters.AccessType = "offline"; // IMPORTANT and was missing in the
original
parameters.TokenType = TOKEN_TYPE; // IMPORTANT and was missing in the
original
parameters.ResponseType = "code";
//string authorizationUrl =
OAuthUtil.CreateOAuth2AuthorizationUrl(parameters);
//Console.WriteLine(authorizationUrl);
parameters.AccessCode = Request.QueryString["code"];
string accecode = parameters.AccessCode;
if (accecode == null)
{
Button1_Click(null, null);
}
//parameters.AccessCode = Console.ReadLine();
OAuthUtil.GetAccessToken(parameters);
accessToken = parameters.AccessToken;
refreshToken = parameters.RefreshToken;
GOAuth2RequestFactory requestFactory = RefreshAuthenticate();

Google.GData.Documents.DocumentsListQuery query = new
Google.GData.Documents.DocumentsListQuery();

Google.GData.Documents.DocumentsFeed feed = d_service.Query(query);
var docs = new List<string>();
foreach (DocumentEntry entry in feed.Entries)
{
docs.Add(entry.Title.Text);
Reply all
Reply to author
Forward
0 new messages