GetData (method)

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

Comments

You can perform complex queries using JOIN in Tables field.

Definition

JSON

/json/GetData?token={Token}&tables={Tables}&fields={Fields}&condition={Condition}&order={Order}&group={Group}&maxrecords={MaxRecords}

Parameters

Parameter	Description
Token	Authentication code, see more in GetToken (method)
Tables	Table or tables 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
GenerateSchema	Returns information of types and sizes

Example JSON

http://test.aliquosoftware.net/aliquoserver/api.svc/json/GetData?token=_PutTokenHere_&tables=almacenes&fields=codigo,nombre