Count of Records

DDS has the ability to fetch the count of records for a particular query. This can be used to fetch count of all records or a limited set of records based on conditions and parameters as required.

A sample GET query with result is as follows:

http://<dds_host>:<dds_port>/dynamic-data-service-web/resources/dds/<SELECTED_SCHEMA>/data?fromTables=TABLE1&offset=0&pageLimit=25

Note:

The count query that is actually being run is slightly different to the one displayed in GET box. The correct one is given below in the curl command equivalent.

A curl equivalent of the above example:

Curl -i -H "Authorization: Bearer $AccessToken" -H "Content-Type: application/json;charset=UTF-8" --request GET "http://<dds_host>:<dds_port>/dynamic-data-service-web/resources/dds/<SELECTED_SCHEMA>/data/count?fromTables=TABLE1&rowFilter=<CONDITIONS_AS_REQUIRED>" -o filename.txt