Get all the allocation to jiwa

[kranil7701]

I need the api Get all the creditors allocation and debtor allocation to jiwa . please let me know is there any way to get all the creditors allocation and debtor allocation.
thanks

[Mike.Sheen]

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.

[kranil7701]

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.

So you are saying that we can't get debtor or creditor allocations using API ?

[Mike.Sheen]

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.

[kranil7701]

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.

[Mike.Sheen]

Hey I am using it like this : https://api-102329.opallogic.cloud:4123 ... TransAlloc
is it correct?
here is the screenshot => <redacted>

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.

[kranil7701]

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.