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 
General Comment
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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
    2 years ago

    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
      2 years ago

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

      Upon connecting, I am getting this error,