GET api/StockBalances/changes/{branchId}?from={from}
Retrieves any changed rows since the specified time<br/> NOTE: To use this endpoint CDC (change data capture) needs to be enabled on the target database and running on the StockBalance table<br/>
Request Information
URI Parameters
| Name | Description | Type | Additional information |
|---|---|---|---|
| from |
(Required) Specific time to get changes since |
date |
Required |
| branchId |
(Optional) Branch ID to filter changes by |
integer |
Default value is Null |
Body Parameters
None.
Remarks
None.
Example
// Gets every changed stockbalance row since 2023-06-16 09:00
http://localhost/api/stockbalances/changes?from=2023-06-16T09:00
// Gets every changed stockbalance row since 2023-06-16 09:00 on branch 1
http://localhost/api/stockbalances/changes/1?from=2023-06-16T09:00
Response Information
Resource Description
Collection of CDCStockBalanceResponse| Name | Description | Type | Additional information |
|---|---|---|---|
| BranchId | integer |
Required |
|
| ArticleId | globally unique identifier |
Required |
|
| StockId | globally unique identifier |
Required |
|
| Quantity | decimal number |
Required |
|
| ReservedQuantity | decimal number |
Required |
|
| Consignation | decimal number |
Required |
|
| StockInTransfer | decimal number |
Required |
|
| PalletPlace | string |
Max length: 100 |
|
| ArticleNo | integer |
None. |
|
| Changed | date |
Required |
|
| Operation | string |
Required |
Response Formats
application/json, text/json
Sample:
[
{
"BranchId": 1,
"ArticleId": "37203c1e-90ae-4ae2-a8ed-e99706b746d8",
"StockId": "882e5934-2319-489f-9b5b-3e946a591860",
"Quantity": 4.0,
"ReservedQuantity": 5.0,
"Consignation": 6.0,
"StockInTransfer": 7.0,
"PalletPlace": "sample string 8",
"ArticleNo": 1,
"Changed": "2026-01-21 22:52:01",
"Operation": "sample string 10"
},
{
"BranchId": 1,
"ArticleId": "37203c1e-90ae-4ae2-a8ed-e99706b746d8",
"StockId": "882e5934-2319-489f-9b5b-3e946a591860",
"Quantity": 4.0,
"ReservedQuantity": 5.0,
"Consignation": 6.0,
"StockInTransfer": 7.0,
"PalletPlace": "sample string 8",
"ArticleNo": 1,
"Changed": "2026-01-21 22:52:01",
"Operation": "sample string 10"
}
]
application/xml, text/xml
Sample:
<ArrayOfCDCStockBalanceResponse xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Compilator.DDAPI.DTO.CDC.StockBalance">
<CDCStockBalanceResponse>
<Changed xmlns="http://schemas.datacontract.org/2004/07/Compilator.DDAPI.DTO.CDC">2026-01-21T22:52:01.826969+01:00</Changed>
<Operation xmlns="http://schemas.datacontract.org/2004/07/Compilator.DDAPI.DTO.CDC">sample string 10</Operation>
<ArticleId>37203c1e-90ae-4ae2-a8ed-e99706b746d8</ArticleId>
<ArticleNo>1</ArticleNo>
<BranchId>1</BranchId>
<Consignation>6</Consignation>
<PalletPlace>sample string 8</PalletPlace>
<Quantity>4</Quantity>
<ReservedQuantity>5</ReservedQuantity>
<StockId>882e5934-2319-489f-9b5b-3e946a591860</StockId>
<StockInTransfer>7</StockInTransfer>
</CDCStockBalanceResponse>
<CDCStockBalanceResponse>
<Changed xmlns="http://schemas.datacontract.org/2004/07/Compilator.DDAPI.DTO.CDC">2026-01-21T22:52:01.826969+01:00</Changed>
<Operation xmlns="http://schemas.datacontract.org/2004/07/Compilator.DDAPI.DTO.CDC">sample string 10</Operation>
<ArticleId>37203c1e-90ae-4ae2-a8ed-e99706b746d8</ArticleId>
<ArticleNo>1</ArticleNo>
<BranchId>1</BranchId>
<Consignation>6</Consignation>
<PalletPlace>sample string 8</PalletPlace>
<Quantity>4</Quantity>
<ReservedQuantity>5</ReservedQuantity>
<StockId>882e5934-2319-489f-9b5b-3e946a591860</StockId>
<StockInTransfer>7</StockInTransfer>
</CDCStockBalanceResponse>
</ArrayOfCDCStockBalanceResponse>
