Forum Discussion
Import data table from Brightpearl to Power BI
Hi,
I am trying to import the sales data from Brightpearl from the "Sales by Product" report into Power BI. I am not sure what the exact query request need to be... I have an app ref as well as token, that's pretty much as far as I was able to go
let
Source = Json.Document(Web.Contents("https://not-sure-what-the-url-needs-to-be-here", [Headers=[#"brightpearl-app-ref"="XXX", #"brightpearl-account-token"="XXX="]])),
response = Source[response],
results = response[results],
...
in
...
2 Replies
- v-jingzhangCommunity Support
Hi datatbl123
Does Brightpearl provide any APIs for other third-party applications to query data from the "Sales by Product" report? If so, you can use that API's URL address.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!- datatbl123Helper I
Hi v-jingzhang
This is what I was given but I wasn't really sure where to start and the exact command/line of code to load the Sales by Product for instance:
https://help.brightpearl.com/hc/en-us/categories/201519763-Developer-area
https://api-docs.brightpearl.com/product/product/index.html