Coda Integration [GOT CREATED]

@ajayjohn glad you liked it. Will check it out the “push button” soon to see what I can do.

1 Like

@RicardoE105 One more request that I just want to leave here for your consideration…
Could you please add a provision to be able to search/filter rows using Coda formulas, when fetching rows in a table?

@ajayjohn just added the push-button operation and added the property query so that you can filter the rows but not sure if that can be used with formulas. The documentation says:

Query is used to filter returned rows, specified as <column_id_or_name>:<value> . If you’d like to use a column name instead of an ID, you must quote it (e.g., "My Column":123 ). Also, note that value is a JSON value; if you’d like to use a string, you must surround it in quotes (e.g., "groceries" ).

There are two more endpoints about formulas but just to retrieve a list of them.

That should be more than sufficient! Thanks again! :smiley:
Can’t wait for this to be released in the next version.

1 Like

@RicardoE105
Could you please clarify how I can pass individual row cell values for Coda, when creating a new row? I was unable to find a parameter for this and setting values as an array and passing it to the node didn’t work either.

@ajayjohn the data must come in the input data you provide for that node and using the key Column you reference the property that contains the data.

I Do not have my laptop right know but can send an example when I have it.

2 Likes

Here an example for what @RicardoE105 described which assumes that assumes that you have two columns in the table named “Name” and “Email”:

{
  "nodes": [
    {
      "parameters": {
        "docId": "",
        "tableId": "",
        "options": {}
      },
      "name": "Coda",
      "type": "n8n-nodes-base.Coda",
      "typeVersion": 1,
      "position": [
        594,
        273
      ],
      "credentials": {
        "codaApi": ""
      }
    },
    {
      "parameters": {
        "functionCode": "return [\n  {\n    json: {\n      Name: 'new',\n      Email: '[email protected]'\n    }\n  },\n  {\n    json: {\n      Name: 'new2',\n      Email: '[email protected]'\n    }\n  }\n];"
      },
      "name": "Function",
      "type": "n8n-nodes-base.function",
      "typeVersion": 1,
      "position": [
        394,
        273
      ]
    }
  ],
  "connections": {
    "Function": {
      "main": [
        [
          {
            "node": "Coda",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
2 Likes

Thanks a lot for the prompt responses, @RicardoE105 and @jan.
The node works perfectly for me now :slight_smile:

2 Likes

@jan, @RicardoE105,
I am absolutely loving the way I can automate operations in Coda as a platform! In fact using a combination of webhooks, IFTTT and the Coda node, I was just able to add new rows to my tables via voice commands to my Google Home/Assistant :slight_smile:

If possible, could you please consider the following calls in your roadmap? I know Update/Insert, Delete rows are possible, but many of the other calls in this list are also immensely useful. It would be fantastic to have them work, in order to get a fully featured Coda integration available.

https://coda.io/developers/apis/v1beta1#tag/Views ()
https://coda.io/developers/apis/v1beta1#tag/Columns ()
https://coda.io/developers/apis/v1beta1#tag/Formulas ()
https://coda.io/developers/apis/v1beta1#tag/Controls ()
https://coda.io/developers/apis/v1beta1#tag/Rows (some operations here are already supported, but not all)

In the mean time, I am also working with Coda support to get webhooks exposed for events like ‘new row created’. Hopefully that should allow us to have a Coda trigger too.

@ajayjohn I just finished all the features you asked for above. As always @jan will let you know when is released.

2 Likes

Already? :open_mouth:
And here I was, requesting that you add this to your roadmap! :laughing:

Thanks a ton, @RicardoE105!

1 Like

@jan Do you know when the next version of n8n will be released? I am eagerly waiting to use the horde of new features that Ricardo just added to this node :slight_smile:

Yes, I try to release it today or tomorrow.

1 Like

Got released with [email protected]

1 Like

Hi all! I got this announcement from Coda that they launched a new API:

Maybe the implemented integration will be deprecated by August 21, 2020.

Welcome to the community @Welley!

Thanks a lot for informing us about it. We will have a look and make sure to release a version which uses the correct API.

Nice! Thanks!

Got changed and will be released with the next version:

1 Like

Got released with [email protected]

1 Like

Wow! Really fast!