Forum Discussion

Veternus's avatar
Veternus
Frequent Visitor
2 years ago
Solved

API Connection (Sprinklr)

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!

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.