Posted: Thu Sep 05, 2024 4:48 pmPosted: Thu Sep 05, 2024 4:56 pmPosted: Thu Sep 05, 2024 5:04 pmMike.Sheen wrote:You can access any table via the API if you expose a route using the existing AutoQuery request types.
I showed you a while ago how to do that for the SO_Main table. For debtors you want the DB_TransAlloc table for debtor allocations, and creditors is CR_TransAlloc.
We don't expose every table out of the box because that makes the API too big.
Posted: Thu Sep 05, 2024 5:05 pmkranil7701 wrote: So you are saying that we can't get debtor or creditor allocations using API ?
Posted: Thu Sep 05, 2024 5:15 pmMike.Sheen wrote:kranil7701 wrote: So you are saying that we can't get debtor or creditor allocations using API ?
No, I am not saying that at all.
I'm saying you can if you just add the route, but I explained WHY we don't have routes exposed by default.
Posted: Thu Sep 05, 2024 5:18 pmkranil7701 wrote:Hey I am using it like this : https://api-102329.opallogic.cloud:4123 ... TransAlloc
is it correct?
here is the screenshot => <redacted>
Posted: Thu Sep 05, 2024 5:54 pmMike.Sheen wrote:kranil7701 wrote:Hey I am using it like this :
Did you add the route via a custom plugin like I said? You need to add the route explicitly in a custom plugin, and then restart the API and then the route can be used.
Re-read my first response to this post and go follow the link I provided and READ it.