Google Sheets in Google Apps block not working

[Lisa Seeto]

An issue was found when trying to create a Google Apps block for a google spreadsheet. When pasting in the URL (https://docs.google.com/spreadsheets/d/e/2PACX-1vSLP46DGAOPhBqjp60r7qG6xy3nrHLGtikeSSVH9LqAP29A-Do5VCUDoKR0koK2EN820cbpgxcyxHWu/pubhtml) to a web browser, it had no problem displaying the document contents.

Steps to reproduce:
1. Log into Mahara as any user and navigate or create a new page you can edit
2. Select a 'Google Apps' block and in the URL/Embed input enter in: https://docs.google.com/spreadsheets/d/e/2PACX-1vSLP46DGAOPhBqjp60r7qG6xy3nrHLGtikeSSVH9LqAP29A-Do5VCUDoKR0koK2EN820cbpgxcyxHWu/pubhtml, save the block & display the page
Expected results:
The block displays the google spreadsheet information
Actual results:
The block shows an error: "The file you requested does not exist".
3. Repeat the above steps but in the URL/Embed input put in this: <iframe src="https://docs.google.com/presentation/d/e/2PACX-1vS_cNi8FtOCBaXeOz_iOMiclHMoKWTfw71ogiS3cu5-oTGcgmhT9qTj3Yg5u_dJzSfW9JaVykatXZH9/embed?start=false&loop=false&delayms=3000" frameborder="0" width="960" height="569" allowfullscreen="true" mozallowfullscreen="true" webkitallowfullscreen="true"></iframe>
4. Observe the same actual results from above.

Was tested on 21.04.dev

[Mahara Bot (dev-mahara)]

Patch for "master" branch: https://reviews.mahara.org/11831

[Mahara Bot (dev-mahara)]

Reviewed: https://reviews.mahara.org/11831
Committed: https://git.mahara.org/mahara/mahara/commit/f868e57051632b28958cddce0ef2fd3cebbe8a31
Submitter: Gold (<email address hidden>)
Branch: master

commit f868e57051632b28958cddce0ef2fd3cebbe8a31
Author: Doris Tam <email address hidden>
Date: Mon Jun 14 13:13:25 2021 +1200

Bug 1926388: Update regex (Sheets) in Google Apps block

Change-Id: I5241863a7a2ef96d6b7d17758e002dbaa76774f1

[Mahara Bot (dev-mahara)]

Patch for "21.04_STABLE" branch: https://reviews.mahara.org/11857

[Mahara Bot (dev-mahara)]

Patch for "20.10_STABLE" branch: https://reviews.mahara.org/11858

[Mahara Bot (dev-mahara)]

Patch for "20.04_STABLE" branch: https://reviews.mahara.org/11859

[Mahara Bot (dev-mahara)]

Reviewed: https://reviews.mahara.org/11858
Committed: https://git.mahara.org/mahara/mahara/commit/1afa91518515eb28906f25b3527c8c88d3b923f0
Submitter: Robert Lyon (<email address hidden>)
Branch: 20.10_STABLE

commit 1afa91518515eb28906f25b3527c8c88d3b923f0
Author: Doris Tam <email address hidden>
Date: Mon Jun 14 13:13:25 2021 +1200

Bug 1926388: Update regex (Sheets) in Google Apps block

Change-Id: I5241863a7a2ef96d6b7d17758e002dbaa76774f1
(cherry picked from commit f868e57051632b28958cddce0ef2fd3cebbe8a31)

[Mahara Bot (dev-mahara)]

Reviewed: https://reviews.mahara.org/11857
Committed: https://git.mahara.org/mahara/mahara/commit/85f66e089cef70ab815886a755d46c36d6df8487
Submitter: Robert Lyon (<email address hidden>)
Branch: 21.04_STABLE

commit 85f66e089cef70ab815886a755d46c36d6df8487
Author: Doris Tam <email address hidden>
Date: Mon Jun 14 13:13:25 2021 +1200

Bug 1926388: Update regex (Sheets) in Google Apps block

Change-Id: I5241863a7a2ef96d6b7d17758e002dbaa76774f1
(cherry picked from commit f868e57051632b28958cddce0ef2fd3cebbe8a31)

[Mahara Bot (dev-mahara)]

Reviewed: https://reviews.mahara.org/11859
Committed: https://git.mahara.org/mahara/mahara/commit/243ac3436e3349edd7119a24b3b26c210af1b605
Submitter: Robert Lyon (<email address hidden>)
Branch: 20.04_STABLE

commit 243ac3436e3349edd7119a24b3b26c210af1b605
Author: Doris Tam <email address hidden>
Date: Mon Jun 14 13:13:25 2021 +1200

Bug 1926388: Update regex (Sheets) in Google Apps block

Change-Id: I5241863a7a2ef96d6b7d17758e002dbaa76774f1
(cherry picked from commit f868e57051632b28958cddce0ef2fd3cebbe8a31)