Plugin generating response code 400 errors

  • Resolved sipitai

    (@sipitai)


    7 years, 3 months ago

    Hi Dan,

    Your plugin doesn’t seem to be working for me.

    I’ve setup a fresh install of WordPress, with just your plugin installed.

    I’ve created a test Google Sheet with some basic test data, and set it’s sharing permissions to “Anyone on the internet can find and edit”.

    I’ve created a project via the Google Developers Console and created an API key.

    It’s worth noting both the Google Sheet and project were created using the same Google account.

    I’ve filled in the API Key and Folder ID fields in the plugin settings.

    I’ve created a page and added the [dansheet] shortcode.

    But when I view the page it doesn’t display anything. Looking at the HTML it’s just outputting <span class="gsheets-single-value "></span>

    I double checked everything, but I couldn’t spot any mistakes.

    To test I enabled the Google Sheets API for my Google account. This didnt fix the problem, but it gave me access to Traffic and Errors panels, which note the plugin is generating response code 400 errors via the method ‘google.apps.sheets.v4.SpreadsheetsService.GetValues’.

    I’m assuming here is that the plugin no longer works with either the latest version of the Google Sheets API or WordPress, but it’s possible I’ve setup something incorrectly.

    Any ideas what the problem might be here? I’m happy to provide you with logins in required.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Dan D

    (@duplaja)

    Hello! I have updated everything on my test server, and it seems to be working ok. Would it be possible for you to share the sheet ID that you are using, so I can try to track this down?

    Thanks!

    Dan

    Plugin Author Dan D

    (@duplaja)

    We were able to track this down, for anyone who reads this. The confusion came from the sheetname parameter, from some ambiguity on the naming of things in Google Sheets. The sheetname parameter is for the “tab” name at the bottom, not the name of the document itself.

    Thread Starter sipitai

    (@sipitai)

    Thanks again Dan!

    Further to what Dan’s said above, when using the [dansheet] shortcode, you must set the ‘cell’ parameter.

    Just [dansheet] by itself wont return any cells, but [dansheet cell=A1:E5] for example will.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Plugin generating response code 400 errors’ is closed to new replies.