GetDataTable (method)

Returns information indicating the table, fields and conditions of any table in the database.

The information returned may be conditional depending on user settings

Comments

Supported only a table name.

Definition

JSON

/json/GetDataTable?token={Token}&table={Table}&fields={Fields}&condition={Condition}&order={Order}&group={Group}&maxrecords={MaxRecords}

Parameters

Parameter	Description
Token	Authentication code, see more in GetToken (method)
Table	Table from which to obtain information
Fields	List of fields to return
Condition	Search condition
Order	Sorts data returned
Group	Groups data returned
MaxRecords	Limits the rows returned in a query result

Example JSON

http://test.aliquosoftware.net/aliquoserver/api.svc/json/GetDataTable?token=_PutTokenHere_&table=articulos&fields=codigo,exp_stocktotal