Problem/Motivation

When I use json urls like : https://spreadsheets.google.com/feeds/list/[GOOGLESHEETID]/[SHEETPAGE]/public/values?alt=json
Google answers me:
Google Sheets 4 API

Proposed resolution

I made a patch to use the format of the json returned by Google Sheets v4 API.
The new format for json urls is: https://sheets.googleapis.com/v4/spreadsheets/[GOOGLESHEETID]/values/[SHEETPAGENAME]?key=[APIKEY]

CommentFileSizeAuthor
#5 migrate_google_sheets-google_sheets_v4_api-3236814-5.patch10.55 KBkarlshea
#3 migrate_google_sheets-google_sheets_v4_api-3236814-3.patch2.39 KBjkruppa
#2 migrate_google_sheets-google_sheets_v4_api-3236814-2.patch2.48 KBslayne40
GoogleSheetsV4API.png57.36 KBslayne40

Comments

slayne40 created an issue. See original summary.

slayne40’s picture

slayne40 commented
StatusFileSize
new migrate_google_sheets-google_sheets_v4_api-3236814-2.patch2.48 KB
jkruppa’s picture

jkruppa commented
StatusFileSize
new migrate_google_sheets-google_sheets_v4_api-3236814-3.patch2.39 KB

Thanks @slayne40 your patch worked well for us!
I just upload a new one with relative paths, making it usable with composer.

karlshea’s picture

karlshea
he/him
Primary language English
Location Minneapolis 🇺🇸
commented
Status: Active » Reviewed & tested by the community

Works for me!

karlshea’s picture

karlshea
he/him
Primary language English
Location Minneapolis 🇺🇸
commented
Version: 8.x-1.x-dev » 2.0.0
StatusFileSize
new migrate_google_sheets-google_sheets_v4_api-3236814-5.patch10.55 KB

Updated docs for urls inside example migrations

brendanthinkshout’s picture

brendanthinkshout commented
Assigned: Unassigned » brendanthinkshout
brendanthinkshout’s picture

brendanthinkshout commented

This patch seems good to go on its own merits, but trying to test it with the example migration setup has exposed some deep weird issues with the core migrate module and how it handles data coming from Google. Will write up a blocker issue.

  • KarlShea committed eeaa9f27 on 2.x 
    Issue #3236814 by slayne40, KarlShea, greenjuls: Google Sheets v4 API
karlshea’s picture

karlshea
he/him
Primary language English
Location Minneapolis 🇺🇸
commented
Status: Reviewed & tested by the community » Fixed

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.