Custom Get

The custom method GetCustomInfo retrieves information from a custom query.

---

HTTP POST Request

Request Type	Example URL
POST	{{url_base}}/GetCustomInfo
Example	http://seuIPePorta/datasnap/rest/RESTWebServiceMethods/"GetCustomInfo"

Input Parameters

Parameter	Type	Required	Description
CustomInfoScriptName	String(50)	Yes	Description of the custom query configured in the database
CustomInfoParameterList	CustomInfoParameterList	No	List of objects with the query execution parameters

📝 CustomInfoParameter Object

The CustomInfoParameter object represents a parameter to execute the custom query.

Input Parameters

Parameter	Type	Required	Description
ParamName	String(30)	Yes	Custom parameter name
ParamValue	String(50)	Yes	Custom parameter value
ParamType	CustomInfoParamType	No	Enumerator with possible values for Parameter Type (cipNotAssigned, cipString, cipNumeric, cipDateTime)

---

Return

Parameter	Type	Required	Description
WebServiceReturn	WebServiceReturn	Yes	Standard WebService response information in method execution
CustomInfoResultList	GetCustomInfoResultList	Yes	List of objects with the custom query return information

📝 GetCustomInfoResult Object

The GetCustomInfoResult object represents a custom query return.

Return Parameters

Parameter	Type	Required	Description
ResultRowInfoList	GetCustomInfoResultFieldList	Yes	List of objects with all columns and values returned by the query result row

📝 GetCustomInfoResultField Object

The GetCustomInfoResultField object represents a column of a custom query row.

Return Parameters

Parameter	Type	Required	Description
FieldName	String(30)	Yes	Column name returned in a custom query result row
FieldValue	String(2000)	Yes	Column value returned in a custom query result row

---

Request Example

curl --location 'http://seuIPePorta/datasnap/rest/RESTWebServiceMethods/"GetCustomInfo"' \
--header 'Content-Type: application/json' \
--data '{
    "CustomInfoScriptName": "GetReleasedLoadListByLastWeighingDate",
    "CustomInfoParameterList": [
        {
            "ParamName": "BranchNo",
            "ParamValue": "0102",
            "ParamType": "cipString"
        },
        {
            "ParamName": "LoadClosureDate",
            "ParamValue": "2025-11-11T20:51:50",
            "ParamType": "cipDateTime"
        }
    ]
}'

---

Response Example

{
    "WebServiceReturn": {
        "Status": "wrsSuccess",
        "ErrorCode": "",
        "Message": "",
        "Actor": "",
        "ReturnQuestion": null
    },
    "CustomInfoResultList": [
        {
            "ResultRowInfoList": [
                {
                    "FieldName": "LoadNo",
                    "FieldValue": "12112025371"
                }
            ]
        },
        {
            "ResultRowInfoList": [
                {
                    "FieldName": "LoadNo",
                    "FieldValue": "12112025673"
                }
            ]
        },
        {
            "ResultRowInfoList": [
                {
                    "FieldName": "LoadNo",
                    "FieldValue": "12112025393"
                }
            ]
        },
        {
            "ResultRowInfoList": [
                {
                    "FieldName": "LoadNo",
                    "FieldValue": "12112025374"
                }
            ]
        },
        {
            "ResultRowInfoList": [
                {
                    "FieldName": "LoadNo",
                    "FieldValue": "12112025389"
                }
            ]
        }
    ]
}

---