Analytics V3 using C# .NET - No response returned when calling Exceute() on ListRequest

395 views
Skip to first unread message

nick.m...@northyorks.gov.uk

unread,
Oct 8, 2015, 6:30:38 AM10/8/15
to Google Analytics Management API
Hi All,

We recently moved to V3 of the Analytics APIs.  Originally we had an SSIS package using signed .NET DLLs in the GAC to access the older versions.  However, since the move to V3 we've not been able to install our custom DLLs referencing the Analytics APIs in the GAC as they are not signed.

So I've gone down the route of creating a Web Service wrapper to access our custom code that uses Analytics V3.  Now when I run our Unit Tests using Visual Studio everything works perfectly and I get data back no problem.  Here are some details:
  • Accessing our Analytics account using a Service Account.  Service account has been created and relevant access provided to the Analytics account
  • P12 certificate installed in the Windows Certificate Store under local machine
  • No issues when getting and using this certificate with the ServiceAccountCredential object in C#
  • Am specifying our Proxy and have confirmed that this is working without any issues (as I mentioned, works fine in our Unit Tests)
  • Created a Web Service wrapper to call the library and when I send a GET request to my wrapper to fire off the Analytics library it creates the AnalyticsService object without any problems but then goes to call:
    • Google.Apis.Analytics.v3.ManagementResource.ProfilesResource.ListRequest request = analyticsService.Management.Profiles.List("~all""~all");
      Google.Apis.Analytics.v3.Data.Profiles profiles = request.Execute();
  • and hangs on the second line.  I get no errors at all, just hangs.  I've used wireshark to track the communications but we just appear to be waiting for something back from Google that never comes
So as I mentioned, when I access the Class Library from a Unit test, all works fine but when I access the same Class Library from my Web Service wrapper and send a GET request to kick it all off, it just hangs on that
second line.

So my questions are:  Anyone have any idea what the issue might be with the above!???  Also has anyone created a valid solution in SSIS to access your Analytics account that allows you to specify a Web Proxy??

Chris Harrington

unread,
Oct 15, 2015, 1:49:40 AM10/15/15
to Google Analytics Management API
Do you have a unit test that hits the web service wrapper on the same server where it fails?
Alternatively, why not just sign the DLL?

Chris Harrington

unread,
Oct 15, 2015, 1:53:18 AM10/15/15
to Google Analytics Management API
Sorry - just re-read and see that it is failing when you invoke your web service. How are you invoking your web service?


On Thursday, October 8, 2015 at 6:30:38 AM UTC-4, nick.m...@northyorks.gov.uk wrote:

Eddie Yanez

unread,
Nov 12, 2015, 5:26:26 AM11/12/15
to google-analytics-management-api
Hi there, did you find a solution to this problem?

Eddie

Nick Mattocks

unread,
Nov 12, 2015, 5:31:55 AM11/12/15
to google-analytic...@googlegroups.com

Hi there,

 

No sadly I didn’t find a solution and my current workload has restricted my options.  In the end what I had to do was create a Console Application which had my Google Analytics functionality in and then fire that off from my SSIS package.  I wrote a GUID and a status to a DB table before firing off the Console App from SSIS (as it runs under a separate process) and then check the DB for a status update to that GUID and only when it reports complete do I move forward.  Total hack but it works!

 

From: google-analytic...@googlegroups.com [mailto:google-analytic...@googlegroups.com] On Behalf Of Eddie Yanez
Sent: 12 November 2015 10:26
To: google-analytics-management-api
Subject: [GA-MGMT-API] Re: Analytics V3 using C# .NET - No response returned when calling Exceute() on ListRequest

 

Hi there, did you find a solution to this problem?

 

Eddie

On Thursday, 8 October 2015 11:30:38 UTC+1, nick.m...@northyorks.gov.uk wrote:

Hi All,

 

We recently moved to V3 of the Analytics APIs.  Originally we had an SSIS package using signed .NET DLLs in the GAC to access the older versions.  However, since the move to V3 we've not been able to install our custom DLLs referencing the Analytics APIs in the GAC as they are not signed.

 

So I've gone down the route of creating a Web Service wrapper to access our custom code that uses Analytics V3.  Now when I run our Unit Tests using Visual Studio everything works perfectly and I get data back no problem.  Here are some details:

  • Accessing our Analytics account using a Service Account.  Service account has been created and relevant access provided to the Analytics account
  • P12 certificate installed in the Windows Certificate Store under local machine
  • No issues when getting and using this certificate with the ServiceAccountCredential object in C#
  • Am specifying our Proxy and have confirmed that this is working without any issues (as I mentioned, works fine in our Unit Tests)
  • Created a Web Service wrapper to call the library and when I send a GET request to my wrapper to fire off the Analytics library it creates the AnalyticsService object without any problems but then goes to call:
o   Google.Apis.Analytics.v3.ManagementResource.ProfilesResource.ListRequest request = analyticsService.Management.Profiles.List("~all""~all");
o   Google.Apis.Analytics.v3.Data.Profiles profiles = request.Execute();
·        and hangs on the second line.  I get no errors at all, just hangs.  I've used wireshark to track the communications but we just appear to be waiting for something back from Google that never comes

So as I mentioned, when I access the Class Library from a Unit test, all works fine but when I access the same Class Library from my Web Service wrapper and send a GET request to kick it all off, it just hangs on that

second line.

 

So my questions are:  Anyone have any idea what the issue might be with the above!???  Also has anyone created a valid solution in SSIS to access your Analytics account that allows you to specify a Web Proxy??

--
You received this message because you are subscribed to the Google Groups "google-analytics-management-api" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-mana...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Access your county council services online 24 hours a day, 7 days a week at www.northyorks.gov.uk.

WARNING


Any opinions or statements expressed in this e-mail are those of the individual and not necessarily those of North Yorkshire County Council.


This e-mail and any files transmitted with it are confidential and solely for the use of the intended recipient. If you receive this in error, please do not disclose any information to anyone, notify the sender at the above address and then destroy all copies.


North Yorkshire County Council's computer systems and communications may be monitored to ensure effective operation of the system and for other lawful purposes. All GCSX traffic may be subject to recording and/or monitoring in accordance with relevant legislation.


Although we have endeavoured to ensure that this e-mail and any attachments are free from any virus we would advise you to take any necessary steps to ensure that they are actually virus free.


If you receive an automatic response stating that the recipient is away from the office and you wish to request information under either the Freedom of Information Act, the Data Protection Act or the Environmental Information Regulations please forward your request by e-mail to the Information Governance Team (inf...@northyorks.gov.uk) who will process your request.

North Yorkshire County Council.

Eddie Yanez

unread,
Nov 12, 2015, 5:39:46 AM11/12/15
to google-analytics-management-api
Ah fair enough. This is very annoying as it literally just started happening and there's nothing in Google Dev Console in terms of error log that you can check, and the service simply just hangs... And there are no obvious changes in the solution either to explain what's going on. It just stopped working.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-management-api+unsubscribe@googlegroups.com.


For more options, visit https://groups.google.com/d/optout.

Nick Mattocks

unread,
Nov 12, 2015, 5:51:44 AM11/12/15
to google-analytic...@googlegroups.com

Yeah sorry I couldn’t be more help.  It was extremely infuriating.  I had thought that it must be an issue with our network as I could run my unit tests on it without any issues but then as soon as it’s piped through a web browser it just hangs when requesting back profiles.

 

If I’d have had enough time I was going to check it on a machine outside of our network but I didn’t get round to doing that.

 

Good luck anyway!

 

From: google-analytic...@googlegroups.com [mailto:google-analytic...@googlegroups.com] On Behalf Of Eddie Yanez
Sent: 12 November 2015 10:40
To: google-analytics-management-api
Subject: Re: [GA-MGMT-API] Re: Analytics V3 using C# .NET - No response returned when calling Exceute() on ListRequest

 

Ah fair enough. This is very annoying as it literally just started happening and there's nothing in Google Dev Console in terms of error log that you can check, and the service simply just hangs... And there are no obvious changes in the solution either to explain what's going on. It just stopped working.

 



On Thursday, 12 November 2015 10:31:55 UTC, Nick Mattocks wrote:

Hi there,

 

No sadly I didn’t find a solution and my current workload has restricted my options.  In the end what I had to do was create a Console Application which had my Google Analytics functionality in and then fire that off from my SSIS package.  I wrote a GUID and a status to a DB table before firing off the Console App from SSIS (as it runs under a separate process) and then check the DB for a status update to that GUID and only when it reports complete do I move forward.  Total hack but it works!

 

From: google-analytic...@googlegroups.com [mailto:google-analytic...@googlegroups.com] On Behalf Of Eddie Yanez
Sent: 12 November 2015 10:26
To: google-analytics-management-api
Subject: [GA-MGMT-API] Re: Analytics V3 using C# .NET - No response returned when calling Exceute() on ListRequest

 

Hi there, did you find a solution to this problem?

 

Eddie

On Thursday, 8 October 2015 11:30:38 UTC+1, nick.m...@northyorks.gov.uk wrote:

Hi All,

 

We recently moved to V3 of the Analytics APIs.  Originally we had an SSIS package using signed .NET DLLs in the GAC to access the older versions.  However, since the move to V3 we've not been able to install our custom DLLs referencing the Analytics APIs in the GAC as they are not signed.

 

So I've gone down the route of creating a Web Service wrapper to access our custom code that uses Analytics V3.  Now when I run our Unit Tests using Visual Studio everything works perfectly and I get data back no problem.  Here are some details:

  • Accessing our Analytics account using a Service Account.  Service account has been created and relevant access provided to the Analytics account
  • P12 certificate installed in the Windows Certificate Store under local machine
  • No issues when getting and using this certificate with the ServiceAccountCredential object in C#
  • Am specifying our Proxy and have confirmed that this is working without any issues (as I mentioned, works fine in our Unit Tests)
  • Created a Web Service wrapper to call the library and when I send a GET request to my wrapper to fire off the Analytics library it creates the AnalyticsService object without any problems but then goes to call:
o   Google.Apis.Analytics.v3.ManagementResource.ProfilesResource.ListRequest request = analyticsService.Management.Profiles.List("~all""~all");
o   Google.Apis.Analytics.v3.Data.Profiles profiles = request.Execute();
·        and hangs on the second line.  I get no errors at all, just hangs.  I've used wireshark to track the communications but we just appear to be waiting for something back from Google that never comes

So as I mentioned, when I access the Class Library from a Unit test, all works fine but when I access the same Class Library from my Web Service wrapper and send a GET request to kick it all off, it just hangs on that

second line.

 

So my questions are:  Anyone have any idea what the issue might be with the above!???  Also has anyone created a valid solution in SSIS to access your Analytics account that allows you to specify a Web Proxy??

--
You received this message because you are subscribed to the Google Groups "google-analytics-management-api" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-mana...@googlegroups.com.


For more options, visit https://groups.google.com/d/optout.


Access your county council services online 24 hours a day, 7 days a week at www.northyorks.gov.uk.

WARNING

 

Any opinions or statements expressed in this e-mail are those of the individual and not necessarily those of North Yorkshire County Council.

 

This e-mail and any files transmitted with it are confidential and solely for the use of the intended recipient. If you receive this in error, please do not disclose any information to anyone, notify the sender at the above address and then destroy all copies.

 

North Yorkshire County Council's computer systems and communications may be monitored to ensure effective operation of the system and for other lawful purposes. All GCSX traffic may be subject to recording and/or monitoring in accordance with relevant legislation.

 

Although we have endeavoured to ensure that this e-mail and any attachments are free from any virus we would advise you to take any necessary steps to ensure that they are actually virus free.

 

If you receive an automatic response stating that the recipient is away from the office and you wish to request information under either the Freedom of Information Act, the Data Protection Act or the Environmental Information Regulations please forward your request by e-mail to the Information Governance Team (inf...@northyorks.gov.uk) who will process your request.

North Yorkshire County Council.

--

You received this message because you are subscribed to the Google Groups "google-analytics-management-api" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-mana...@googlegroups.com.


For more options, visit https://groups.google.com/d/optout.

Eddie Yanez

unread,
Nov 12, 2015, 8:31:47 AM11/12/15
to google-analytics-management-api
Infuriating. That's one word. So far I have re-generated the certificate, checked for network issues (also fails outside the network), checked nugget package versions, and nothing. Did you say a console app worked? I don't suppose I could get the console app to return data? Although to be fair, having to use a console app would be much.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-management-api+unsubscribe@googlegroups.com.


For more options, visit https://groups.google.com/d/optout.


Access your county council services online 24 hours a day, 7 days a week at www.northyorks.gov.uk.

WARNING

 

Any opinions or statements expressed in this e-mail are those of the individual and not necessarily those of North Yorkshire County Council.

 

This e-mail and any files transmitted with it are confidential and solely for the use of the intended recipient. If you receive this in error, please do not disclose any information to anyone, notify the sender at the above address and then destroy all copies.

 

North Yorkshire County Council's computer systems and communications may be monitored to ensure effective operation of the system and for other lawful purposes. All GCSX traffic may be subject to recording and/or monitoring in accordance with relevant legislation.

 

Although we have endeavoured to ensure that this e-mail and any attachments are free from any virus we would advise you to take any necessary steps to ensure that they are actually virus free.

 

If you receive an automatic response stating that the recipient is away from the office and you wish to request information under either the Freedom of Information Act, the Data Protection Act or the Environmental Information Regulations please forward your request by e-mail to the Information Governance Team (inf...@northyorks.gov.uk) who will process your request.

North Yorkshire County Council.

--
You received this message because you are subscribed to the Google Groups "google-analytics-management-api" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-management-api+unsubscribe@googlegroups.com.


For more options, visit https://groups.google.com/d/optout.

Nick Mattocks

unread,
Nov 12, 2015, 8:49:11 AM11/12/15
to google-analytic...@googlegroups.com

Ah yeah the console app wouldn’t be able to return you data directly but you could have it write to a DB or output files somewhere that you can pick up.  It did work though.  I have it take one argument which is a GUID then have it get all the dimensions and metrics that I need based on dates listed in a DB table.  Then write the output to our data warehouse and update a log table with the supplied GUID in stating that the process finished and whether or not it was successful.

 

I had problem after problem with this new version of the APIs. 

 

From: google-analytic...@googlegroups.com [mailto:google-analytic...@googlegroups.com] On Behalf Of Eddie Yanez
Sent: 12 November 2015 13:32
To: google-analytics-management-api
Subject: Re: [GA-MGMT-API] Re: Analytics V3 using C# .NET - No response returned when calling Exceute() on ListRequest

 

Infuriating. That's one word. So far I have re-generated the certificate, checked for network issues (also fails outside the network), checked nugget package versions, and nothing. Did you say a console app worked? I don't suppose I could get the console app to return data? Although to be fair, having to use a console app would be much.

 


On Thursday, 12 November 2015 10:51:44 UTC, Nick Mattocks wrote:

Yeah sorry I couldn’t be more help.  It was extremely infuriating.  I had thought that it must be an issue with our network as I could run my unit tests on it without any issues but then as soon as it’s piped through a web browser it just hangs when requesting back profiles.

 

If I’d have had enough time I was going to check it on a machine outside of our network but I didn’t get round to doing that.

 

Good luck anyway!

 

From: google-analytic...@googlegroups.com [mailto:google-analytic...@googlegroups.com] On Behalf Of Eddie Yanez
Sent: 12 November 2015 10:40
To: google-analytics-management-api
Subject: Re: [GA-MGMT-API] Re: Analytics V3 using C# .NET - No response returned when calling Exceute() on ListRequest

 

Ah fair enough. This is very annoying as it literally just started happening and there's nothing in Google Dev Console in terms of error log that you can check, and the service simply just hangs... And there are no obvious changes in the solution either to explain what's going on. It just stopped working.

 



On Thursday, 12 November 2015 10:31:55 UTC, Nick Mattocks wrote:

Hi there,

 

No sadly I didn’t find a solution and my current workload has restricted my options.  In the end what I had to do was create a Console Application which had my Google Analytics functionality in and then fire that off from my SSIS package.  I wrote a GUID and a status to a DB table before firing off the Console App from SSIS (as it runs under a separate process) and then check the DB for a status update to that GUID and only when it reports complete do I move forward.  Total hack but it works!

 

From: google-analytic...@googlegroups.com [mailto:google-analytic...@googlegroups.com] On Behalf Of Eddie Yanez
Sent: 12 November 2015 10:26
To: google-analytics-management-api
Subject: [GA-MGMT-API] Re: Analytics V3 using C# .NET - No response returned when calling Exceute() on ListRequest

 

Hi there, did you find a solution to this problem?

 

Eddie

On Thursday, 8 October 2015 11:30:38 UTC+1, nick.m...@northyorks.gov.uk wrote:

Hi All,

 

We recently moved to V3 of the Analytics APIs.  Originally we had an SSIS package using signed .NET DLLs in the GAC to access the older versions.  However, since the move to V3 we've not been able to install our custom DLLs referencing the Analytics APIs in the GAC as they are not signed.

 

So I've gone down the route of creating a Web Service wrapper to access our custom code that uses Analytics V3.  Now when I run our Unit Tests using Visual Studio everything works perfectly and I get data back no problem.  Here are some details:

  • Accessing our Analytics account using a Service Account.  Service account has been created and relevant access provided to the Analytics account
  • P12 certificate installed in the Windows Certificate Store under local machine
  • No issues when getting and using this certificate with the ServiceAccountCredential object in C#
  • Am specifying our Proxy and have confirmed that this is working without any issues (as I mentioned, works fine in our Unit Tests)
  • Created a Web Service wrapper to call the library and when I send a GET request to my wrapper to fire off the Analytics library it creates the AnalyticsService object without any problems but then goes to call:
o   Google.Apis.Analytics.v3.ManagementResource.ProfilesResource.ListRequest request = analyticsService.Management.Profiles.List("~all""~all");
o   Google.Apis.Analytics.v3.Data.Profiles profiles = request.Execute();
·        and hangs on the second line.  I get no errors at all, just hangs.  I've used wireshark to track the communications but we just appear to be waiting for something back from Google that never comes

So as I mentioned, when I access the Class Library from a Unit test, all works fine but when I access the same Class Library from my Web Service wrapper and send a GET request to kick it all off, it just hangs on that

second line.

 

So my questions are:  Anyone have any idea what the issue might be with the above!???  Also has anyone created a valid solution in SSIS to access your Analytics account that allows you to specify a Web Proxy??

--
You received this message because you are subscribed to the Google Groups "google-analytics-management-api" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-mana...@googlegroups.com.


For more options, visit https://groups.google.com/d/optout.


Access your county council services online 24 hours a day, 7 days a week at www.northyorks.gov.uk.

WARNING

 

Any opinions or statements expressed in this e-mail are those of the individual and not necessarily those of North Yorkshire County Council.

 

This e-mail and any files transmitted with it are confidential and solely for the use of the intended recipient. If you receive this in error, please do not disclose any information to anyone, notify the sender at the above address and then destroy all copies.

 

North Yorkshire County Council's computer systems and communications may be monitored to ensure effective operation of the system and for other lawful purposes. All GCSX traffic may be subject to recording and/or monitoring in accordance with relevant legislation.

 

Although we have endeavoured to ensure that this e-mail and any attachments are free from any virus we would advise you to take any necessary steps to ensure that they are actually virus free.

 

If you receive an automatic response stating that the recipient is away from the office and you wish to request information under either the Freedom of Information Act, the Data Protection Act or the Environmental Information Regulations please forward your request by e-mail to the Information Governance Team (inf...@northyorks.gov.uk) who will process your request.

North Yorkshire County Council.

--
You received this message because you are subscribed to the Google Groups "google-analytics-management-api" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-mana...@googlegroups.com.


For more options, visit https://groups.google.com/d/optout.


Access your county council services online 24 hours a day, 7 days a week at www.northyorks.gov.uk.

WARNING

 

Any opinions or statements expressed in this e-mail are those of the individual and not necessarily those of North Yorkshire County Council.

 

This e-mail and any files transmitted with it are confidential and solely for the use of the intended recipient. If you receive this in error, please do not disclose any information to anyone, notify the sender at the above address and then destroy all copies.

 

North Yorkshire County Council's computer systems and communications may be monitored to ensure effective operation of the system and for other lawful purposes. All GCSX traffic may be subject to recording and/or monitoring in accordance with relevant legislation.

 

Although we have endeavoured to ensure that this e-mail and any attachments are free from any virus we would advise you to take any necessary steps to ensure that they are actually virus free.

 

If you receive an automatic response stating that the recipient is away from the office and you wish to request information under either the Freedom of Information Act, the Data Protection Act or the Environmental Information Regulations please forward your request by e-mail to the Information Governance Team (inf...@northyorks.gov.uk) who will process your request.

North Yorkshire County Council.

--
You received this message because you are subscribed to the Google Groups "google-analytics-management-api" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-mana...@googlegroups.com.


For more options, visit https://groups.google.com/d/optout.

Eddie Yanez

unread,
Nov 12, 2015, 9:18:59 AM11/12/15
to google-analytics-management-api
I'd rather not if I can avoid it, but I will give it a try. Strange that it would work on a console app but not a .net web app?

I posted a question on stack overflow as the developers seem to be answering questions there now


Fingers crossed. Meanwhile I've run out of ideas to make this work!

Thanks for your help btw

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-management-api+unsubscribe@googlegroups.com.


For more options, visit https://groups.google.com/d/optout.


Access your county council services online 24 hours a day, 7 days a week at www.northyorks.gov.uk.

WARNING

 

Any opinions or statements expressed in this e-mail are those of the individual and not necessarily those of North Yorkshire County Council.

 

This e-mail and any files transmitted with it are confidential and solely for the use of the intended recipient. If you receive this in error, please do not disclose any information to anyone, notify the sender at the above address and then destroy all copies.

 

North Yorkshire County Council's computer systems and communications may be monitored to ensure effective operation of the system and for other lawful purposes. All GCSX traffic may be subject to recording and/or monitoring in accordance with relevant legislation.

 

Although we have endeavoured to ensure that this e-mail and any attachments are free from any virus we would advise you to take any necessary steps to ensure that they are actually virus free.

 

If you receive an automatic response stating that the recipient is away from the office and you wish to request information under either the Freedom of Information Act, the Data Protection Act or the Environmental Information Regulations please forward your request by e-mail to the Information Governance Team (inf...@northyorks.gov.uk) who will process your request.

North Yorkshire County Council.

--
You received this message because you are subscribed to the Google Groups "google-analytics-management-api" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-management-api+unsubscribe@googlegroups.com.


For more options, visit https://groups.google.com/d/optout.


Access your county council services online 24 hours a day, 7 days a week at www.northyorks.gov.uk.

WARNING

 

Any opinions or statements expressed in this e-mail are those of the individual and not necessarily those of North Yorkshire County Council.

 

This e-mail and any files transmitted with it are confidential and solely for the use of the intended recipient. If you receive this in error, please do not disclose any information to anyone, notify the sender at the above address and then destroy all copies.

 

North Yorkshire County Council's computer systems and communications may be monitored to ensure effective operation of the system and for other lawful purposes. All GCSX traffic may be subject to recording and/or monitoring in accordance with relevant legislation.

 

Although we have endeavoured to ensure that this e-mail and any attachments are free from any virus we would advise you to take any necessary steps to ensure that they are actually virus free.

 

If you receive an automatic response stating that the recipient is away from the office and you wish to request information under either the Freedom of Information Act, the Data Protection Act or the Environmental Information Regulations please forward your request by e-mail to the Information Governance Team (inf...@northyorks.gov.uk) who will process your request.

North Yorkshire County Council.

--
You received this message because you are subscribed to the Google Groups "google-analytics-management-api" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-management-api+unsubscribe@googlegroups.com.


For more options, visit https://groups.google.com/d/optout.

Eddie Yanez

unread,
Nov 13, 2015, 5:09:13 AM11/13/15
to google-analytics-management-api
So it turns out this is related to updating these three libraries to versions 1.9.3 even though updating them is unnecessary: Google APIs Auth Client Library, Google APIs Client Library, and Google APIs Core Client Library. When you install one of the service packages (i.e. Google Analytics v3), these libraries will also be installed, but versions 1.9.2 will be installed. But if you open the NuGet package management window, these will be listed under Update.

To get the code to run without issues, edit the packages.config and change their versions to 1.9.2. And then open any web.config or app.config files and remove the dependentAssembly tags from any app.config AND web.config files as bindingRedirect will try and force to use 1.9.3. I would also suggest deleting any obj and bin folders.


I hope this helps!

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-management-api+unsubscribe@googlegroups.com.


For more options, visit https://groups.google.com/d/optout.


Access your county council services online 24 hours a day, 7 days a week at www.northyorks.gov.uk.

WARNING

 

Any opinions or statements expressed in this e-mail are those of the individual and not necessarily those of North Yorkshire County Council.

 

This e-mail and any files transmitted with it are confidential and solely for the use of the intended recipient. If you receive this in error, please do not disclose any information to anyone, notify the sender at the above address and then destroy all copies.

 

North Yorkshire County Council's computer systems and communications may be monitored to ensure effective operation of the system and for other lawful purposes. All GCSX traffic may be subject to recording and/or monitoring in accordance with relevant legislation.

 

Although we have endeavoured to ensure that this e-mail and any attachments are free from any virus we would advise you to take any necessary steps to ensure that they are actually virus free.

 

If you receive an automatic response stating that the recipient is away from the office and you wish to request information under either the Freedom of Information Act, the Data Protection Act or the Environmental Information Regulations please forward your request by e-mail to the Information Governance Team (inf...@northyorks.gov.uk) who will process your request.

North Yorkshire County Council.

--
You received this message because you are subscribed to the Google Groups "google-analytics-management-api" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-management-api+unsubscribe@googlegroups.com.


For more options, visit https://groups.google.com/d/optout.


Access your county council services online 24 hours a day, 7 days a week at www.northyorks.gov.uk.

WARNING

 

Any opinions or statements expressed in this e-mail are those of the individual and not necessarily those of North Yorkshire County Council.

 

This e-mail and any files transmitted with it are confidential and solely for the use of the intended recipient. If you receive this in error, please do not disclose any information to anyone, notify the sender at the above address and then destroy all copies.

 

North Yorkshire County Council's computer systems and communications may be monitored to ensure effective operation of the system and for other lawful purposes. All GCSX traffic may be subject to recording and/or monitoring in accordance with relevant legislation.

 

Although we have endeavoured to ensure that this e-mail and any attachments are free from any virus we would advise you to take any necessary steps to ensure that they are actually virus free.

 

If you receive an automatic response stating that the recipient is away from the office and you wish to request information under either the Freedom of Information Act, the Data Protection Act or the Environmental Information Regulations please forward your request by e-mail to the Information Governance Team (inf...@northyorks.gov.uk) who will process your request.

North Yorkshire County Council.

--
You received this message because you are subscribed to the Google Groups "google-analytics-management-api" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-management-api+unsubscribe@googlegroups.com.


For more options, visit https://groups.google.com/d/optout.

Nick Mattocks

unread,
Nov 13, 2015, 5:15:33 AM11/13/15
to google-analytic...@googlegroups.com

Wow thanks for the update!  Yet another issue for them to sort out!

 

I had a nightmare with the nuget packages in the first place.  I had issues with nuget installing versions of dependant packages that were the wrong version!!  Unfortunately I will not be given time to go back and sort this out at the moment but I’ll certainly save this email!

 

Thanks again for the update.

 

Nick

 

From: google-analytic...@googlegroups.com [mailto:google-analytic...@googlegroups.com] On Behalf Of Eddie Yanez
Sent: 13 November 2015 10:09
To: google-analytics-management-api
Subject: Re: [GA-MGMT-API] Re: Analytics V3 using C# .NET - No response returned when calling Exceute() on ListRequest

 

So it turns out this is related to updating these three libraries to versions 1.9.3 even though updating them is unnecessary: Google APIs Auth Client Library, Google APIs Client Library, and Google APIs Core Client Library. When you install one of the service packages (i.e. Google Analytics v3), these libraries will also be installed, but versions 1.9.2 will be installed. But if you open the NuGet package management window, these will be listed under Update.

 

To get the code to run without issues, edit the packages.config and change their versions to 1.9.2. And then open any web.config or app.config files and remove the dependentAssembly tags from any app.config AND web.config files as bindingRedirect will try and force to use 1.9.3. I would also suggest deleting any obj and bin folders.

 

 

I hope this helps!



On Thursday, 12 November 2015 13:49:11 UTC, Nick Mattocks wrote:

Ah yeah the console app wouldn’t be able to return you data directly but you could have it write to a DB or output files somewhere that you can pick up.  It did work though.  I have it take one argument which is a GUID then have it get all the dimensions and metrics that I need based on dates listed in a DB table.  Then write the output to our data warehouse and update a log table with the supplied GUID in stating that the process finished and whether or not it was successful.

 

I had problem after problem with this new version of the APIs. 

 

From: google-analytic...@googlegroups.com [mailto:google-analytic...@googlegroups.com] On Behalf Of Eddie Yanez
Sent: 12 November 2015 13:32
To: google-analytics-management-api
Subject: Re: [GA-MGMT-API] Re: Analytics V3 using C# .NET - No response returned when calling Exceute() on ListRequest

 

Infuriating. That's one word. So far I have re-generated the certificate, checked for network issues (also fails outside the network), checked nugget package versions, and nothing. Did you say a console app worked? I don't suppose I could get the console app to return data? Although to be fair, having to use a console app would be much.


On Thursday, 12 November 2015 10:51:44 UTC, Nick Mattocks wrote:

Yeah sorry I couldn’t be more help.  It was extremely infuriating.  I had thought that it must be an issue with our network as I could run my unit tests on it without any issues but then as soon as it’s piped through a web browser it just hangs when requesting back profiles.

 

If I’d have had enough time I was going to check it on a machine outside of our network but I didn’t get round to doing that.

 

Good luck anyway!

 

From: google-analytic...@googlegroups.com [mailto:google-analytic...@googlegroups.com] On Behalf Of Eddie Yanez
Sent: 12 November 2015 10:40
To: google-analytics-management-api
Subject: Re: [GA-MGMT-API] Re: Analytics V3 using C# .NET - No response returned when calling Exceute() on ListRequest

 

Ah fair enough. This is very annoying as it literally just started happening and there's nothing in Google Dev Console in terms of error log that you can check, and the service simply just hangs... And there are no obvious changes in the solution either to explain what's going on. It just stopped working.

 



On Thursday, 12 November 2015 10:31:55 UTC, Nick Mattocks wrote:

Hi there,

 

No sadly I didn’t find a solution and my current workload has restricted my options.  In the end what I had to do was create a Console Application which had my Google Analytics functionality in and then fire that off from my SSIS package.  I wrote a GUID and a status to a DB table before firing off the Console App from SSIS (as it runs under a separate process) and then check the DB for a status update to that GUID and only when it reports complete do I move forward.  Total hack but it works!

 

From: google-analytic...@googlegroups.com [mailto:google-analytic...@googlegroups.com] On Behalf Of Eddie Yanez
Sent: 12 November 2015 10:26
To: google-analytics-management-api
Subject: [GA-MGMT-API] Re: Analytics V3 using C# .NET - No response returned when calling Exceute() on ListRequest

 

Hi there, did you find a solution to this problem?

 

Eddie

On Thursday, 8 October 2015 11:30:38 UTC+1, nick.m...@northyorks.gov.uk wrote:

Hi All,

 

We recently moved to V3 of the Analytics APIs.  Originally we had an SSIS package using signed .NET DLLs in the GAC to access the older versions.  However, since the move to V3 we've not been able to install our custom DLLs referencing the Analytics APIs in the GAC as they are not signed.

 

So I've gone down the route of creating a Web Service wrapper to access our custom code that uses Analytics V3.  Now when I run our Unit Tests using Visual Studio everything works perfectly and I get data back no problem.  Here are some details:

  • Accessing our Analytics account using a Service Account.  Service account has been created and relevant access provided to the Analytics account
  • P12 certificate installed in the Windows Certificate Store under local machine
  • No issues when getting and using this certificate with the ServiceAccountCredential object in C#
  • Am specifying our Proxy and have confirmed that this is working without any issues (as I mentioned, works fine in our Unit Tests)
  • Created a Web Service wrapper to call the library and when I send a GET request to my wrapper to fire off the Analytics library it creates the AnalyticsService object without any problems but then goes to call:
o   Google.Apis.Analytics.v3.ManagementResource.ProfilesResource.ListRequest request = analyticsService.Management.Profiles.List("~all""~all");
o   Google.Apis.Analytics.v3.Data.Profiles profiles = request.Execute();
·        and hangs on the second line.  I get no errors at all, just hangs.  I've used wireshark to track the communications but we just appear to be waiting for something back from Google that never comes

So as I mentioned, when I access the Class Library from a Unit test, all works fine but when I access the same Class Library from my Web Service wrapper and send a GET request to kick it all off, it just hangs on that

second line.

 

So my questions are:  Anyone have any idea what the issue might be with the above!???  Also has anyone created a valid solution in SSIS to access your Analytics account that allows you to specify a Web Proxy??

--
You received this message because you are subscribed to the Google Groups "google-analytics-management-api" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-mana...@googlegroups.com.


For more options, visit https://groups.google.com/d/optout.


Access your county council services online 24 hours a day, 7 days a week at www.northyorks.gov.uk.

WARNING

 

Any opinions or statements expressed in this e-mail are those of the individual and not necessarily those of North Yorkshire County Council.

 

This e-mail and any files transmitted with it are confidential and solely for the use of the intended recipient. If you receive this in error, please do not disclose any information to anyone, notify the sender at the above address and then destroy all copies.

 

North Yorkshire County Council's computer systems and communications may be monitored to ensure effective operation of the system and for other lawful purposes. All GCSX traffic may be subject to recording and/or monitoring in accordance with relevant legislation.

 

Although we have endeavoured to ensure that this e-mail and any attachments are free from any virus we would advise you to take any necessary steps to ensure that they are actually virus free.

 

If you receive an automatic response stating that the recipient is away from the office and you wish to request information under either the Freedom of Information Act, the Data Protection Act or the Environmental Information Regulations please forward your request by e-mail to the Information Governance Team (inf...@northyorks.gov.uk) who will process your request.

North Yorkshire County Council.

--
You received this message because you are subscribed to the Google Groups "google-analytics-management-api" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-mana...@googlegroups.com.


For more options, visit https://groups.google.com/d/optout.


Access your county council services online 24 hours a day, 7 days a week at www.northyorks.gov.uk.

WARNING

 

Any opinions or statements expressed in this e-mail are those of the individual and not necessarily those of North Yorkshire County Council.

 

This e-mail and any files transmitted with it are confidential and solely for the use of the intended recipient. If you receive this in error, please do not disclose any information to anyone, notify the sender at the above address and then destroy all copies.

 

North Yorkshire County Council's computer systems and communications may be monitored to ensure effective operation of the system and for other lawful purposes. All GCSX traffic may be subject to recording and/or monitoring in accordance with relevant legislation.

 

Although we have endeavoured to ensure that this e-mail and any attachments are free from any virus we would advise you to take any necessary steps to ensure that they are actually virus free.

 

If you receive an automatic response stating that the recipient is away from the office and you wish to request information under either the Freedom of Information Act, the Data Protection Act or the Environmental Information Regulations please forward your request by e-mail to the Information Governance Team (inf...@northyorks.gov.uk) who will process your request.

North Yorkshire County Council.

--
You received this message because you are subscribed to the Google Groups "google-analytics-management-api" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-mana...@googlegroups.com.


For more options, visit https://groups.google.com/d/optout.


Access your county council services online 24 hours a day, 7 days a week at www.northyorks.gov.uk.

WARNING

 

Any opinions or statements expressed in this e-mail are those of the individual and not necessarily those of North Yorkshire County Council.

 

This e-mail and any files transmitted with it are confidential and solely for the use of the intended recipient. If you receive this in error, please do not disclose any information to anyone, notify the sender at the above address and then destroy all copies.

 

North Yorkshire County Council's computer systems and communications may be monitored to ensure effective operation of the system and for other lawful purposes. All GCSX traffic may be subject to recording and/or monitoring in accordance with relevant legislation.

 

Although we have endeavoured to ensure that this e-mail and any attachments are free from any virus we would advise you to take any necessary steps to ensure that they are actually virus free.

 

If you receive an automatic response stating that the recipient is away from the office and you wish to request information under either the Freedom of Information Act, the Data Protection Act or the Environmental Information Regulations please forward your request by e-mail to the Information Governance Team (inf...@northyorks.gov.uk) who will process your request.

North Yorkshire County Council.

--
You received this message because you are subscribed to the Google Groups "google-analytics-management-api" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-mana...@googlegroups.com.


For more options, visit https://groups.google.com/d/optout.

Reply all
Reply to author
Forward
0 new messages