Webapi interface for universal query of Kingdee CLoud member files

1. Request parameter description:

1.data:JSON format data (refer to JSON format data for details) (must be recorded)

1.1.FormId: business object form Id (required)

1.2.FieldKeys: key collection of fields to be queried, string type, format: "key1,key2,..." (required) Note (query document body Key and underscore, such as: FEntryKey_FEntryId)

1.3.FilterString: filter criteria, string type (optional)

1.4.OrderString: sort field, string type (optional)

1.5.TopRowCount: returns the total number of lines, integer (optional)

1.6.StartRow: start row index, integer (optional)

1.7.Limit: maximum number of lines, integer, not more than 2000 (optional)

2. Return the result:

[["FValue1", "FValue2",...], ["FValue1", "FValue2",...],...]

3. Code example:

/ / use webapi to reference component Kingdee.BOS.WebApi.Client.dll

K3CloudApiClient client = new K3CloudApiClient ("http://k3cloud/");

Var loginResult = client.ValidateLogin ("5867f8d847e804", "Administrator", "888888", 2052)

Var resultType = JObject.Parse (loginResult) ["LoginResultType"] .Value ()

/ / the login result type is equal to 1, which means the login is successful

If (resultType = = 1)

{

Client.ExecuteBillQuery ("{" FormId ":", "FieldKeys": "," FilterString ":", "OrderString": "", "TopRowCount": 0, "StartRow": 0, "Limit": 0} ")

}

4. Data in JSON format:

{

"FormId":

"FieldKeys":

"FilterString":

"OrderString":

"TopRowCount": 0

"StartRow": 0

"Limit": 0

}