In my tests, order due_time is always empty.
How to retrieve value equal to XML-RPC’s Job.DueDate value?
In my tests, order due_time is always empty.
How to retrieve value equal to XML-RPC’s Job.DueDate value?
It will be returned as due_time on an Order object, presuming the Invoice Due Date is not null.
If by “Invoice Due Date” you mean Job.DueDate, then it’s not.
<member>
<name>Id
</name>
<value>
<i4>6287
</i4>
</value>
</member>
<member>
<name>DueDate
</name>
<value>
<dateTime.iso8601>20261004T17:00:00
</dateTime.iso8601>
</value>
</member>
GET /crm/rest/v2/orders?filter=invoice_id%3D%3D6287&page_size=1&order_by=id%20asc
{
"orders": [
{
"id": "6287",
"title": "***",
"status": "DRAFT",
"total": {
"amount": 2485,
"currency_code": "USD",
"formatted_amount": "$24.85"
},
"contact": {
"id": "21",
"email": "***",
"given_name": "***",
"family_name": "***"
},
"notes": "",
"terms": "",
"creation_time": "2026-10-05T06:15:27.000-04:00",
"modification_time": "2026-10-05T06:15:55.000-04:00",
"order_time": "2026-10-04T21:00:00Z",
"lead_affiliate_id": "5",
"total_paid": {
"amount": 1500,
"currency_code": "USD",
"formatted_amount": "$15.00"
},
"total_due": {
"amount": 2485,
"currency_code": "USD",
"formatted_amount": "$24.85"
},
"shipping_information": {
"id": "5731",
"company": "***",
"given_name": "***",
"family_name": "***",
"phone_number": "+12222222222",
"invoice_to_company": false
},
"order_items": [
{
"id": "6635",
"name": "Eco Yoga Mat",
"description": "",
"notes": "",
"quantity": 1,
"product": {
"id": "59",
"name": "Eco Yoga Mat",
"sku": "",
"description": "",
"shippable": false,
"taxable": false
},
"subscription_id": "0",
"item_type": "PRODUCT",
"cost_per_unit": {
"amount": 0,
"currency_code": "USD",
"formatted_amount": "$0.00"
},
"price_per_unit": {
"amount": 2485,
"currency_code": "USD",
"formatted_amount": "$24.85"
}
}
],
"payment_plan": {
"auto_charge": false,
"max_charge_attempts": 3,
"days_between_retries": 2,
"initial_payment_amount": {
"amount": 1000,
"currency_code": "USD",
"formatted_amount": "$10.00"
},
"initial_payment_date": "2026-10-03",
"plan_start_date": "2026-10-07",
"number_of_payments": 1,
"days_between_payments": 30,
"payment_plan_items": [
{
"status": "PAID",
"due_date": "2026-10-03",
"amount_due": {
"amount": 1000,
"currency_code": "USD",
"formatted_amount": "$10.00"
},
"amount_paid": {
"amount": 1000,
"currency_code": "USD",
"formatted_amount": "$10.00"
}
},
{
"status": "UNPAID_MANUAL",
"due_date": "2026-10-07",
"amount_due": {
"amount": 1485,
"currency_code": "USD",
"formatted_amount": "$14.85"
},
"amount_paid": {
"amount": 500,
"currency_code": "USD",
"formatted_amount": "$5.00"
}
}
]
},
"credit_status": "NONE",
"promo_code": "",
"refund_status": "NONE",
"synced": false,
"invoice_id": "6287",
"custom_fields": []
}
],
"next_page_token": ""
}
Did you have a chance to take a look? Thanks.