api/GLAccount/Query (POST)
Queries existing GL Accounts using the provided query data.
HTTP Method: POST
Required Fields: At least one field as search criteria
Requires an Authentication Token in the AuthToken HTTP header. Authentication Tokens are obtained from api/Security/Login (POST).
Returns all found GL Accounts.
Request Information
Parameters
| Name | Description | Additional information |
|---|---|---|
| RequestData | This is a JSON object containing GL Account query data.
Query Single GL Account Using Key Fields Example:
{
"COMPANY_ID": "00",
"DEPARTMENT": "0",
"ACCOUNT": "310"
}
Returns 1 GL Account if successful.
This is like 'Find' in Expandable.
Query Multiple GL Accounts Using Other Fields Example:
{
"ACCOUNT_STATUS": "A",
"CURR_CODE": "EUR"
}
Returns 1 or more GL Accounts if successful.
This is like 'QBE' in Expandable.
Query Multiple GL Accounts Using QBE Conditional Notation Example:
{
"ACCOUNT_STATUS": "A",
"CURR_CODE": "IN 'EUR','CNY'"
}
Returns 1 or more GL Accounts if successful.
This is like 'QBE' in Expandable.
Accepted GL Account Fields:
ACCOUNT, ACCOUNT_CLASS, ACCOUNT_DESC, ACCOUNT_STATUS,
ACCOUNT_TYPE, BUSINESS_CAT, BUSINESS_FUNCT, COMPANY_ID,
CONV_METHOD, CREATED_BY, CURR_CODE, CURR_CODE_2,
CURR_CODE_3, DATE_CREATED, DATE_INACTIVE, DATE_MODIFIED,
DEPARTMENT, GAIN_LOSS_ACCT, GAIN_LOSS_DEPT, GLFCA_USER_1,
GLFCA_USER_10, GLFCA_USER_11, GLFCA_USER_12, GLFCA_USER_13,
GLFCA_USER_14, GLFCA_USER_15, GLFCA_USER_16, GLFCA_USER_17,
GLFCA_USER_18, GLFCA_USER_19, GLFCA_USER_2, GLFCA_USER_20,
GLFCA_USER_3, GLFCA_USER_4, GLFCA_USER_5, GLFCA_USER_6,
GLFCA_USER_7, GLFCA_USER_8, GLFCA_USER_9, MODIFIED_BY,
OPERATOR_ID, RESP_ID_1, RESP_ID_2, RESP_ID_3,
RPT_CATEGORY, RPT_GROUP, RPT_SUB_GROUP, SUMMARY_FLAG |
Define this parameter in the request body. |
Response Information
Success:200/OK
Body contains JSON array with found GL Accounts.
Error:
400/Request JSON is invalid.
401/AuthToken was not provided.
401/AuthToken is malformed.
401/AuthToken is expired.
401/AuthToken login failure.
500/(Message)
Body contains JSON object with Message and MessageCode.
Returned GL Account Fields:
ACCOUNT, ACCOUNT_CLASS, ACCOUNT_DESC, ACCOUNT_STATUS, ACCOUNT_TYPE, BUSINESS_CAT, BUSINESS_FUNCT, COMPANY_ID, CONV_METHOD, CREATED_BY, CURR_CODE, CURR_CODE_2, CURR_CODE_3, DATE_CREATED, DATE_INACTIVE, DATE_MODIFIED, DEPARTMENT, GAIN_LOSS_ACCT, GAIN_LOSS_DEPT, GLFCA_USER_1, GLFCA_USER_10, GLFCA_USER_11, GLFCA_USER_12, GLFCA_USER_13, GLFCA_USER_14, GLFCA_USER_15, GLFCA_USER_16, GLFCA_USER_17, GLFCA_USER_18, GLFCA_USER_19, GLFCA_USER_2, GLFCA_USER_20, GLFCA_USER_3, GLFCA_USER_4, GLFCA_USER_5, GLFCA_USER_6, GLFCA_USER_7, GLFCA_USER_8, GLFCA_USER_9, MODIFIED_BY, OPERATOR_ID, RESP_ID_1, RESP_ID_2, RESP_ID_3, RPT_CATEGORY, RPT_GROUP, RPT_SUB_GROUP, SUMMARY_FLAG