Monthly Cost Query
The GetMonthlyCostInfo endpoint returns monthly cost information from the MIMS system.
How to query monthly cost
HTTP POST Request
| Request Type | Example URL |
|---|---|
| POST | {{url_base}}/GetMonthlyCostInfo |
| Example | http://seuIPePorta/datasnap/rest/RESTWebServiceMethods/"GetMonthlyCostInfo" |
Input Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| Period | String(40) | Yes | Period (Month + Year) |
| BranchNo | String(25) | Yes | External branch code |
Return
| Parameter | Type | Required | Description |
|---|---|---|---|
| WebServiceReturn | WebServiceReturn | Yes | Standard WebService response information on method execution |
| MonthlyCostInfoDatatList | GetMonthlyCostItem | Yes | List of all monthly costs per product in the period |
📝 GetMonthlyCostItem Object
The GetMonthlyCostItem object represents the cost of a product in the period
Return Parameters
Parameter Type Required Description BranchNo String(25) Yes External branch code Period String(40) Yes Period (Month + Year) ProductNo String(25) Yes External product code TotalProductWeight Float Yes Total product weight LastDayProcessingMonth DataHora Yes Date/Time of the last day of the month in which data was processed CostProductRealValue Float Yes Real product cost per kilo CostProductPresumedValue Float Yes Presumed product cost per kilo
Request Example
curl --location 'http://seuIPePorta/datasnap/rest/RESTWebServiceMethods/"GetMonthlyCostInfo"' \
--header 'Content-Type: application/json' \
--data '{
"Period": "202502",
"BranchNo": "BR001"
}'
Response Example
{
"WebServiceReturn": {
"Status": "wrsSuccess",
"ErrorCode": "",
"Message": "",
"Actor": "",
"ReturnQuestion": null
},
"MonthlyCostInfoData": [
{
"BranchNo": "BR001",
"Period": "202502",
"ProductNo": "PROD001",
"TotalProductWeight": 1000.0,
"LastDayProcessingMonth": "2025-02-28T23:59:59Z",
"CostProductRealValue": 5.50,
"CostProductPresumedValue": 5.75
}
]
}