Forum Discussion
Opentext Content Server
I have used documents in OpenText from Power BI via the OpenText REST API... but the problem I have is I need to hard code the API credentials in the Power Query code and I haven't found a way to integrate with Power BI's credential manager. The Power Query I used to open an Excel file from OpenText was (substitute in the username, password and appropriate OpenText API URLs and document ID for your org):
let
GetJson = Web.Contents("https://<opentext auth server>/authentication/credentials",
[
Headers = [#"Content-Type"="application/json"],
Content = Text.ToBinary("{""user_name"":""<user>"", ""password"":""<password>""}")
]
),
FormatAsJson = Json.Document(GetJson),
Ticket = FormatAsJson[ticket],
DocID = "1234567",
ExcelFile = Web.Contents("https://<opentext api server>/api/v1/nodes/" & DocID & "/content",
[
Headers = [#"OTDSTicket"=Ticket]
]
),
ExcelWorkbook = Excel.Workbook(ExcelFile)
in
ExcelWorkbook
If someone has a better way that doesn't have hard coded credentials I'd really appreciate that.
Hi Anonymous,
Thanks for your suggestion. Can you please give me the steps here so that I can try to connect Power BI Desktop to my Content Server 10 Service Pack 2 (Content Server 10 Update 2014-12 (version 10.0.0.3187).
Anyone out there has a better solution to connect Power BI Desktop to Content Server?
My requirement is... to report an audit log/trail of all the User's Firstname, Lastname, Name, Last Login and any other such details so that I can Deactivate User if they haven't been accessing Content Server system since 01 Feb 2021.
Thanks for your time in advance.
Kind regards, C