Connection failed when trying to connect to self hosted Grist

Hi, happy to see the integration with Grist, match made in heaven to have both open source spreadsheets server you can self host as well as an open source integrator service, makes us Europeans lives easier with GDPR and so on.

While trying to connect ActivePieces cloud version to my Grist instance, I ran into an issue where i get the following error:

image

I am using the URL of my grist instance, same URL I open the application via, and the API key from my Profile Settings page.

Has anybody tried connecting to a self hosted Grist instance that maybe know what I could be missing?

Cheers!

Hello @Bastiat , Welcome to the community :wave:,

In the “Domain” field, please enter the domain URL without a trailing backslash (/) and ensure that the correct API key is provided. If you are accessing a team site, include the team site URL in the “Domain” field.

I also did as you said and it still does not work. I have copied my API key multiple times. I added the URL we visit each day without the trailing slash. I am still getting an error message. Why am I getting an error?

Hello @JennB , Welcome to the community :wave:,

Could you try this cURL command with your API key and domain URL, and send the response or any errors to me via DM? It will be helpful for troubleshooting the issue.

curl --location 'https://docs.getgrist.com/api/orgs/current/workspaces' \
--header 'Authorization: Bearer apikey'

I am not sure if this is what you needed or helpful. But here is what I got.

You can try this alternative approach by adding the HTTP step as shown in the image.