Equivalent to balance filed through API

API Q&A
#1

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.

#2

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>
1 Like