Forum Discussion
Connect to Confluence (Atlassian)
Hi, I want to connect to one or multiple pages in Confluence where other teams update tables that are visible for anyone. I don't want to pay for custom connectors that I know are available. I'm tr...
Hi japolo
You can use Web.Contents to access Confluence API. I going to show you an example based on the following:
api-wiki-rest-api-user-current-get
The following should work to retrieve results because the User and Token can be stored in the Data Source Credentials (Basic). However you need to generate token using this Manage API tokens for your Atlassian account | Atlassian Support
let
#"Base URL" = "https://your-domain.atlassian.net/",
#"Relative Path" = "wiki/rest/api/user/current",
#"Get Data" =
Json.Document(
Web.Contents(#"Base URL",
[
RelativePath=#"Relative Path",
Headers=[Accept="application/json"]
]
)
)
in
#"Get Data"
Hi Anonymous ,
I've tried your instructions but I can't make it work. I've generated a token and tried the it but it doesn't work, i'm getting the following error:
And i replaced the base URL and relative path with the confluence page I wanted to connect to
Not sure what is missing or if it's something else.
Kind regards,
J