power BI and Woocommerce

PaulAndreas · ‎04-26-2022

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 · ‎04-27-2022

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

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

Blog :: YouTube Channel :: Connect on Linkedin

Proud to be a Super User!

PaulAndreas · ‎05-03-2022

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