question

chrisbevan avatar image
chrisbevan asked cm-brilliant answered

Has anyone used Clover's Rest API to get data into Power BI or any database?

Hi all,

Has anyone been successful in getting Clover data into Power BI or any database? I have tried to use the Rest API connection in Power BI with the below URL with no luck.

https://api.clover.com/v3/merchants/[... ID]/orders

In Power BI once you identify the web address you are simply prompted for the Key where I have entered the Token created in the merchant profile. It does not appear to accept the connection. Thanks in advance for any insight or other methods you may have used.

10 |2000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

u1 avatar image
u1 answered

Have you been able to retrieve data at all? Before trying to directly import into BI, try one of the clover examples to get data from your test merchant.

10 |2000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

cm-brilliant avatar image
cm-brilliant answered

Yes, I've successfully integrated using a database.

The URL looks like this: https://api.clover.com:443/v3/merchan...

10 |2000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Welcome to the
Clover Developer Community