different queries are all returning the same data.

[JuiceyBrucey]

/Queries/SalesOrderList
/Queries/SalesQuoteList
Queries/SO_Main?DebtorID=".$debtorId."&OrderBy=LastSavedDateTime&Take=".$limit."&Skip=".$start."";

Are all returning the same data.
Is there a way of only getting quotes or only getting orders?
Do they come from the same table and only differ by order type?
Thank you.
Cheers

[Mike.Sheen]

Are all returning the same data.

Nah - just the /Queries/SalesOrderList and Queries/SO_Main are reporting of the same underlying data. Queries/SO_Main is just the SO_Main table, /Queries/SalesOrderList joins in a few other tables (such as DB_Main to get the debtor name).

Queries/SalesQuoteList is giving you quotes - from the QO_Main table - it just looks remarkably similar - and what doesn't help is our quote table has fields like InvoiceId and InvoiceNo, which might trick you into thinking they are sales orders.

Compare the two results:

https://api.jiwa.com.au/Queries/SalesOr ... =InvoiceNo

https://api.jiwa.com.au/Queries/SalesQu ... =InvoiceNo

Look closely at the Invoice Id and also the debtor for each - they are different.

[JuiceyBrucey]

Thank you Mike, that has cleared a lot up.
Cheers
this is resolved.

[JuiceyBrucey]

how do I mark my posts as resolved?

[Scott.Pearce]

how do I mark my posts as resolved?

It looks like you've figured it out, but for others, you click the little checkmark button at the top right of the post that provided the answer:

[Scott.Pearce]

Moved to appropriate forum.