Excel Rest API payouts data

  • Resolved vladvalentine

    (@vladvalentine)


    1 day, 20 hours ago

    I’ve been able to pull data from https://website.com/wp-json/wc/v3/orders via power query to get all the order transactions, but I get a 500 error trying to get the payout data from /wp-json/wc/v3/payments/deposits/transactions

    I need a single report that provides the full transaction list like a bank account does for the accountant and auditors. Needs to show everything from the orders table already extracted, but also needs the payout/payin transactions as well. If there is a report built in, that would be better, but it looks like analytics is all segregated.

    I am fine to manage the data once extracted, so I’m only looking for help to get the table with the payouts list if possible. Thanks

Viewing 1 replies (of 1 total)
  • Plugin Support Frank Remmy (woo-hc)

    (@frankremmy)

    1 day, 19 hours ago

    Hi @vladvalentine,

    The 500 error on /wp-json/wc/v3/payments/deposits/transactions makes sense. That specific endpoint doesn’t actually exist in WooPayments, which is why it’s failing. The deposits-related routes that are available are /wc/v3/payments/deposits (list of deposits) and /wc/v3/payments/deposits/{deposit_id} for individual deposit details. Those may get you closer to the payout data you need.

    Since these are WooPayments-specific endpoints rather than WooCommerce core REST API routes, this thread is better handled in the WooPayments support forum where the team has direct visibility into those APIs: https://wordpress.org/support/plugin/woocommerce-payments/

    I’d be closing this one so when you repost there, it’d help to mention exactly what data fields you need in your report (e.g. payout date, amount, fee, net) so the team can point you to the right endpoint and parameters.

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.

Tags