How to Update a Google sheet
I'm trying to insert new rows ( eg "records" ) into a Google Sheet via a (CDATA) ODBC Google Sheet DSN, but I keep on getting a "ERROR [HYC00] Optional feature not implemented From UpdateDatabase (Error)"
I Can't find out if this is a system, ThinkAutomation, ODBC or (CDATA) driver problem...
Any better idea to Update a Google sheet or a solution to this problem?
- 12 replies
- LLiam @liam_dobbs
Hi, Edwin, could you send me your trigger actions please then I can look furtherly into this.
Hi,. thx! I forgot to press "post reply" ...
See attached. I simplified it as you can see ;)
The ODBC connector I use is this one from CDATA
- In reply toliam_dobbs⬆:
Just a friendly reminder/update request.
Are you still working on this?
Apologies for the late response, could you try sending the attachment again as it isn't displaying on my end.
Kind regards Liam :)
Hello Liam, Here it is. it is just a one line where I update the database via the (CDATA, Google Sheets driver) ODBC
I cant add a attachment. Can I send it to you in another way?
- Thomas Parker @mrtopkid
Furthermore, you could try using Google's official API here: https://developers.google.com/sheets/api/guides/values
Whether this would work for your case I'm not sure I'm afraid, but it's an additional option nonetheless
- LLiam @liam
I've tried to use the CData ODBC driver and got as far as you.
I can select data fine but when trying to insert I get the same error.
Have you reached out to CData?
As I'm only using the trial I'm wondering if this is the limitation of the trial, since the error is quite specific in saying "feature not implemented"
In response to your first post: no problem, I was also busy with other things. Now back in full swing with TA!
I haven't had any contact with CDATA yet, I first want to rule out whether it could have anything to do with authorization or something like that. "HYC00" does not appear to be a CDATA, but an ODBC/SQL error. See here: https://docs.microsoft.com/en-us/sql/odbc/reference/appendixes/appendix-a-odbc-error-codes?view=sql-server-ver15
As for the API, if I had enough knowledge I might use it, but ODBC is a bit more accessible for a Low-Coder like me ;) . In addition, I use CDATA for many other links and synchronization. Important for me is the maintenance and therefore also the updates of the drivers. I don't want to have to do maintenance on APIs.
In addition to the ODBC drivers, there are also many other developer integrations mentioned. Is there something better/more universal for TA integration?
https://www.cdata.com/drivers/gsheets/#:~:text=popular developer integrations
If so, then I am willing to invest in it.