I need more order details, how I can get that?

[Deals_Meetup]

I need more order details, how I can get that? Like quantity, number of credits, etc.

current I am getting only
PayStatus, InvoiceTotal,Id,ContactId,JobId

with following code.

app = new iSDK;
$invoiceId = $_GET[‘orderId’];;

if($invoiceId!=“”)
{

$qry = array(‘JobId’ => $invoiceId);
$rets = array(‘Id’);
$cards = $app->dsQuery(“Invoice”, 100, 0, $qry, $rets);
//print_r($cards);
$invoiceId=$cards[‘0’][‘Id’];
$returnFields = array(‘Id’, ‘ContactId’, ‘JobId’,‘PayStatus’,‘InvoiceTotal’);
$invoiceDetails = $app->dsLoad(“Invoice”, $invoiceId, $returnFields);
}
print_r($invoiceDetails);

---

[John_Borelli]

Query the InvoiceItem table:

Also, the order table is called ‘Job’ so you’ll actually want to get more information from that:

[Deals_Meetup]

in which table I can get the details about Quantity of the product or item in the order?

[Pav]

You need the “OrderItem” table.

https://developer.infusionsoft.com/docs/table-schema/#OrderItem