Join N8N and Grist (both runtipi hosted)
I will freely admit I don't have full confidence in my understanding of how things work in the back end of runtipi, so I am a bit unsure on how to proceed from a sticking point I have hit.
I use N8N for a number of things and am newly setting up grist, I have created my grist API key and created the credential in n8n and test says successful. Note that on my grist app i have runtipi authentication enabled.
When I try to use a n8n grist node to either write or read from a table it just fails "TypeError: Cannot read properties of undefined (reading 'map')"
When trying to setup the create item in table task it can't pull the properties list through etc.
I am assuming it has something to do with the runtipi authentication layer. So am looking for 1 of 2 ideas I can think of to solve it. 1 would be creating some other direct connection from n8n to grist that doens't require using it's public facing url, the 2nd is figuring out how to enable authentication in grist itself and dropping the runtipi auth from it... although i could be completly wrong with my assumption of the issue.
any ideas?
2 Replies
1. When I want apps to communicate together, I like using the internal docker network.
You just need to use this url format : http://app:port (internal port)
In this case : http://grist:8484
But since Grist only allow one domain you will need to add this in user-config :
It will basically tell to listen on this url for API calls.
This works fine on my side
2. If you want to restrict access, you can also set
GRIST_FORCE_LOGIN to true.
If you want to go further, you should take a look at the list of environment variables on the Readme of the project :
https://github.com/gristlabs/grist-coreGitHub
GitHub - gristlabs/grist-core: Grist is the evolution of spreadsheets.
Grist is the evolution of spreadsheets. Contribute to gristlabs/grist-core development by creating an account on GitHub.
cheers, i will try this out when i get some time (hopefully this weekend) and see how i go 🙂
thank you @Skullky , that worked! I had to edit it slightly to be: