Webservice - Data Export

Through this functionality it is possible, via request to the WebService, to obtain data from the CITSmart Database tables for an XML file.The query conditions for the records that will be returned are passed as parameters via URL as the example below:

http://localhost/citsmart/services/data/cargos/19

This request returns the records of the positions table where the idcargo, that is, the primary key of the charges table, is equal to 19. The query generated with this request is this:

 SELECT IDCARGO, NOMECARGO, DATAINICIO, DATAFIM, IDDESCRICAOCARGO FROM CARGOS WHERE IDCARGO = 19

Below are listed the possibilities and parameters that can be used for data recovery using this feature:

PK Consultation

It is possible to obtain a record according to a Primary Key field of the reported table.

	http://localhost/citsmart/services/data/process/19
	   It will search the table PROCESS with the PK Key equal to 19.

Query by Pk and Where

It is possible to obtain a record according to a Primary Key field of the given table and that meets the conditions of a where clause.

	SELECT * FROM <TABLE_NAME> WHERE <PK_FIELD> = <PK_VALUE> AND (<ADDITIONAL_CLAUSES>)

Where And Ordered Consultation

It is possible to obtain ordered records of a table according to the conditions of a where clause and field for sorted ordering.

	http://localhost/citsmart/services/data/cargos?cond=idcargo<15 and idcargo > 10&order=nomecargo

Query with links to Where and Ordering

It is possible to obtain ordered records of a table, along with the records with which they are linked, according to the conditions of a where clause and field for ordering.

	http://<SERVER ADDRESS*>/citsmart/services/data/<TABLE>?cond=<WHERE_CRITERIA>&order=<ORDERING FIELD>&links=<s_ou_n>