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?
- 19 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.
- CConor McGivern @conormcgivern
HI - i am having a similar issue with trying to link up TA with Google Sheets. Wondering if there is any update on a Custom Action?
It now works for me via a CDATA/ODBC driver.
Maybe I can help you, what is the situation you ran into?
sounds promising - although i have not used a CDATA/ODBC driver before. Essentially we currently receive webleads via email. I have used TA to extract the name & contact details and update our database. I also want to update a google sheet with the name and telephone number if possible.
OK, you can also do that with a simple Zap. It's not high-end but it works fine for most situations
First activate a Email -to-Sheets or POST request to Zapier via TA and then use this:
I'm working on a automation with Sheets directly, if I found out I will post the method.
Apologies, I missed your response in December, I don't have anything really for this currently.
The developers will look into making a custom action for Google Sheets but this isn't likely to be available anytime soon.
For your issue with the CData driver, I'd probably reach out to CData, as I can only get a trial version it isn't something I can test completely but the error looks more like an issue with the CData driver, "feature not implemented".