¿En qué podemos ayudarte?
< Todos los temas
Imprimir

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

ParameterDescription
TokenAuthentication code, see more in GetToken (method)
TablesTable or tables from which to obtain information
FieldsList of fields to return
ConditionSearch condition
OrderSorts data returned
GroupGroups data returned
MaxRecordsLimits the rows returned in a query result
GenerateSchemaReturns information of types and sizes


Example JSON

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

Tabla de contenidos