Skip to content

Instantly share code, notes, and snippets.

@DanBradbury
Created October 28, 2014 16:14
Show Gist options
  • Save DanBradbury/b7d43c1f4049858264d2 to your computer and use it in GitHub Desktop.
Save DanBradbury/b7d43c1f4049858264d2 to your computer and use it in GitHub Desktop.

Pegasus Route

pegasus/signup

10/28/14 09:09:23.718 INFO Started GET "/pegasus/signup" for 127.0.0.1 at 2014-10-28 09:09:23 -0700
10/28/14 09:09:23.751 INFO Processing by Pegasus::SignupController#index as HTML
10/28/14 09:09:23.753 DEBUG   OrganizationMembership Load (0.2ms) rows: 1  SELECT `organization_memberships`.* FROM `organization_memberships` WHERE `organization_memberships`.`id` = 57 LIMIT 1
10/28/14 09:09:23.760 INFO   Rendered pegasus/views/pegasus/signup/index.html.slim within pegasus/layouts/setup (2.1ms)
10/28/14 09:09:23.768 DEBUG   User Load (0.2ms) rows: 1  SELECT `users`.* FROM `users` WHERE `users`.`id` = 64 LIMIT 1
10/28/14 09:09:23.770 DEBUG   Network Load (0.3ms) rows: 0  SELECT `networks`.* FROM `networks` WHERE `networks`.`vanity_domain` IN ('.localhost') LIMIT 1
10/28/14 09:09:23.772 DEBUG   Network Load (0.4ms) rows: 1  SELECT `networks`.* FROM `networks` WHERE `networks`.`nickname` = 'invoca' LIMIT 1
10/28/14 09:09:23.775 DEBUG   Network Load (0.6ms) rows: 1  SELECT `networks`.* FROM `networks` WHERE `networks`.`id` = 1 LIMIT 1
10/28/14 09:09:23.776 INFO   Rendered pegasus/views/pegasus/shared/_account_menu.html.slim (7.5ms)
10/28/14 09:09:23.780 INFO   Rendered shared/_google_analytics.html.erb (0.1ms)
10/28/14 09:09:23.780 INFO   Rendered pegasus/views/pegasus/layouts/base.html.slim (17.4ms)
10/28/14 09:09:23.780 INFO Completed 200 OK in 28.7ms (Views: 24.3ms | ActiveRecord: 1.8ms)

pegasus/search_integrations/adwords

10/28/14 09:11:48.422 INFO Started POST "/pegasus/signup" for 127.0.0.1 at 2014-10-28 09:11:48 -0700
10/28/14 09:11:48.456 INFO Processing by Pegasus::SignupController#create as HTML
10/28/14 09:11:48.456 INFO   Parameters: {"utf8"=>"✓", "authenticity_token"=>"YXVN1eMa+tU+3EmpLPq8qDM0fmpyV7nCj6Ze3XTECUI=", "presenter"=>{"user_first_name"=>"First", "user_email_address"=>"[email protected]", "company_name"=>"NA", "user_password"=>"[FILTERED]", "user_password_confirmation"=>"[FILTERED]"}, "commit"=>"Continue"}
10/28/14 09:11:48.457 DEBUG   OrganizationMembership Load (0.2ms) rows: 1  SELECT `organization_memberships`.* FROM `organization_memberships` WHERE `organization_memberships`.`id` = 57 LIMIT 1
10/28/14 09:11:48.459 DEBUG   Username Load (0.3ms) rows: 1  SELECT `usernames`.* FROM `usernames` WHERE `usernames`.`username` = '[email protected]' AND `usernames`.`network_id` IS NULL LIMIT 1
10/28/14 09:11:48.461 DEBUG   User Load (0.2ms) rows: 1  SELECT `users`.* FROM `users` WHERE `users`.`id` = 64 LIMIT 1
10/28/14 09:11:48.462 DEBUG   OrganizationMembership Load (0.2ms) rows: 3  SELECT `organization_memberships`.* FROM `organization_memberships` WHERE `organization_memberships`.`user_id` = 64 AND `organization_memberships`.`organization_type` = 'Network'
10/28/14 09:11:48.465 DEBUG   Network Load (0.3ms) rows: 1  SELECT `networks`.* FROM `networks` WHERE `networks`.`id` = 1 LIMIT 1
10/28/14 09:11:48.467 DEBUG   Network Load (0.3ms) rows: 1  SELECT `networks`.* FROM `networks` WHERE `networks`.`id` = 23 LIMIT 1
10/28/14 09:11:48.469 DEBUG   Network Load (0.3ms) rows: 1  SELECT `networks`.* FROM `networks` WHERE `networks`.`id` = 26 LIMIT 1
10/28/14 09:11:48.472 DEBUG    (0.3ms) rows: 1  SELECT COUNT(*) FROM `insight_slots` WHERE `insight_slots`.`organization_id` = 26 AND `insight_slots`.`organization_type` = 'Network'
10/28/14 09:11:48.475 DEBUG   Network Exists (0.2ms) rows: 0  SELECT 1 AS one FROM `networks` WHERE (`networks`.`name` = 'NA' AND `networks`.`id` != 26) LIMIT 1
10/28/14 09:11:48.476 DEBUG   Network Exists (0.2ms) rows: 0  SELECT 1 AS one FROM `networks` WHERE (`networks`.`nickname` = '0D922D36D8A4A86A95D1066CC6E2CCF3' AND `networks`.`id` != 26) LIMIT 1
10/28/14 09:11:48.477 DEBUG   Billing::BillingInfo Load (0.2ms) rows: 0  SELECT `billing_info`.* FROM `billing_info` WHERE `billing_info`.`organization_id` = 26 AND `billing_info`.`organization_type` = 'Network' LIMIT 1
10/28/14 09:11:48.479 DEBUG   OrganizationMembership Load (0.2ms) rows: 1  SELECT `organization_memberships`.* FROM `organization_memberships` WHERE `organization_memberships`.`user_id` = 64 ORDER BY membership_version desc, id desc LIMIT 1
10/28/14 09:11:48.480 DEBUG   CACHE (0.0ms)  SELECT `networks`.* FROM `networks` WHERE `networks`.`id` = 1 LIMIT 1
10/28/14 09:11:48.482 DEBUG   OrganizationMembership Load (0.2ms) rows: 3  SELECT `organization_memberships`.* FROM `organization_memberships` WHERE `organization_memberships`.`user_id` = 64
10/28/14 09:11:48.573 DEBUG   OrganizationMembership Load (0.3ms) rows: 3  SELECT `organization_memberships`.* FROM `organization_memberships` WHERE `organization_memberships`.`user_id` = 64
10/28/14 09:11:48.576 DEBUG   Network Load (0.4ms) rows: 3  SELECT `networks`.* FROM `networks` WHERE `networks`.`id` IN (1, 23, 26)
10/28/14 09:11:48.579 DEBUG   Username Load (0.2ms) rows: 1  SELECT `usernames`.* FROM `usernames` WHERE `usernames`.`user_id` = 64 ORDER BY id ASC
10/28/14 09:11:48.583 DEBUG   OrganizationMembership Load (0.3ms) rows: 1  SELECT `organization_memberships`.* FROM `organization_memberships` WHERE `organization_memberships`.`organization_id` = 26 AND `organization_memberships`.`organization_type` = 'Network' AND (user_id = 64) LIMIT 1
10/28/14 09:11:48.585 DEBUG   OrganizationMembership Exists (0.2ms) rows: 0  SELECT 1 AS one FROM `organization_memberships` WHERE (`organization_memberships`.`user_id` = BINARY 64 AND `organization_memberships`.`id` != 270 AND `organization_memberships`.`organization_id` = 26 AND `organization_memberships`.`organization_type` = 'Network') LIMIT 1
10/28/14 09:11:48.586 DEBUG    (0.1ms)  BEGIN
10/28/14 09:11:48.587 DEBUG   CACHE (0.0ms)  SELECT COUNT(*) FROM `insight_slots` WHERE `insight_slots`.`organization_id` = 26 AND `insight_slots`.`organization_type` = 'Network'
10/28/14 09:11:48.588 DEBUG   CACHE (0.0ms)  SELECT 1 AS one FROM `networks` WHERE (`networks`.`name` = 'NA' AND `networks`.`id` != 26) LIMIT 1
10/28/14 09:11:48.589 DEBUG   CACHE (0.0ms)  SELECT 1 AS one FROM `networks` WHERE (`networks`.`nickname` = '0D922D36D8A4A86A95D1066CC6E2CCF3' AND `networks`.`id` != 26) LIMIT 1
10/28/14 09:11:48.591 DEBUG   LargeTextField Load (0.2ms) rows: 0  SELECT `large_text_fields`.* FROM `large_text_fields` WHERE `large_text_fields`.`owner_id` = 26 AND `large_text_fields`.`owner_type` = 'Network'
10/28/14 09:11:48.595 DEBUG    (0.1ms)  COMMIT
10/28/14 09:11:48.597 DEBUG   Advertiser Load (0.2ms) rows: 1  SELECT `advertisers`.* FROM `advertisers` WHERE `advertisers`.`network_id` = 26 AND `advertisers`.`name` = 'Search' LIMIT 1
10/28/14 09:11:48.598 DEBUG    (0.1ms)  BEGIN
10/28/14 09:11:48.599 DEBUG   CACHE (0.0ms)  SELECT `networks`.* FROM `networks` WHERE `networks`.`id` = 26 LIMIT 1
10/28/14 09:11:48.600 DEBUG    (0.2ms) rows: 1  SELECT COUNT(*) FROM `insight_slots` WHERE `insight_slots`.`organization_id` = 58 AND `insight_slots`.`organization_type` = 'Advertiser'
10/28/14 09:11:48.602 DEBUG   Advertiser Exists (0.1ms) rows: 0  SELECT 1 AS one FROM `advertisers` WHERE (`advertisers`.`name` = 'Search' AND `advertisers`.`id` != 58 AND `advertisers`.`network_id` = 26) LIMIT 1
10/28/14 09:11:48.604 INFO [paperclip] Saving attachments.
10/28/14 09:11:48.605 DEBUG    (0.1ms)  COMMIT
10/28/14 09:11:48.605 DEBUG    (0.1ms)  BEGIN
10/28/14 09:11:48.607 DEBUG   OrganizationMembership Load (0.2ms) rows: 3  SELECT `organization_memberships`.* FROM `organization_memberships` WHERE `organization_memberships`.`user_id` = 64
10/28/14 09:11:48.609 DEBUG   CACHE (0.0ms)  SELECT `organization_memberships`.* FROM `organization_memberships` WHERE `organization_memberships`.`user_id` = 64
10/28/14 09:11:48.610 DEBUG   CACHE (0.0ms)  SELECT `networks`.* FROM `networks` WHERE `networks`.`id` IN (1, 23, 26)
10/28/14 09:11:48.614 DEBUG    (0.1ms)  COMMIT
10/28/14 09:11:48.615 DEBUG    (0.1ms)  BEGIN
10/28/14 09:11:48.617 DEBUG    (0.2ms)  update users set membership_version = membership_version + 1 where id = 64
10/28/14 09:11:48.618 DEBUG    (0.9ms)  COMMIT
10/28/14 09:11:48.620 DEBUG    (0.1ms)  BEGIN
10/28/14 09:11:48.621 DEBUG   CACHE (0.0ms)  SELECT 1 AS one FROM `organization_memberships` WHERE (`organization_memberships`.`user_id` = BINARY 64 AND `organization_memberships`.`id` != 270 AND `organization_memberships`.`organization_id` = 26 AND `organization_memberships`.`organization_type` = 'Network') LIMIT 1
10/28/14 09:11:48.622 DEBUG    (0.2ms)  update users set membership_version = membership_version + 1 where id = 64
10/28/14 09:11:48.623 DEBUG    (0.3ms)  COMMIT
10/28/14 09:11:48.625 DEBUG   User Load (0.2ms) rows: 1  SELECT `users`.* FROM `users` WHERE `users`.`id` = 64 LIMIT 1
10/28/14 09:11:48.627 DEBUG   Network Load (0.4ms) rows: 0  SELECT `networks`.* FROM `networks` WHERE `networks`.`vanity_domain` IN ('.localhost') LIMIT 1
10/28/14 09:11:48.629 DEBUG   Network Load (0.4ms) rows: 1  SELECT `networks`.* FROM `networks` WHERE `networks`.`nickname` = 'invoca' LIMIT 1
10/28/14 09:11:48.631 DEBUG   OrganizationMembership Load (0.2ms) rows: 1  SELECT `organization_memberships`.* FROM `organization_memberships` WHERE `organization_memberships`.`id` = 57 LIMIT 1
10/28/14 09:11:48.632 DEBUG   Network Load (0.3ms) rows: 1  SELECT `networks`.* FROM `networks` WHERE `networks`.`id` = 1 LIMIT 1
10/28/14 09:11:48.636 DEBUG   User Load (0.3ms) rows: 1  SELECT `users`.* FROM `users` INNER JOIN `organization_memberships` ON `users`.`id` = `organization_memberships`.`user_id` WHERE `organization_memberships`.`organization_id` = 1 AND `organization_memberships`.`organization_type` = 'Network' AND (contact_TN_verification_status IS NOT null) LIMIT 1
10/28/14 09:11:48.639 INFO Redirected to http://localhost:3000/pegasus/search_integrations/adwords
10/28/14 09:11:48.639 INFO Completed 302 Found in 183.7ms (ActiveRecord: 9.8ms)
10/28/14 09:11:48.647 INFO
10/28/14 09:11:48.647 INFO
10/28/14 09:11:48.647 INFO Started GET "/pegasus/search_integrations/adwords" for 127.0.0.1 at 2014-10-28 09:11:48 -0700
10/28/14 09:11:48.680 INFO Processing by Pegasus::SearchIntegrationsController#adwords as HTML
10/28/14 09:11:48.681 DEBUG   User Load (0.3ms) rows: 1  SELECT `users`.* FROM `users` WHERE `users`.`id` = 64 LIMIT 1
10/28/14 09:11:48.683 DEBUG   Network Load (0.3ms) rows: 0  SELECT `networks`.* FROM `networks` WHERE `networks`.`vanity_domain` IN ('.localhost') LIMIT 1
10/28/14 09:11:48.685 DEBUG   Network Load (0.4ms) rows: 1  SELECT `networks`.* FROM `networks` WHERE `networks`.`nickname` = 'invoca' LIMIT 1
10/28/14 09:11:48.687 DEBUG   OrganizationMembership Load (0.1ms) rows: 1  SELECT `organization_memberships`.* FROM `organization_memberships` WHERE `organization_memberships`.`id` = 57 LIMIT 1
10/28/14 09:11:48.688 DEBUG   Network Load (0.3ms) rows: 1  SELECT `networks`.* FROM `networks` WHERE `networks`.`id` = 1 LIMIT 1
10/28/14 09:11:48.690 DEBUG   Username Load (0.2ms) rows: 1  SELECT `usernames`.* FROM `usernames` WHERE `usernames`.`user_id` = 64 AND `usernames`.`verified` = 1 ORDER BY id ASC LIMIT 1
10/28/14 09:11:48.692 DEBUG   User Load (0.2ms) rows: 1  SELECT `users`.* FROM `users` INNER JOIN `organization_memberships` ON `users`.`id` = `organization_memberships`.`user_id` WHERE `organization_memberships`.`organization_id` = 1 AND `organization_memberships`.`organization_type` = 'Network' AND (contact_TN_verification_status IS NOT null) LIMIT 1
10/28/14 09:11:48.693 DEBUG   Username Load (0.1ms) rows: 1  SELECT `usernames`.* FROM `usernames` WHERE `usernames`.`id` = 64 LIMIT 1
10/28/14 09:11:48.697 INFO   Rendered pegasus/views/pegasus/search_integrations/adwords.html.slim within pegasus/layouts/setup (0.3ms)
10/28/14 09:11:48.704 INFO   Rendered pegasus/views/pegasus/shared/_account_menu.html.slim (0.0ms)
10/28/14 09:11:48.706 INFO   Rendered shared/_google_analytics.html.erb (0.1ms)
10/28/14 09:11:48.706 INFO   Rendered pegasus/views/pegasus/layouts/base.html.slim (7.4ms)
10/28/14 09:11:48.706 INFO Completed 200 OK in 26.3ms (Views: 12.4ms | ActiveRecord: 1.9ms)

pegasus/search_integrations/adwords_confirm_account

10/28/14 09:13:08.707 INFO Started GET "/pegasus/search_integrations/authorize" for 127.0.0.1 at 2014-10-28 09:13:08 -0700
10/28/14 09:13:08.739 INFO Processing by Pegasus::SearchIntegrationsController#authorize as HTML
10/28/14 09:13:08.741 DEBUG   User Load (0.3ms) rows: 1  SELECT `users`.* FROM `users` WHERE `users`.`id` = 64 LIMIT 1
10/28/14 09:13:08.742 DEBUG   Network Load (0.3ms) rows: 0  SELECT `networks`.* FROM `networks` WHERE `networks`.`vanity_domain` IN ('.localhost') LIMIT 1
10/28/14 09:13:08.744 DEBUG   Network Load (0.3ms) rows: 1  SELECT `networks`.* FROM `networks` WHERE `networks`.`nickname` = 'invoca' LIMIT 1
10/28/14 09:13:08.745 DEBUG   OrganizationMembership Load (0.2ms) rows: 1  SELECT `organization_memberships`.* FROM `organization_memberships` WHERE `organization_memberships`.`id` = 57 LIMIT 1
10/28/14 09:13:08.747 DEBUG   Network Load (0.3ms) rows: 1  SELECT `networks`.* FROM `networks` WHERE `networks`.`id` = 1 LIMIT 1
10/28/14 09:13:08.748 DEBUG   Username Load (0.2ms) rows: 1  SELECT `usernames`.* FROM `usernames` WHERE `usernames`.`user_id` = 64 AND `usernames`.`verified` = 1 ORDER BY id ASC LIMIT 1
10/28/14 09:13:08.750 DEBUG   User Load (0.2ms) rows: 1  SELECT `users`.* FROM `users` INNER JOIN `organization_memberships` ON `users`.`id` = `organization_memberships`.`user_id` WHERE `organization_memberships`.`organization_id` = 1 AND `organization_memberships`.`organization_type` = 'Network' AND (contact_TN_verification_status IS NOT null) LIMIT 1
10/28/14 09:13:08.751 DEBUG   Username Load (0.2ms) rows: 1  SELECT `usernames`.* FROM `usernames` WHERE `usernames`.`id` = 64 LIMIT 1
10/28/14 09:13:08.753 DEBUG   Advertiser Load (0.3ms) rows: 1  SELECT `advertisers`.* FROM `advertisers` WHERE `advertisers`.`network_id` = 1 AND `advertisers`.`name` = 'Search' LIMIT 1
10/28/14 09:13:08.755 DEBUG   PartnerOauthCredentials Load (0.2ms) rows: 1  SELECT `partner_oauth_credentials`.* FROM `partner_oauth_credentials` WHERE `partner_oauth_credentials`.`organization_id` = 54 AND `partner_oauth_credentials`.`organization_type` = 'Advertiser' AND `partner_oauth_credentials`.`partner_type` = 'Adwords' LIMIT 1
10/28/14 09:13:08.756 DEBUG   LargeTextField Load (0.1ms) rows: 1  SELECT `large_text_fields`.* FROM `large_text_fields` WHERE `large_text_fields`.`owner_id` = 1 AND `large_text_fields`.`owner_type` = 'PartnerOauthCredentials'
10/28/14 09:13:09.357 INFO Redirected to http://localhost:3000/pegasus/search_integrations/adwords_confirm_account
10/28/14 09:13:09.357 INFO Completed 302 Found in 617.9ms (ActiveRecord: 2.6ms)
SOAP request: https://adwords.google.com/api/adwords/mcm/v201402/CustomerService
SOAPAction: "get", User-Agent: demo-rails (AwApi-Ruby/0.13.1, Common-Ruby/0.9.5, Savon/1.2.0, ruby/2.1.2, HTTPI/1.1.1, net_http), Authorization: Bearer ya29.rACR0U5yg4pfG2A3hkvm1y7hqvW2ewGVpqTGFY3F0BZoWiGop7C_9Nz3JetYhyvw1xxte8A5naosxw, Content-Type: text/xml;charset=UTF-8, Content-Length: 721
<?xml version="1.0" encoding="UTF-8"?><env:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:wsdl="https://adwords.google.com/api/adwords/mcm/v201402" xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"><env:Header><wsdl:RequestHeader xmlns="https://adwords.google.com/api/adwords/cm/v201402"><userAgent>demo-rails (AwApi-Ruby/0.13.1, Common-Ruby/0.9.5, Savon/1.2.0, ruby/2.1.2, HTTPI/1.1.1, net_http)</userAgent><developerToken>uou9zUUG37tesaKOixJ7og</developerToken><clientCustomerId>2973476224</clientCustomerId></wsdl:RequestHeader></env:Header><env:Body><get xmlns="https://adwords.google.com/api/adwords/mcm/v201402"></get></env:Body></env:Envelope>
SOAP response (status 200):
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Header><ResponseHeader xmlns:ns2="https://adwords.google.com/api/adwords/cm/v201402" xmlns="https://adwords.google.com/api/adwords/mcm/v201402"><ns2:requestId>0005067dec6978580abfb78862005e5a</ns2:requestId><ns2:serviceName>CustomerService</ns2:serviceName><ns2:methodName>get</ns2:methodName><ns2:operations>0</ns2:operations><ns2:responseTime>113</ns2:responseTime></ResponseHeader></soap:Header><soap:Body><getResponse xmlns="https://adwords.google.com/api/adwords/mcm/v201402" xmlns:ns2="https://adwords.google.com/api/adwords/cm/v201402"><rval><customerId>2973476224</customerId><currencyCode>USD</currencyCode><dateTimeZone>America/Los_Angeles</dateTimeZone><descriptiveName>invoca test actual ads</descriptiveName><companyName></companyName><canManageClients>false</canManageClients><testAccount>false</testAccount><autoTaggingEnabled>true</autoTaggingEnabled></rval></getResponse></soap:Body></soap:Envelope>
content-type: text/xml; charset=UTF-8, date: Tue, 28 Oct 2014 16:13:10 GMT, expires: Tue, 28 Oct 2014 16:13:10 GMT, cache-control: private, max-age=0, x-content-type-options: nosniff, x-frame-options: SAMEORIGIN, x-xss-protection: 1; mode=block, server: GSE, transfer-encoding: chunked
10/28/14 09:13:09.363 INFO
10/28/14 09:13:09.363 INFO
10/28/14 09:13:09.364 INFO Started GET "/pegasus/search_integrations/adwords_confirm_account" for 127.0.0.1 at 2014-10-28 09:13:09 -0700
10/28/14 09:13:09.497 INFO Processing by Pegasus::SearchIntegrationsController#adwords_confirm_account as HTML
10/28/14 09:13:09.498 DEBUG   User Load (0.2ms) rows: 1  SELECT `users`.* FROM `users` WHERE `users`.`id` = 64 LIMIT 1
10/28/14 09:13:09.500 DEBUG   Network Load (0.3ms) rows: 0  SELECT `networks`.* FROM `networks` WHERE `networks`.`vanity_domain` IN ('.localhost') LIMIT 1
10/28/14 09:13:09.501 DEBUG   Network Load (0.3ms) rows: 1  SELECT `networks`.* FROM `networks` WHERE `networks`.`nickname` = 'invoca' LIMIT 1
10/28/14 09:13:09.503 DEBUG   OrganizationMembership Load (0.2ms) rows: 1  SELECT `organization_memberships`.* FROM `organization_memberships` WHERE `organization_memberships`.`id` = 57 LIMIT 1
10/28/14 09:13:09.505 DEBUG   Network Load (0.4ms) rows: 1  SELECT `networks`.* FROM `networks` WHERE `networks`.`id` = 1 LIMIT 1
10/28/14 09:13:09.506 DEBUG   Username Load (0.3ms) rows: 1  SELECT `usernames`.* FROM `usernames` WHERE `usernames`.`user_id` = 64 AND `usernames`.`verified` = 1 ORDER BY id ASC LIMIT 1
10/28/14 09:13:09.508 DEBUG   User Load (0.2ms) rows: 1  SELECT `users`.* FROM `users` INNER JOIN `organization_memberships` ON `users`.`id` = `organization_memberships`.`user_id` WHERE `organization_memberships`.`organization_id` = 1 AND `organization_memberships`.`organization_type` = 'Network' AND (contact_TN_verification_status IS NOT null) LIMIT 1
10/28/14 09:13:09.509 DEBUG   Username Load (0.2ms) rows: 1  SELECT `usernames`.* FROM `usernames` WHERE `usernames`.`id` = 64 LIMIT 1
10/28/14 09:13:09.511 DEBUG   Advertiser Load (0.2ms) rows: 1  SELECT `advertisers`.* FROM `advertisers` WHERE `advertisers`.`network_id` = 1 AND `advertisers`.`name` = 'Search' LIMIT 1
10/28/14 09:13:09.513 DEBUG   PartnerOauthCredentials Load (0.2ms) rows: 1  SELECT `partner_oauth_credentials`.* FROM `partner_oauth_credentials` WHERE `partner_oauth_credentials`.`organization_id` = 54 AND `partner_oauth_credentials`.`organization_type` = 'Advertiser' AND `partner_oauth_credentials`.`partner_type` = 'Adwords' LIMIT 1
10/28/14 09:13:09.514 DEBUG   LargeTextField Load (0.2ms) rows: 1  SELECT `large_text_fields`.* FROM `large_text_fields` WHERE `large_text_fields`.`owner_id` = 1 AND `large_text_fields`.`owner_type` = 'PartnerOauthCredentials'
10/28/14 09:13:10.796 INFO   Rendered pegasus/views/pegasus/search_integrations/adwords_confirm_account.html.slim within pegasus/layouts/setup (0.8ms)
10/28/14 09:13:10.802 INFO   Rendered pegasus/views/pegasus/shared/_account_menu.html.slim (0.0ms)
10/28/14 09:13:10.805 INFO   Rendered shared/_google_analytics.html.erb (0.1ms)
10/28/14 09:13:10.805 INFO   Rendered pegasus/views/pegasus/layouts/base.html.slim (7.0ms)
10/28/14 09:13:10.805 INFO Completed 200 OK in 1307.9ms (Views: 13.0ms | ActiveRecord: 2.6ms)

pegasus/search_integrations/adwords_settings

SOAP request: https://adwords.google.com/api/adwords/mcm/v201402/CustomerService
SOAPAction: "get", User-Agent: demo-rails (AwApi-Ruby/0.13.1, Common-Ruby/0.9.5, Savon/1.2.0, ruby/2.1.2, HTTPI/1.1.1, net_http), Authorization: Bearer ya29.rAAyEe85IBAmHfDJxNkfwP6G5QqeHWWsJuIYPma4L8-s2t2OAubFbz8i3FdTW-RYHRL2BCUcQO7C5w, Content-Type: text/xml;charset=UTF-8, Content-Length: 721
<?xml version="1.0" encoding="UTF-8"?><env:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:wsdl="https://adwords.google.com/api/adwords/mcm/v201402" xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"><env:Header><wsdl:RequestHeader xmlns="https://adwords.google.com/api/adwords/cm/v201402"><userAgent>demo-rails (AwApi-Ruby/0.13.1, Common-Ruby/0.9.5, Savon/1.2.0, ruby/2.1.2, HTTPI/1.1.1, net_http)</userAgent><developerToken>uou9zUUG37tesaKOixJ7og</developerToken><clientCustomerId>2973476224</clientCustomerId></wsdl:RequestHeader></env:Header><env:Body><get xmlns="https://adwords.google.com/api/adwords/mcm/v201402"></get></env:Body></env:Envelope>
SOAP response (status 200):
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Header><ResponseHeader xmlns:ns2="https://adwords.google.com/api/adwords/cm/v201402" xmlns="https://adwords.google.com/api/adwords/mcm/v201402"><ns2:requestId>0005067ded77bfc00ab61d08560048e0</ns2:requestId><ns2:serviceName>CustomerService</ns2:serviceName><ns2:methodName>get</ns2:methodName><ns2:operations>0</ns2:operations><ns2:responseTime>14</ns2:responseTime></ResponseHeader></soap:Header><soap:Body><getResponse xmlns="https://adwords.google.com/api/adwords/mcm/v201402" xmlns:ns2="https://adwords.google.com/api/adwords/cm/v201402"><rval><customerId>2973476224</customerId><currencyCode>USD</currencyCode><dateTimeZone>America/Los_Angeles</dateTimeZone><descriptiveName>invoca test actual ads</descriptiveName><companyName></companyName><canManageClients>false</canManageClients><testAccount>false</testAccount><autoTaggingEnabled>true</autoTaggingEnabled></rval></getResponse></soap:Body></soap:Envelope>
content-type: text/xml; charset=UTF-8, date: Tue, 28 Oct 2014 16:13:28 GMT, expires: Tue, 28 Oct 2014 16:13:28 GMT, cache-control: private, max-age=0, x-content-type-options: nosniff, x-frame-options: SAMEORIGIN, x-xss-protection: 1; mode=block, server: GSE, transfer-encoding: chunked
SOAP request: https://adwords.google.com/api/adwords/mcm/v201402/ManagedCustomerService
SOAPAction: "mutateLink", User-Agent: demo-rails (AwApi-Ruby/0.13.1, Common-Ruby/0.9.5, Savon/1.2.0, ruby/2.1.2, HTTPI/1.1.1, net_http), Authorization: Bearer ya29.rADLUGVm-pJLKmp8v4QDtsCWD0CKs8bB9JaXHLcWuAQPev-0R3-UNLXb, Content-Type: text/xml;charset=UTF-8, Content-Length: 1001
<?xml version="1.0" encoding="UTF-8"?><env:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:wsdl="https://adwords.google.com/api/adwords/mcm/v201402" xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns0="https://adwords.google.com/api/adwords/cm/v201402"><env:Header><wsdl:RequestHeader xmlns="https://adwords.google.com/api/adwords/cm/v201402"><userAgent>demo-rails (AwApi-Ruby/0.13.1, Common-Ruby/0.9.5, Savon/1.2.0, ruby/2.1.2, HTTPI/1.1.1, net_http)</userAgent><developerToken>uou9zUUG37tesaKOixJ7og</developerToken><clientCustomerId>5829664808</clientCustomerId></wsdl:RequestHeader></env:Header><env:Body><mutateLink xmlns="https://adwords.google.com/api/adwords/mcm/v201402"><operations><ns0:operator>ADD</ns0:operator><operand><managerCustomerId>5829664808</managerCustomerId><clientCustomerId>2973476224</clientCustomerId><linkStatus>PENDING</linkStatus></operand></operations></mutateLink></env:Body></env:Envelope>
SOAP response (status 500):
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Header><ns2:ResponseHeader xmlns:ns2="https://adwords.google.com/api/adwords/mcm/v201402" xmlns="https://adwords.google.com/api/adwords/cm/v201402"><requestId>0005067ded8957a80abfb184f9000aee</requestId><serviceName>ManagedCustomerService</serviceName><methodName>mutateLink</methodName><operations>1</operations><responseTime>151</responseTime></ns2:ResponseHeader></soap:Header><soap:Body><soap:Fault><faultcode>soap:Server</faultcode><faultstring>[ManagedCustomerServiceError.ALREADY_MANAGED_BY_THIS_MANAGER @ operations[0]]</faultstring><detail><ns2:ApiExceptionFault xmlns="https://adwords.google.com/api/adwords/cm/v201402" xmlns:ns2="https://adwords.google.com/api/adwords/mcm/v201402"><message>[ManagedCustomerServiceError.ALREADY_MANAGED_BY_THIS_MANAGER @ operations[0]]</message><ApplicationException.Type>ApiException</ApplicationException.Type><errors xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ns2:ManagedCustomerServiceError"><fieldPath>operations[0]</fieldPath><trigger></trigger><errorString>ManagedCustomerServiceError.ALREADY_MANAGED_BY_THIS_MANAGER</errorString><ApiError.Type>ManagedCustomerServiceError</ApiError.Type><ns2:reason>UNKNOWN</ns2:reason></errors></ns2:ApiExceptionFault></detail></soap:Fault></soap:Body></soap:Envelope>
content-type: text/xml; charset=UTF-8, date: Tue, 28 Oct 2014 16:13:29 GMT, expires: Tue, 28 Oct 2014 16:13:29 GMT, cache-control: private, max-age=0, x-content-type-options: nosniff, x-frame-options: SAMEORIGIN, x-xss-protection: 1; mode=block, server: GSE, transfer-encoding: chunked
10/28/14 09:13:27.318 INFO
10/28/14 09:13:27.319 INFO
10/28/14 09:13:27.319 INFO Started POST "/pegasus/search_integrations/adwords_confirm_account" for 127.0.0.1 at 2014-10-28 09:13:27 -0700
10/28/14 09:13:27.352 INFO Processing by Pegasus::SearchIntegrationsController#adwords_confirm_account as HTML
10/28/14 09:13:27.352 INFO   Parameters: {"authenticity_token"=>"YXVN1eMa+tU+3EmpLPq8qDM0fmpyV7nCj6Ze3XTECUI="}
10/28/14 09:13:27.353 DEBUG   User Load (0.2ms) rows: 1  SELECT `users`.* FROM `users` WHERE `users`.`id` = 64 LIMIT 1
10/28/14 09:13:27.355 DEBUG   Network Load (0.4ms) rows: 0  SELECT `networks`.* FROM `networks` WHERE `networks`.`vanity_domain` IN ('.localhost') LIMIT 1
10/28/14 09:13:27.358 DEBUG   Network Load (0.5ms) rows: 1  SELECT `networks`.* FROM `networks` WHERE `networks`.`nickname` = 'invoca' LIMIT 1
10/28/14 09:13:27.360 DEBUG   OrganizationMembership Load (0.2ms) rows: 1  SELECT `organization_memberships`.* FROM `organization_memberships` WHERE `organization_memberships`.`id` = 57 LIMIT 1
10/28/14 09:13:27.362 DEBUG   Network Load (0.4ms) rows: 1  SELECT `networks`.* FROM `networks` WHERE `networks`.`id` = 1 LIMIT 1
10/28/14 09:13:27.365 DEBUG   Username Load (0.3ms) rows: 1  SELECT `usernames`.* FROM `usernames` WHERE `usernames`.`user_id` = 64 AND `usernames`.`verified` = 1 ORDER BY id ASC LIMIT 1
10/28/14 09:13:27.367 DEBUG   User Load (0.3ms) rows: 1  SELECT `users`.* FROM `users` INNER JOIN `organization_memberships` ON `users`.`id` = `organization_memberships`.`user_id` WHERE `organization_memberships`.`organization_id` = 1 AND `organization_memberships`.`organization_type` = 'Network' AND (contact_TN_verification_status IS NOT null) LIMIT 1
10/28/14 09:13:27.369 DEBUG   Username Load (0.2ms) rows: 1  SELECT `usernames`.* FROM `usernames` WHERE `usernames`.`id` = 64 LIMIT 1
10/28/14 09:13:27.371 DEBUG   Advertiser Load (0.3ms) rows: 1  SELECT `advertisers`.* FROM `advertisers` WHERE `advertisers`.`network_id` = 1 AND `advertisers`.`name` = 'Search' LIMIT 1
10/28/14 09:13:27.374 DEBUG   PartnerOauthCredentials Load (0.2ms) rows: 1  SELECT `partner_oauth_credentials`.* FROM `partner_oauth_credentials` WHERE `partner_oauth_credentials`.`organization_id` = 54 AND `partner_oauth_credentials`.`organization_type` = 'Advertiser' AND `partner_oauth_credentials`.`partner_type` = 'Adwords' LIMIT 1
10/28/14 09:13:27.375 DEBUG   LargeTextField Load (0.2ms) rows: 1  SELECT `large_text_fields`.* FROM `large_text_fields` WHERE `large_text_fields`.`owner_id` = 1 AND `large_text_fields`.`owner_type` = 'PartnerOauthCredentials'
10/28/14 09:13:28.410 DEBUG    (0.3ms) rows: 1  SELECT COUNT(*) FROM `insight_slots` WHERE `insight_slots`.`organization_id` = 1 AND `insight_slots`.`organization_type` = 'Network'
10/28/14 09:13:28.413 DEBUG   Network Exists (0.1ms) rows: 0  SELECT 1 AS one FROM `networks` WHERE (`networks`.`name` = 'Invoca' AND `networks`.`id` != 1) LIMIT 1
10/28/14 09:13:28.415 DEBUG   Network Exists (0.2ms) rows: 0  SELECT 1 AS one FROM `networks` WHERE (`networks`.`nickname` = 'invoca' AND `networks`.`id` != 1) LIMIT 1
10/28/14 09:13:28.416 DEBUG   Billing::BillingInfo Load (0.2ms) rows: 1  SELECT `billing_info`.* FROM `billing_info` WHERE `billing_info`.`organization_id` = 1 AND `billing_info`.`organization_type` = 'Network' LIMIT 1
10/28/14 09:13:28.418 DEBUG   CACHE (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 64 LIMIT 1
10/28/14 09:13:28.419 DEBUG   OrganizationMembership Load (0.2ms) rows: 1  SELECT `organization_memberships`.* FROM `organization_memberships` WHERE `organization_memberships`.`user_id` = 64 ORDER BY membership_version desc, id desc LIMIT 1
10/28/14 09:13:28.421 DEBUG   CACHE (0.0ms)  SELECT `networks`.* FROM `networks` WHERE `networks`.`id` = 1 LIMIT 1
10/28/14 09:13:28.422 DEBUG   OrganizationMembership Load (0.2ms) rows: 3  SELECT `organization_memberships`.* FROM `organization_memberships` WHERE `organization_memberships`.`user_id` = 64
10/28/14 09:13:28.423 DEBUG   OrganizationMembership Load (0.2ms) rows: 3  SELECT `organization_memberships`.* FROM `organization_memberships` WHERE `organization_memberships`.`user_id` = 64
10/28/14 09:13:28.425 DEBUG   Network Load (0.4ms) rows: 3  SELECT `networks`.* FROM `networks` WHERE `networks`.`id` IN (1, 23, 26)
10/28/14 09:13:28.428 DEBUG   Username Load (0.2ms) rows: 1  SELECT `usernames`.* FROM `usernames` WHERE `usernames`.`user_id` = 64 ORDER BY id ASC
10/28/14 09:13:28.431 DEBUG   OrganizationMembership Load (0.2ms) rows: 1  SELECT `organization_memberships`.* FROM `organization_memberships` WHERE `organization_memberships`.`organization_id` = 1 AND `organization_memberships`.`organization_type` = 'Network' AND (user_id = 64) LIMIT 1
10/28/14 09:13:28.433 DEBUG   OrganizationMembership Exists (0.2ms) rows: 0  SELECT 1 AS one FROM `organization_memberships` WHERE (`organization_memberships`.`user_id` = BINARY 64 AND `organization_memberships`.`id` != 271 AND `organization_memberships`.`organization_id` = 1 AND `organization_memberships`.`organization_type` = 'Network') LIMIT 1
10/28/14 09:13:28.435 DEBUG   Advertiser Load (0.3ms) rows: 1  SELECT `advertisers`.* FROM `advertisers` WHERE `advertisers`.`id` = 54 LIMIT 1
10/28/14 09:13:28.436 DEBUG    (0.1ms)  BEGIN
10/28/14 09:13:28.437 DEBUG   CACHE (0.0ms)  SELECT COUNT(*) FROM `insight_slots` WHERE `insight_slots`.`organization_id` = 1 AND `insight_slots`.`organization_type` = 'Network'
10/28/14 09:13:28.438 DEBUG   CACHE (0.0ms)  SELECT 1 AS one FROM `networks` WHERE (`networks`.`name` = 'Invoca' AND `networks`.`id` != 1) LIMIT 1
10/28/14 09:13:28.439 DEBUG   CACHE (0.0ms)  SELECT 1 AS one FROM `networks` WHERE (`networks`.`nickname` = 'invoca' AND `networks`.`id` != 1) LIMIT 1
10/28/14 09:13:28.441 DEBUG   LargeTextField Load (0.2ms) rows: 0  SELECT `large_text_fields`.* FROM `large_text_fields` WHERE `large_text_fields`.`owner_id` = 1 AND `large_text_fields`.`owner_type` = 'Network'
10/28/14 09:13:28.445 DEBUG    (0.1ms)  COMMIT
10/28/14 09:13:28.445 DEBUG    (0.1ms)  BEGIN
10/28/14 09:13:28.446 DEBUG   CACHE (0.0ms)  SELECT `networks`.* FROM `networks` WHERE `networks`.`id` = 1 LIMIT 1
10/28/14 09:13:28.448 DEBUG    (0.2ms) rows: 1  SELECT COUNT(*) FROM `insight_slots` WHERE `insight_slots`.`organization_id` = 54 AND `insight_slots`.`organization_type` = 'Advertiser'
10/28/14 09:13:28.449 DEBUG   Advertiser Exists (0.2ms) rows: 0  SELECT 1 AS one FROM `advertisers` WHERE (`advertisers`.`name` = 'Search' AND `advertisers`.`id` != 54 AND `advertisers`.`network_id` = 1) LIMIT 1
10/28/14 09:13:28.451 INFO [paperclip] Saving attachments.
10/28/14 09:13:28.452 DEBUG    (0.1ms)  COMMIT
10/28/14 09:13:28.453 DEBUG    (0.1ms)  BEGIN
10/28/14 09:13:28.456 DEBUG   OrganizationMembership Load (0.4ms) rows: 3  SELECT `organization_memberships`.* FROM `organization_memberships` WHERE `organization_memberships`.`user_id` = 64
10/28/14 09:13:28.458 DEBUG   CACHE (0.0ms)  SELECT `organization_memberships`.* FROM `organization_memberships` WHERE `organization_memberships`.`user_id` = 64
10/28/14 09:13:28.459 DEBUG   CACHE (0.0ms)  SELECT `networks`.* FROM `networks` WHERE `networks`.`id` IN (1, 23, 26)
10/28/14 09:13:28.462 DEBUG    (0.1ms)  COMMIT
10/28/14 09:13:28.463 DEBUG    (0.1ms)  BEGIN
10/28/14 09:13:28.465 DEBUG    (0.2ms)  update users set membership_version = membership_version + 1 where id = 64
10/28/14 09:13:28.466 DEBUG    (1.0ms)  COMMIT
10/28/14 09:13:28.467 DEBUG    (0.1ms)  BEGIN
10/28/14 09:13:28.469 DEBUG   CACHE (0.0ms)  SELECT 1 AS one FROM `organization_memberships` WHERE (`organization_memberships`.`user_id` = BINARY 64 AND `organization_memberships`.`id` != 271 AND `organization_memberships`.`organization_id` = 1 AND `organization_memberships`.`organization_type` = 'Network') LIMIT 1
10/28/14 09:13:28.470 DEBUG    (0.2ms)  update users set membership_version = membership_version + 1 where id = 64
10/28/14 09:13:28.470 DEBUG    (0.4ms)  COMMIT
10/28/14 09:13:29.699 INFO Redirected to http://localhost:3000/pegasus/search_integrations/adwords_settings
10/28/14 09:13:29.699 INFO Completed 302 Found in 2347.5ms (ActiveRecord: 9.4ms)
SOAP request: https://adwords.google.com/api/adwords/mcm/v201402/CustomerService
SOAPAction: "get", User-Agent: demo-rails (AwApi-Ruby/0.13.1, Common-Ruby/0.9.5, Savon/1.2.0, ruby/2.1.2, HTTPI/1.1.1, net_http), Authorization: Bearer ya29.rACHx0xq51C-LXacevpdMhWmoGm4AdGZab3Pl4vehGTR9kWfao5IsW63wwnzZtTVvrTCToJDA8fMRg, Content-Type: text/xml;charset=UTF-8, Content-Length: 721
<?xml version="1.0" encoding="UTF-8"?><env:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:wsdl="https://adwords.google.com/api/adwords/mcm/v201402" xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"><env:Header><wsdl:RequestHeader xmlns="https://adwords.google.com/api/adwords/cm/v201402"><userAgent>demo-rails (AwApi-Ruby/0.13.1, Common-Ruby/0.9.5, Savon/1.2.0, ruby/2.1.2, HTTPI/1.1.1, net_http)</userAgent><developerToken>uou9zUUG37tesaKOixJ7og</developerToken><clientCustomerId>2973476224</clientCustomerId></wsdl:RequestHeader></env:Header><env:Body><get xmlns="https://adwords.google.com/api/adwords/mcm/v201402"></get></env:Body></env:Envelope>
SOAP response (status 200):
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Header><ResponseHeader xmlns:ns2="https://adwords.google.com/api/adwords/cm/v201402" xmlns="https://adwords.google.com/api/adwords/mcm/v201402"><ns2:requestId>0005067ded9bbab00ab61d08560048e0</ns2:requestId><ns2:serviceName>CustomerService</ns2:serviceName><ns2:methodName>get</ns2:methodName><ns2:operations>0</ns2:operations><ns2:responseTime>122</ns2:responseTime></ResponseHeader></soap:Header><soap:Body><getResponse xmlns="https://adwords.google.com/api/adwords/mcm/v201402" xmlns:ns2="https://adwords.google.com/api/adwords/cm/v201402"><rval><customerId>2973476224</customerId><currencyCode>USD</currencyCode><dateTimeZone>America/Los_Angeles</dateTimeZone><descriptiveName>invoca test actual ads</descriptiveName><companyName></companyName><canManageClients>false</canManageClients><testAccount>false</testAccount><autoTaggingEnabled>true</autoTaggingEnabled></rval></getResponse></soap:Body></soap:Envelope>
content-type: text/xml; charset=UTF-8, date: Tue, 28 Oct 2014 16:13:30 GMT, expires: Tue, 28 Oct 2014 16:13:30 GMT, cache-control: private, max-age=0, x-content-type-options: nosniff, x-frame-options: SAMEORIGIN, x-xss-protection: 1; mode=block, server: GSE, transfer-encoding: chunked
SOAP request: https://adwords.google.com/api/adwords/cm/v201402/FeedService
SOAPAction: "get", User-Agent: demo-rails (AwApi-Ruby/0.13.1, Common-Ruby/0.9.5, Savon/1.2.0, ruby/2.1.2, HTTPI/1.1.1, net_http), Authorization: Bearer ya29.rACHx0xq51C-LXacevpdMhWmoGm4AdGZab3Pl4vehGTR9kWfao5IsW63wwnzZtTVvrTCToJDA8fMRg, Content-Type: text/xml;charset=UTF-8, Content-Length: 957
<?xml version="1.0" encoding="UTF-8"?><env:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:wsdl="https://adwords.google.com/api/adwords/cm/v201402" xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"><env:Header><wsdl:RequestHeader xmlns="https://adwords.google.com/api/adwords/cm/v201402"><userAgent>demo-rails (AwApi-Ruby/0.13.1, Common-Ruby/0.9.5, Savon/1.2.0, ruby/2.1.2, HTTPI/1.1.1, net_http)</userAgent><developerToken>uou9zUUG37tesaKOixJ7og</developerToken><clientCustomerId>2973476224</clientCustomerId></wsdl:RequestHeader></env:Header><env:Body><get xmlns="https://adwords.google.com/api/adwords/cm/v201402"><selector><fields>Id</fields><fields>Name</fields><fields>Attributes</fields><fields>FeedStatus</fields><fields>Origin</fields><predicates><field>FeedStatus</field><operator>EQUALS</operator><values>ACTIVE</values></predicates></selector></get></env:Body></env:Envelope>
SOAP response (status 200):
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Header><ResponseHeader xmlns="https://adwords.google.com/api/adwords/cm/v201402"><requestId>0005067deda50d680ab6e0a18b00028b</requestId><serviceName>FeedService</serviceName><methodName>get</methodName><operations>1</operations><responseTime>65</responseTime></ResponseHeader></soap:Header><soap:Body><getResponse xmlns="https://adwords.google.com/api/adwords/cm/v201402"><rval><totalNumEntries>3</totalNumEntries><Page.Type>FeedPage</Page.Type><entries><id>18193047</id><name>Main phone number feed</name><attributes><id>1</id><name>CallPhoneNumber</name><type>STRING</type><isPartOfKey>false</isPartOfKey></attributes><attributes><id>2</id><name>CallCountryCode</name><type>STRING</type><isPartOfKey>false</isPartOfKey></attributes><attributes><id>3</id><name>CallCallTracking</name><type>BOOLEAN</type><isPartOfKey>false</isPartOfKey></attributes><attributes><id>4</id><name>CallCallOnly</name><type>BOOLEAN</type><isPartOfKey>false</isPartOfKey></attributes><attributes><id>5</id><name>CallConversionDuration</name><type>INT64</type><isPartOfKey>false</isPartOfKey></attributes><attributes><id>6</id><name>CallConversionTypeId</name><type>INT64</type><isPartOfKey>false</isPartOfKey></attributes><status>ACTIVE</status><origin>ADWORDS</origin></entries><entries><id>18199008</id><name>Main sitelink feed</name><attributes><id>1</id><name>SitelinkName</name><type>STRING</type><isPartOfKey>false</isPartOfKey></attributes><attributes><id>2</id><name>SitelinkUrl</name><type>URL</type><isPartOfKey>false</isPartOfKey></attributes><attributes><id>3</id><name>SitelinkDescription1</name><type>STRING</type><isPartOfKey>false</isPartOfKey></attributes><attributes><id>4</id><name>SitelinkDescription2</name><type>STRING</type><isPartOfKey>false</isPartOfKey></attributes><status>ACTIVE</status><origin>ADWORDS</origin></entries><entries><id>18520611</id><name>Main review feed</name><attributes><id>1</id><name>Text</name><type>STRING</type><isPartOfKey>false</isPartOfKey></attributes><attributes><id>2</id><name>Source Name</name><type>STRING</type><isPartOfKey>false</isPartOfKey></attributes><attributes><id>3</id><name>Source Url</name><type>URL</type><isPartOfKey>false</isPartOfKey></attributes><attributes><id>4</id><name>Text Exactly Quoted</name><type>BOOLEAN</type><isPartOfKey>false</isPartOfKey></attributes><status>ACTIVE</status><origin>ADWORDS</origin></entries></rval></getResponse></soap:Body></soap:Envelope>
content-type: text/xml; charset=UTF-8, date: Tue, 28 Oct 2014 16:13:31 GMT, expires: Tue, 28 Oct 2014 16:13:31 GMT, cache-control: private, max-age=0, x-content-type-options: nosniff, x-frame-options: SAMEORIGIN, x-xss-protection: 1; mode=block, server: GSE, transfer-encoding: chunked
SOAP request: https://adwords.google.com/api/adwords/cm/v201402/FeedItemService
SOAPAction: "get", User-Agent: demo-rails (AwApi-Ruby/0.13.1, Common-Ruby/0.9.5, Savon/1.2.0, ruby/2.1.2, HTTPI/1.1.1, net_http), Authorization: Bearer ya29.rACHx0xq51C-LXacevpdMhWmoGm4AdGZab3Pl4vehGTR9kWfao5IsW63wwnzZtTVvrTCToJDA8fMRg, Content-Type: text/xml;charset=UTF-8, Content-Length: 980
<?xml version="1.0" encoding="UTF-8"?><env:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:wsdl="https://adwords.google.com/api/adwords/cm/v201402" xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"><env:Header><wsdl:RequestHeader xmlns="https://adwords.google.com/api/adwords/cm/v201402"><userAgent>demo-rails (AwApi-Ruby/0.13.1, Common-Ruby/0.9.5, Savon/1.2.0, ruby/2.1.2, HTTPI/1.1.1, net_http)</userAgent><developerToken>uou9zUUG37tesaKOixJ7og</developerToken><clientCustomerId>2973476224</clientCustomerId></wsdl:RequestHeader></env:Header><env:Body><get xmlns="https://adwords.google.com/api/adwords/cm/v201402"><selector><fields>FeedId</fields><fields>Status</fields><predicates><field>Status</field><operator>EQUALS</operator><values>ACTIVE</values></predicates><predicates><field>FeedId</field><operator>EQUALS</operator><values>18193047</values></predicates></selector></get></env:Body></env:Envelope>
SOAP response (status 200):
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Header><ResponseHeader xmlns="https://adwords.google.com/api/adwords/cm/v201402"><requestId>0005067dedb1cb200ab6877180003176</requestId><serviceName>FeedItemService</serviceName><methodName>get</methodName><operations>1</operations><responseTime>93</responseTime></ResponseHeader></soap:Header><soap:Body><getResponse xmlns="https://adwords.google.com/api/adwords/cm/v201402"><rval><totalNumEntries>1</totalNumEntries><Page.Type>FeedItemPage</Page.Type><entries><feedId>18193047</feedId><feedItemId>791651551</feedItemId><status>ACTIVE</status></entries></rval></getResponse></soap:Body></soap:Envelope>
content-type: text/xml; charset=UTF-8, date: Tue, 28 Oct 2014 16:13:32 GMT, expires: Tue, 28 Oct 2014 16:13:32 GMT, cache-control: private, max-age=0, x-content-type-options: nosniff, x-frame-options: SAMEORIGIN, x-xss-protection: 1; mode=block, server: GSE, transfer-encoding: chunked
10/28/14 09:13:29.705 INFO
10/28/14 09:13:29.705 INFO
10/28/14 09:13:29.705 INFO Started GET "/pegasus/search_integrations/adwords_settings" for 127.0.0.1 at 2014-10-28 09:13:29 -0700
10/28/14 09:13:29.737 INFO Processing by Pegasus::SearchIntegrationsController#adwords_settings as HTML
10/28/14 09:13:29.738 DEBUG   User Load (0.2ms) rows: 1  SELECT `users`.* FROM `users` WHERE `users`.`id` = 64 LIMIT 1
10/28/14 09:13:29.740 DEBUG   Network Load (0.3ms) rows: 0  SELECT `networks`.* FROM `networks` WHERE `networks`.`vanity_domain` IN ('.localhost') LIMIT 1
10/28/14 09:13:29.741 DEBUG   Network Load (0.3ms) rows: 1  SELECT `networks`.* FROM `networks` WHERE `networks`.`nickname` = 'invoca' LIMIT 1
10/28/14 09:13:29.743 DEBUG   OrganizationMembership Load (0.2ms) rows: 1  SELECT `organization_memberships`.* FROM `organization_memberships` WHERE `organization_memberships`.`id` = 57 LIMIT 1
10/28/14 09:13:29.744 DEBUG   Network Load (0.3ms) rows: 1  SELECT `networks`.* FROM `networks` WHERE `networks`.`id` = 1 LIMIT 1
10/28/14 09:13:29.746 DEBUG   Username Load (0.2ms) rows: 1  SELECT `usernames`.* FROM `usernames` WHERE `usernames`.`user_id` = 64 AND `usernames`.`verified` = 1 ORDER BY id ASC LIMIT 1
10/28/14 09:13:29.748 DEBUG   User Load (0.2ms) rows: 1  SELECT `users`.* FROM `users` INNER JOIN `organization_memberships` ON `users`.`id` = `organization_memberships`.`user_id` WHERE `organization_memberships`.`organization_id` = 1 AND `organization_memberships`.`organization_type` = 'Network' AND (contact_TN_verification_status IS NOT null) LIMIT 1
10/28/14 09:13:29.749 DEBUG   Username Load (0.2ms) rows: 1  SELECT `usernames`.* FROM `usernames` WHERE `usernames`.`id` = 64 LIMIT 1
10/28/14 09:13:29.751 DEBUG   Advertiser Load (0.3ms) rows: 1  SELECT `advertisers`.* FROM `advertisers` WHERE `advertisers`.`network_id` = 1 AND `advertisers`.`name` = 'Search' LIMIT 1
10/28/14 09:13:29.753 DEBUG   PartnerOauthCredentials Load (0.2ms) rows: 1  SELECT `partner_oauth_credentials`.* FROM `partner_oauth_credentials` WHERE `partner_oauth_credentials`.`organization_id` = 54 AND `partner_oauth_credentials`.`organization_type` = 'Advertiser' AND `partner_oauth_credentials`.`partner_type` = 'Adwords' LIMIT 1
10/28/14 09:13:29.754 DEBUG   LargeTextField Load (0.2ms) rows: 1  SELECT `large_text_fields`.* FROM `large_text_fields` WHERE `large_text_fields`.`owner_id` = 1 AND `large_text_fields`.`owner_type` = 'PartnerOauthCredentials'
10/28/14 09:13:32.293 INFO   Rendered pegasus/views/pegasus/search_integrations/adwords_settings.html.slim within pegasus/layouts/setup (0.4ms)
10/28/14 09:13:32.299 INFO   Rendered pegasus/views/pegasus/shared/_account_menu.html.slim (0.0ms)
10/28/14 09:13:32.302 INFO   Rendered shared/_google_analytics.html.erb (0.1ms)
10/28/14 09:13:32.302 INFO   Rendered pegasus/views/pegasus/layouts/base.html.slim (6.8ms)
10/28/14 09:13:32.302 INFO Completed 200 OK in 2564.7ms (Views: 12.9ms | ActiveRecord: 2.6ms)

##Adwords Route

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment