API Connection (Sprinklr)

[Veternus]

Hello everyone!

I've been racking my brain over the last week trying to integrate the Sprinklr app with my report in Power BI. I've reached the stage where:

• I have the API key, Access Token, JSON Body, and all other necessary values from Sprinklr.
• I made the first API Call on Postman.

However, I'm not sure how to proceed in Power BI?

I tried going to Sources > Web > Enter the web address provided by Sprinklr > Web API > enter the key. It shows an error: "A web API key can only be specified when a web API key name is provided."

I found a description of a solution here on the forum where, instead of clicking on Web Api, we click on Basic, enter the API key into Username, and click Connect. Then it shows an error:

"We encountered an error while trying to connect. Details: 'Web.Contents failed to get contents from 'https://.........' (596): 596'"

Does anyone have experience with this and could offer some advice? If someone had the exact form of the code that I could write into the Advanced Editor, that would be perfect.

Thank you and have a great day!

[Anonymous · Accepted solution]

Hi  @Veternus ,

I have found a document about connect to Sprinklr app. Please refer to: 

‎Power BI Connector | Sprinklr Help Center

1. Launch Power BI Desktop, click Get Data in the toolbar and click More. 

2. In the Get Data pop-up window, search for and select the Spark connector. 

3. Click Connect in the Get Data pop-up window.

4. In the Spark pop-up window, fill in the required details to configure your environment details.

5. Click Ok in the bottom right corner of the Spark pop-up window. Next, enter the User name and Password details to log in to Sprinklr.

6. Click Connect in the bottom right corner of the Spark pop-up window. The Power BI Navigator should display the data available for query in your Sprinklr Data Source.

I have also found a similar post, please refer to.

Solved: Set API Key from Cell Value - Microsoft Fabric Community

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details.

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.