question

chrisbevan avatar image
chrisbevan asked ·

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 characters needed characters left characters exceeded

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

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 characters needed characters left characters exceeded

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 characters needed characters left characters exceeded

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