power BI and Woocommerce

[PaulAndreas]

I am trying to access data from woocommerce using the rest api. usig the befor and after.

The problem is the page=100, is the maximum of records.

How do I get records back in time?

See the api setting under (where customer... is my customer name)

https://customer..../wp-json/wc/v3/orders?after=2022-01-01T00:00:00&before=2022-04-15T23:59:59&per_p...

[PhilipTreacy]

Hi @PaulAndreas 

What do you mean page=100 is the maximum?  If there are only 100 pages of records then that's all there are.  I'm not sure what you are expecting?

What do you mean by get records back in time?  You are providing after and before in the query, if you want orders before those dates then change the date for after ?

List all orders – WooCommerce REST API Documentation - WP REST API v3

Regards

Phil

[PaulAndreas]

Well what i mean ist that i cannot get more than 100 records in PowerBI. I wanted to have all the transaction in the database ( aproimately 32.000 in one year) If you know this solution please invite me to a teams meeting invite me paul.osuldsen@soprasteria.com