Access to Medallia with APIs

Question

Hi team ... anyone with experience accessing Medallia system through APIs? I already have the credentials and I´m looking for some tips to expedite the process on my side. Thanks

gdecome · Answer

Hi&nbsp;Anonymous,&nbsp;API is working fine. See the example below. You can find more information about what to use in sqlQuery in Medallia documentation for API&nbsp;1) Create a function in Power Query (e.g. fnGetData)&nbsp;let&nbsp;&nbsp;&nbsp; GetData = (sqlQuery) =&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;let&nbsp;&nbsp;&nbsp; authURL = "https://XXXXX.medallia.com/oauth/XXXXX/token",&nbsp;&nbsp;&nbsp; body = "grant_type=client_credentials&amp;scope=-d&amp;client_id=XXXXX&amp;client_secret=XXXXX",&nbsp;&nbsp;&nbsp; // Get Token ----------------------------------&nbsp;&nbsp;&nbsp; getToken = Json.Document(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Web.Contents(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; authURL,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Headers=[#"Content-Type"="application/x-www-form-urlencoded"],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Content=Text.ToBinary(body)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;token = getToken[access_token],&nbsp;&nbsp;&nbsp; // Get Data ------------------------------------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;urlRequest = "https://XXXXX.apis.medallia.com/data/v0/mql",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;rawData = Csv.Document(&nbsp; Web.Contents(&nbsp; &nbsp;&nbsp;&nbsp; urlRequest,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Headers=[Authorization="Bearer " &amp; token ],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Query=[company="XXXXX",output="csv",version="1",query=sqlQuery]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; ]&nbsp; )&nbsp; )&nbsp;&nbsp;&nbsp; in&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rawDatain&nbsp;&nbsp;&nbsp;&nbsp;GetData&nbsp;&nbsp;Example of Query to use the function above&nbsp;let&nbsp;&nbsp;&nbsp; sqlQuery = "SELECT COUNT(*) FROM survey",&nbsp;&nbsp;&nbsp; Source = fnGetData(sqlQuery),&nbsp;&nbsp;&nbsp; #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true])in&nbsp;&nbsp;&nbsp; #"Promoted Headers"&nbsp;

anonymous · Answer

If you use sqlQuery = "describe table survey", it'll be possible to find all keys that you want&nbsp;&nbsp;Thank you for your post&nbsp;gdecome,&nbsp;it was very useful

v-frfei-msft · Answer

Hi gdecome ,
&nbsp;
To be honest, I have no experience of that.&nbsp;
Maybe You can come up a new idea and add your comments there to make this feature coming sooner.
https://ideas.powerbi.com/forums/265200-power-bi-ideas
&nbsp;

gdecome · Answer

Thank you ... in fact a connector would be good, but the API works. Just trying to find someone who could give some tips on how to use them.

anonymous · Answer

Hi&nbsp;gdecome&nbsp;did you find a solution for this issue?&nbsp;I'm also trying to connect Medallia to Power BI. In the absence of a connector, a connection via API could be a solution like you said.

Forum Discussion

Access to Medallia with APIs

10 Replies

Related content

SharePoint Access

Dashboard Access

Connection Access

Mobile app access blocked

Accessing one lake