addRow with id

[dhoeric]

Hi all,

I cannot addRow with a column name id, is there any reserved word in column name?

sheet.addRow({
        'id': 333,
        ...
});

[Voronchuk]

Hey, just in case you plan to do anything with the created row object, this maybe useful for you.

[theoephraim]

This has been a known limitation for quite a while. Now that I have a decent test suite, I'll see about tackling this problem!

[dhoeric]

Thanks for replying, I have just create another column (SELECT *, id AS another_id FROM ...) to workaround.

[odub]

I also just hit this problem. It would be nice to get an error if id is a reserved word.

[mddanishyusuf]

I also faced this issues but I use 'Id' and it's worked for me.

[theoephraim]

I've just a published a new version of this module which is a complete rewrite using Google's V4 Sheets API (v3 is being deprecated on March 3, 2020). YOU MUST MIGRATE IF YOU ARE STILL USING THIS PACKAGE!

Docs available here - https://theoephraim.github.io/node-google-spreadsheet

I do believe this issue should be fixed in the new version.
Please test it out and if you find that there is still a problem, reopen the issue.

Thanks! 😄