Some form quries are not sent to google sheet file
-
I set the plugin up and everything seemed to be working, but then I noticed that some of the entries were missing from the drive file.
I didn’t see any errors in plugins log file, so I added some of my own logging lines to the plugin. It seems that google sheet service throws quota exceeded error sometimes, I guess because the connected API service account is used on all plugin instances.
(
[ERROR_MSG] => {
"error": {
"code": 429,
"message": "Quota exceeded for quota metric 'Read requests' and limit 'Read requests per minute' of service 'sheets.googleapis.com' for consumer 'project_number:1075324102277'.",
"errors": [
{
"message": "Quota exceeded for quota metric 'Read requests' and limit 'Read requests per minute' of service 'sheets.googleapis.com' for consumer 'project_number:1075324102277'.",
"domain": "global",
"reason": "rateLimitExceeded"
}
],
"status": "RESOURCE_EXHAUSTED",
"details": [
{
"@type": "type.googleapis.com/google.rpc.ErrorInfo",
"reason": "RATE_LIMIT_EXCEEDED",
"domain": "googleapis.com",
"metadata": {
"service": "sheets.googleapis.com",
"quota_limit": "ReadRequestsPerMinutePerProject",
"consumer": "projects/1075324102277",
"quota_metric": "sheets.googleapis.com/read_requests",
"quota_limit_value": "300",
"quota_location": "global"
}
},
{
"@type": "type.googleapis.com/google.rpc.Help",
"links": [
{
"description": "Request a higher quota limit.",
"url": "https://cloud.google.com/docs/quota#requesting_higher_quota"
}
]
}
]
}
}
[TRACE_STK] => #0 htdocs/wp-content/plugins/gsheetconnector-gravity-forms/lib/src/Http/REST.php(107): Google\Http\REST::decodeHttpResponse(Object(GuzzleHttp\Psr7\Response), Object(GuzzleHttp\Psr7\Request), 'Google\\Service\\...')
#1 [internal function]: Google\Http\REST::doExecute(Object(GuzzleHttp\Client), Object(GuzzleHttp\Psr7\Request), 'Google\\Service\\...')
#2 htdocs/wp-content/plugins/gsheetconnector-gravity-forms/lib/src/Task/Runner.php(187): call_user_func_array(Array, Array)
#3 htdocs/wp-content/plugins/gsheetconnector-gravity-forms/lib/src/Http/REST.php(66): Google\Task\Runner->run()
#4 htdocs/wp-content/plugins/gsheetconnector-gravity-forms/lib/src/Client.php(915): Google\Http\REST::execute(Object(GuzzleHttp\Client), Object(GuzzleHttp\Psr7\Request), 'Google\\Service\\...', Array, NULL)
#5 htdocs/wp-content/plugins/gsheetconnector-gravity-forms/lib/src/Service/Resource.php(238): Google\Client->execute(Object(GuzzleHttp\Psr7\Request), 'Google\\Service\\...')
#6 htdocs/wp-content/plugins/gsheetconnector-gravity-forms/lib/vendor/google/apiclient-services/src/Sheets/Resource/SpreadsheetsValues.php(240): Google\Service\Resource->call('get', Array, 'Google\\Service\\...')
#7 htdocs/wp-content/plugins/gsheetconnector-gravity-forms/lib/google-sheets.php(186): Google\Service\Sheets\Resource\SpreadsheetsValues->get('17YMGJOOEympn50...', 'Lehe Hindamine ...')
#8 htdocs/wp-content/plugins/gsheetconnector-gravity-forms/class-gf-gsheetgravityforms.php(880): Gfgsc_googlesheet->add_row(Array)
#9 htdocs/wp-content/plugins/gsheetconnector-gravity-forms/class-gf-gsheetgravityforms.php(815): Gforms_Gsheet_Connector->send_entry('17YMGJOOEympn50...', 'Hindamise p\xC3\xA4ri...', '688186784', 'Lehe Hindamine', Array, Array)
#10 htdocs/wp-includes/class-wp-hook.php(310): Gforms_Gsheet_Connector->after_submission(Array, Array)
#11 htdocs/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters('', Array)
#12 htdocs/wp-includes/plugin.php(517): WP_Hook->do_action(Array)
#13 htdocs/wp-content/plugins/gravityforms/gravityforms.php(6606): do_action('gform_after_sub...', Array, Array, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
#14 htdocs/wp-content/plugins/gravityforms/form_display.php(169): gf_do_action('gform_after_sub...', Array, Array)
#15 htdocs/wp-content/plugins/gravityforms/gravityforms.php(760): GFFormDisplay::process_form(3)
#16 htdocs/wp-includes/class-wp-hook.php(308): GFForms::maybe_process_form(Object(WP))
#17 htdocs/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters(NULL, Array)
#18 htdocs/wp-includes/plugin.php(565): WP_Hook->do_action(Array)
#19 htdocs/wp-includes/class-wp.php(797): do_action_ref_array('wp', Array)
#20 htdocs/wp-includes/functions.php(1332): WP->main('')
#21 htdocs/wp-blog-header.php(16): wp()
#22 htdocs/index.php(17): require('/data02/virt128...')
#23 {main}
)Is this a excepted way it is supposed to work on the free plugin?
Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
- The topic ‘Some form quries are not sent to google sheet file’ is closed to new replies.