Page 1 of 1

Get all debtor's and creditors in jiwa

PostPosted: Thu May 30, 2024 1:48 pm
by kranil7701
Is this is possible to get all the creditors and debtor's by using jiwa api.
please let me know if any endpoint for creditors and debtor's without passing id .
thanks

Re: Get all debtor's and creditors in jiwa  Topic is solved

PostPosted: Thu May 30, 2024 6:35 pm
by Mike.Sheen
kranil7701 wrote:Is this is possible to get all the creditors and debtor's by using jiwa api.
please let me know if any endpoint for creditors and debtor's without passing id .
thanks


It depends.

If you want to get a shallow list, then the /Queries/DB_Main and /Queries/CR_Main return a filterable, paginated list of a limited number of fields. Debtors also has an expanded list with /Queries/DebtorList which joins in some other tables.

If you want to get all the complex DTO's of debtors and creditors, then there is no single route - use one of the above to get the list of DebtorID's or CreditorID's and then call the respective /Debtors/{DebtorID] or /Creditors/{CreditorID} route.

Keep in mind in even a modest sized database, doing this for every debtor and creditor is a resource intensive operation. It's not acceptable to perform this on a regular basis.