feed-me
feed-me copied to clipboard
craftcms
"Invalid data: Syntax error" When Importing a Google Sheet
Cannot import from a google sheet into a nitro dev site, get error "Invalid data: Syntax error"
This isn't very descriptive and doesn't tell me what needs to be fixed.
Craft: 3.7.16 Feedme: 4.4.0
Same here. I'm hopeful that @brandonkelly and team could look into this. Issues like this don't typically sit in limbo like this but I'm sure the P&T folks have a bit going on with 4 on its way.
@brandonkelly I have nothing in the logs that cites anything specific, at least not that I can find. I haven't done the import in about 6 months. Perhaps @green17 or @DynamiteGoesBoom has a more recent try to localize.
@brandonkelly Sadly there's nothing really in the logs about this. How should we proceed? The client really needs this corrected otherwise we'll need to redo all of the feeds to utilize CSV or JSON which isn't ideal. Even when I strip all of the 400+ rows of data out of the Google Sheet (leaving one row with very basic data in it) I still get a syntax error from FeedMe. I always sort of felt like the error reporting inside of FeedMe has been lacking in the past, but never quite experienced this one before. I wish I could be of more help here and I'd be happy to provide any details that you and the P&T team need to help resolve this one!
@DynamiteGoesBoom can you write in to [email protected] with a database dump, composer.json/lock files and a sample Google Sheet where we can try to reproduce the error locally?
Also just hitting this error, running the following:
Feed Me: 4.4.1.1 Craft CMS: 3.7.16
Checked the logs but they are just returning {"date":"2022-04-27 11:19:09","type":"error","message":"Invalid data: Syntax error"}
I've tried importing with a completely empty Google Sheet too, and the same error occurs.
Very odd!
@angrybrad just wondering if you can offer me some help / additional info on this? Client is chasing to get this resolved. Cheers!
@iamtompickering In @DynamiteGoesBoom's case, it was a case of bad data. There were 35 "headers" in that feed based on the first row, but a subset of rows had 36 columns of data, which caused Feed Me to choke on the extra column that had no header.
Just double check that your URL is in the form of https://sheets.googleapis.com/v4/spreadsheets/long-id/values/sheet?key=api-key. The UI doesn't tell you about that, it's in the documentation.
