Support Center

Create a Store Dashboard on Power Bi using Jumpseller Orders API

Extract information from an e-commerce service using an API with pagination restrictions to create a panel on Microsoft Power BI.

This guide is meant for orders in Jumpseller stores but can be used on any token-based API with pagination restrictions.

1. Copy API URL from your Admin Panel: Accounts section, use your own URLs, these are only for testing purposes and are now expired.

Paid Orders:

	https://api.jumpseller.com/v1/orders/status/paid.json?login=3243f59623e763f22d753a81e2184e01&authtoken=0c850f91437c2c8f3f0ccb297966e01d 

All Orders:

	https://api.jumpseller.com/v1/orders.json?login=3243f59623e763f22d753a81e2184e01&authtoken=0c850f91437c2c8f3f0ccb297966e01d

2. Add pagination parameters to your URL, I picked all orders URL:

  https://api.jumpseller.com/v1/orders.json?login=3243f59623e763f22d753a81e2184e01&authtoken=0c850f91437c2c8f3f0ccb297966e01d&page=3&limit=100 

3. Paste the URL as a Web Query. This will only bring us 100 records, maximum per page. From this base query we will create a function and replace the page number with a parameter “page” so we can loop and get all pages of the store.

4. Left click on the Orders table and create a Function, edit the function adding the page as text argument, and replace the page number (3 on this example) with the parameter page.

5. Now we need to create a table that contains all of the paginated information, we will start with this function to generate a table with only one column for the pages (Only three pages on this example, this will return a maximum of 300 orders, you are free to add more):

	=
	Table.TransformColumnTypes(Table.FromRows({{1},{2},{3}},{"page"}),{{"page",type text}}) 

6. Go to Add Column and then Custom Column, apply the function to the page value, it will create a column with pages on its values, the final step is to expand.

logo

7. Create your dashboard.

logo

Start your journey with us!

Free trial for 14 days. No credit card required.