# Equivalent to balance filed through API

**URL:** <https://integration.keap.com/t/equivalent-to-balance-filed-through-api/11101>\
**Category:** API Q&A\
**Created:** [August 17, 2017, 9:01pm UTC](https://integration.keap.com/t/equivalent-to-balance-filed-through-api/11101 "2017-08-17T21:01:32Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Cody\_Gillespie](https://avatars.discourse-cdn.com/v4/letter/c/eada6e/32.png) [@Cody\_Gillespie](https://integration.keap.com/u/Cody_Gillespie)\
**Post date:** [August 17, 2017, 9:01pm UTC](https://integration.keap.com/t/equivalent-to-balance-filed-through-api/11101/1 "2017-08-17T21:01:32Z")

</div>

Hello,

When exporting orders through csv, using eCommerce–all sales reports—with the filter balance equals 0.  
This is how we identify if an order was actually processed. I do not see a way to follow this same process with the fields available through API. I am hoping there is a separate field that i am just not aware of.  
Any help on this would be greatly appreciated.

---

<div class="post-metadata">

**Author:** ![TomScott](https://sea1.discourse-cdn.com/flex019/user_avatar/integration.keap.com/tomscott/32/67_2.png) [@TomScott](https://integration.keap.com/u/TomScott)\
**Post date:** [August 17, 2017, 9:25pm UTC](https://integration.keap.com/t/equivalent-to-balance-filed-through-api/11101/2 "2017-08-17T21:25:41Z")

</div>

Under the REST API we use /orders?paid=true to determine if an order has it’s balance paid or not.  
Under the XML-RPC API you could use the following command to get the list of ones that are paid:

```
<?xml version='1.0' encoding='UTF-8'?>
<methodCall>
  <methodName>DataService.query</methodName>
  <params>
<param>
  <value><string>yourapikey</string></value>
</param>
<param>
  <value><string>Invoice</string></value>
</param>
<param>
  <value><int>1</int></value>
</param>
<param>
  <value><int>1</int></value>
</param>
<param>
  <value><struct>
    <member><name>PayStatus</name>
      <value><string>1</string></value>
    </member>
  </struct></value>
</param>
<param>
  <value><array>
    <data>
      <value><string>Id</string></value>
      <value><string>ProductSold</string></value>
      <value><string>ContactId</string></value>
      <value><string>LastUpdated</string></value>
    </data>
  </array></value>
</param>
<param>
  <value><string>LastUpdated</string></value>
</param>
<param>
  <value><boolean>1</boolean></value>
</param>
  </params>
</methodCall>

```