Accessing files stored on OpenText Content server

[gil12]

Hi There,

Does someone know how to access files stored on OpenText Content server from Power bi? 

Thanks,

[Anonymous · Accepted solution]

There's a duplicate thread I answered here: https://community.powerbi.com/t5/Developer/Opentext-Content-Server/td-p/809913 

I was able to read OpenText documents as data sources via their REST API but the solution isn't ideal as the only way I found involves hard coding the OpenText client credentials in the Power Query itself and not using the Power BI credential manager... I think because the OpenText API uses some specific/bespoke authentication that Power BI doesn't know how to work with.

[gil12]

Thanks, Owen for your help!
I have been trying to make this work since late 2019 with no success. Eventually, I have requested data sources to be moved to SharePoint rather than using OpenText, However, I'm still interested in this solution. If you can show me how you did it since I don't have experience with Rest API.

Thanks for your time and help!

[Anonymous]

No problem, at my company some I.T. staff specialized in OpenText helped by giving me a Powershell script to connect to the OpenText API that had the URLs and credentials I needed. I translated that script into Power Query which is what I posted on the other thread if you want to copy paste that as a new data source in one of your reports.

You'll probably need some help from some OpenText admin to know whether they've enabled the OpenText API and what URLs and credentials to plug into that Power Query to make it work for you. You do have to manually edit Power Query code to work with these REST APIs - it isn't quite as simple as working with Sharepoint.

[pallejohnson]

I have the same problem, with Opentext Content server

[gil12]

Could someone please help me out with this?

[Greg_Deckler]

Seems there is a REST API?
http://axcelerate-docs.opentext.com/help/axc-main/5.15/en_us/content/resources/pdf%20guides/connecto...

[gil12]

Thanks!

And would you please be kind enough to show me how can i use rest Api to retreive data from content server?

Thanks,