Forum Discussion

aworsh1's avatar
aworsh1
Regular Visitor
2 years ago

MindBodyOnline Integration with Power BI

Hello guys,

I need to connect Power BI with MindBodyOnline. I do have API and key, but while connecting it gives error. Anyone who done this in past please help.

 

api 

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi aworsh1 ,

    Please check the following links, hope they can help you.

    MINDBODY + Power BI Integration: How to connect MINDBODY to Power BI (appypie.com)

    How do I connect to REST APIs with Power BI? (Part 1) - Data with Dom

    Power BI REST API: Step-by-step Guide to Use It | Coupler.io Blog

    If the above ones can't help, could you please provide the following info?

    • Which connector you are using to connect to MindBodyOnline?
    • Which error message you got?
    • How did you set the data source info when connected? Could you please provide the screenshot(mask the sensitive info)?

    Best Regards

    • aworsh1's avatar
      aworsh1
      Regular Visitor

      Thanks for response, I have checked with appypie but they are bit costly. I need help to run API's provided by Mindbody in Power BI, following is the API which is provided by them,

      curl -X GET -G \  --url 'https://api.mindbodyonline.com/public/v6/sale/sales' \  -H 'API-Key: 6fae438201af4127a4e047c76644558'\  -H 'Accept: application/json'\  -H 'siteId: 5733176'\  -H 'authorization: authorization6' \  -d 'request.endSaleDateTime=2016-03-13T12%3A52%3A32.123Z' \  -d 'request.limit=62' \  -d 'request.offset=100' \  -d 'request.paymentMethodId=140' \  -d 'request.saleId=32' \  -d 'request.startSaleDateTime=2016-03-13T12%3A52%3A32.123Z'

      I just need to know where I will put all these parameters and this text to get the data.?

      • aworsh1's avatar
        aworsh1
        Regular Visitor

        I have applied the url and headers as per attached image,

        Upon connecting, I am getting this error,