Hello,
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?
Edwin
- LLiam @liam_dobbs
Hi, Edwin, could you send me your trigger actions please then I can look furtherly into this.
Thanks :)- Iisedwinr @isedwinr
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
https://www.cdata.com/drivers/gsheets/odbc/regards,
Edwin
- 回复liam_dobbs⬆:Iisedwinr @isedwinr
Hello Liam,
Just a friendly reminder/update request.
Are you still working on this?regards,
Edwin
- LLiam @liam_dobbs
Hello Edwin,
Apologies for the late response, could you try sending the attachment again as it isn't displaying on my end.
Kind regards Liam :)
- Iisedwinr @isedwinr
Hello Liam, Here it is. it is just a one line where I update the database via the (CDATA, Google Sheets driver) ODBC
- Iisedwinr @isedwinr
I cant add a attachment. Can I send it to you in another way?
- Iisedwinr @isedwinr
here's a download link if thats ok
https://drive.google.com/file/d/1nLqjNObesoxxXuaCFSjIvPoBH2dgu_fx/view?usp=sharing- LLiam @liam_dobbs
Thank you Edwin :)
回复isedwinr⬆:Thomas Parker @mrtopkidHi Edwin,
Apologies for the wait on this one. Have you made any progress since the last correspondence?
Can you tell me what documentation you followed? I'll attempt to test this myself
- 回复isedwinr⬆:Thomas Parker @mrtopkid
Hi Edwin,
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
- L回复isedwinr⬆:Liam @liam
Hi Edwin
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"- Iisedwinr @isedwinr
Hi Thomas,
In response to your first post: no problem, I was also busy with other things. Now back in full swing with TA!
I followed the basic procedure mentioned in the docs here: https://www.cdata.com/drivers/gsheets/docs/
and then specifically for ODBC this https://cdn.cdata.com/help/RLG/odbc/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.Edwin
- C回复isedwinr⬆:Conor 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?
- Iisedwinr @isedwinr
Hi Conor,
It now works for me via a CDATA/ODBC driver.
Maybe I can help you, what is the situation you ran into?
Edwin
- CConor McGivern @conormcgivern
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.
- Iisedwinr @isedwinr
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:
https://zapier.com/help/doc/finding-and-updating-rows-in-google-sheetsI'm working on a automation with Sheets directly, if I found out I will post the method.
https://developers.google.com/sheets/api/reference/rest?hl=en_US
- 进展
- LLiam @liam
Hi Edwin
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".
- Iisedwinr @isedwinr
Hello Liam,
No problem at all, I will contact CDATA
Thanks anyway!
Edwin