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

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);


Query the InvoiceItem table:

image

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

image

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

You need the “OrderItem” table.

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