Get all debtor's and creditors in jiwa

[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

[Mike.Sheen]

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.