No internet connection
  1. Home
  2. Questions

How to Update a Google sheet

By Edwin Rooijakkers @isedwinr
    2021-09-30 08:48:51.675Z

    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

    • 12 replies
    1. L
      Liam @liam_dobbs
        2021-10-01 13:35:41.414Z

        Hi, Edwin, could you send me your trigger actions please then I can look furtherly into this.
        Thanks :)

        1. IEdwin Rooijakkers @isedwinr
            2021-10-05 15:59:15.784Z

            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

            1. In reply toliam_dobbs:
              IEdwin Rooijakkers @isedwinr
                2021-10-20 15:59:13.604Z

                Hello Liam,
                Just a friendly reminder/update request.
                Are you still working on this?

                regards,

                Edwin

                1. LLiam @liam_dobbs
                    2021-11-15 09:38:11.627Z

                    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 :)

                    1. IEdwin Rooijakkers @isedwinr
                        2021-11-18 16:38:33.563Z

                        Hello Liam, Here it is. it is just a one line where I update the database via the (CDATA, Google Sheets driver) ODBC

                        1. IEdwin Rooijakkers @isedwinr
                            2021-11-18 16:39:12.471Z

                            I cant add a attachment. Can I send it to you in another way?

                            1. IEdwin Rooijakkers @isedwinr
                                2021-11-19 08:05:06.703Z
                                1. LLiam @liam_dobbs
                                    2021-11-23 18:46:10.286Z

                                    Thank you Edwin :)

                        2. In reply toisedwinr:
                          Thomas Parker @mrtopkid
                            2021-12-10 12:13:44.405Z

                            Hi 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

                            1. In reply toisedwinr:
                              Thomas Parker @mrtopkid
                                2021-12-10 12:15:38.608Z

                                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

                                1. L
                                  In reply toisedwinr:
                                  Liam @liam
                                    2021-12-10 14:28:05.053Z

                                    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"

                                    1. IEdwin Rooijakkers @isedwinr
                                        2021-12-12 07:11:33.067Z

                                        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