List Orders with datePaid is within last 14 days using the Element API plugin I want to list the orders with datePaid is within last 14 days. But I cannot workout the correct criteria, and I don't know if isPaid works correctly as well:

'criteria' =&gt; [
    'dateUpdated' =&gt; '&gt;=' . date('Y-m-d'.' 00:00:00', strtotime("-14 days")),
    'isPaid' =&gt; '1',
],
Here's an example elementapi.php that should get you going...this is returning shipping details but you can modify the transformer for whatever data you need of course...

return [
'endpoints' =&gt; [
    'api/json/orders/whatever.json' =&gt;  [
        'paginate' =&gt; false,
        'elementType' =&gt; 'Commerce_Order',
        'criteria' =&gt;   ['dateOrdered' =&gt; '&gt;'. date('Y-m-d', strtotime("-2 weeks")),
                         'isPaid' =&gt; true,
                        ],

        'transformer' =&gt; function(Commerce_OrderModel $order) {
            return [
            "id" =&gt; $order-&gt;ISOrderNumber,   
            "fullname" =&gt; $order-&gt;shippingAddress-&gt;firstName ?? '' . " " . $order-&gt;shippingAddress-&gt;lastName ?? '',
            "firstname" =&gt; $order-&gt;shippingAddress-&gt;firstName ?? '',
            "lastname" =&gt; $order-&gt;shippingAddress-&gt;lastName ?? '',    
            "company" =&gt; $order-&gt;shippingAddress-&gt;businessName ?? '',
            "street1" =&gt; $order-&gt;shippingAddress-&gt;address1 ?? '',
            "street2" =&gt; $order-&gt;shippingAddress-&gt;address2 ?? '',
            "suburb" =&gt; $order-&gt;shippingAddress-&gt;city ?? '',
            "state" =&gt; $order-&gt;shippingAddress-&gt;stateName ?? '',
            "postcode" =&gt; $order-&gt;shippingAddress-&gt;zipCode ?? '',
            "phone" =&gt; $order-&gt;shippingAddress-&gt;phone ?? '',
            "mobile" =&gt; $order-&gt;shippingAddress-&gt;phone ?? '',
            "email" =&gt; $order-&gt;email ?? '', 
            ];
        },
    ], 

    // Next api thing to go here...

],


];