400 Bad request on google sheets iframe

Resolved faedrielle
(@faedrielle)

4 months, 2 weeks ago
Hi, thank you for the awesome plugin and huge knowledge base.

I’m trying to embed a Google Sheets sheet:
https://docs.google.com/spreadsheets/d/e/2PACX-1vRVfOnYjOwdkfnSAhCezQXkrAntZSVRnOT0islDmSOo1yd-EVl1EU9oIEztOLXoFdkX8ZPd0dEBdHjU/pubhtml?gid=0&single=true

Here’s the generated shortcode:
[advanced_iframe use_shortcode_attributes_only=”true” src=”https://docs.google.com/spreadsheets/d/e/2PACX-1vRVfOnYjOwdkfnSAhCezQXkrAntZSVRnOT0islDmSOo1yd-EVl1EU9oIEztOLXoFdkX8ZPd0dEBdHjU/pubhtml?gid=0&single=true” width=”100%” height=”750″ style=”max-width: 100%; max-height: 750px;” title=”gdocs-program-thursday”]

Now the issue is, Google Sheets returns a 400 Bad Request error (in Czech the text means that currently the file could not be opened):

Now, when I embed this same link via other tools (the native [embed] blocks or EmbedPress), the iframe loads up just fine. The issue there is that it’s impossible to use it on mobile, because the iframe height gets decreased proportionately with the width, so on mobile you can see like the first three rows of the sheet.

I wanted to use your plugin because you allow to specify the max-height style attribute which should fix this responsivity issue. I am just fine with specifying it in pixels.

I’m using BeTheme.
- This topic was modified 4 months, 2 weeks ago by faedrielle.
The page I need help with: [log in to see the link]

Viewing 7 replies - 1 through 7 (of 7 total)

Plugin Author mdempfle
(@mdempfle)

4 months, 2 weeks ago

I checked

https://docs.google.com/spreadsheets/d/e/2PACX-1vRVfOnYjOwdkfnSAhCezQXkrAntZSVRnOT0islDmSOo1yd-EVl1EU9oIEztOLXoFdkX8ZPd0dEBdHjU/pubhtml?gid=0&single=true

and it work fine on my iframe checker:
https://www.tinywebgallery.com/blog/advanced-iframe/free-iframe-checker

When I check your shortcode it seems the src is not closed properly.

Best regards, Michael

Thread Starter faedrielle
(@faedrielle)

4 months, 2 weeks ago

You are correct, i must have messed it up while copying here, or perhaps the text editor interpreted the quote?

Nonetheless, I regenerated the shortcode and here it is without any changes, the problem persists:

[advanced_iframe use_shortcode_attributes_only="true" src="https://docs.google.com/spreadsheets/d/e/2PACX-1vRVfOnYjOwdkfnSAhCezQXkrAntZSVRnOT0islDmSOo1yd-EVl1EU9oIEztOLXoFdkX8ZPd0dEBdHjU/pubhtml?gid=0&single=true" width="100%" height="750" style="max-width: 100%; max-height: 750px;" title="gdocs-program-thursday"]

Plugin Author mdempfle
(@mdempfle)

4 months, 2 weeks ago

If I open the url from your page outside it also doe not work:

https://docs.google.com/spreadsheets/d/e/2PACX-1vRVfOnYjOwdkfnSAhCezQXkrAntZSVRnOT0islDmSOo1yd-EVl1EU9oIEztOLXoFdkX8ZPd0dEBdHjU/pubhtml?single=true

Best regards, Michael

Thread Starter faedrielle
(@faedrielle)

4 months, 2 weeks ago

Yes it does, it opens the google sheet… see screenshot

View post on imgur.com

Thread Starter faedrielle
(@faedrielle)

4 months, 2 weeks ago

I notice that the link you sent last is missing the gid=0 parameter (second to last) – compare with https://docs.google.com/spreadsheets/d/e/2PACX-1vRVfOnYjOwdkfnSAhCezQXkrAntZSVRnOT0islDmSOo1yd-EVl1EU9oIEztOLXoFdkX8ZPd0dEBdHjU/pubhtml?gid=0&single=true

Thread Starter faedrielle
(@faedrielle)

4 months, 2 weeks ago

OK so I’ve figured it out. Your plugin is probably parsing the ampersand in between the parameters gid and single, instead of taking the full url – when i use this shortcode, it loads up the iframe (notice the skipped ampersand)

[advanced_iframe use_shortcode_attributes_only=”true” src=”https://docs.google.com/spreadsheets/d/e/2PACX-1vRVfOnYjOwdkfnSAhCezQXkrAntZSVRnOT0islDmSOo1yd-EVl1EU9oIEztOLXoFdkX8ZPd0dEBdHjU/pubhtml?gid=0single=true” width=”100%” height=”750″ style=”max-width: 100%; max-height: 750px;” title=”gdocs-program-thursday”]

I will leave it like this, could you please notify me once you fix it, so that i can update my shortcodes?

Plugin Author mdempfle
(@mdempfle)

4 months, 2 weeks ago

I found the problem.

parameters with 0 are removed.

e.g. gid=0 is removed
gid=23 is not removed.

I check and provide a update asap.

Best regards,

Michael

Viewing 7 replies - 1 through 7 (of 7 total)

You must be logged in to reply to this topic.

Views