restSQL is an open-source, ultra-lightweight data access layer for HTTP clients SQL Resource name Returns rows for SQL Resource matching query parameters res/sdk.film.Film?year=2010 res/sdk.film.Film?_limit=100&_offset=0 Each column name, or if configured alias, specified in the resource definition is available for query. Normal response Read response (in XML) Read response (in JSON) Invalid parameters Invalid SQL Resource name SQL Exception / database error Creates row using URL-encoded form params or one or more rows in an XML or JSON body. For hierarchical SQL Resources, parents and children must be added in separate requests. Create request (in URL-encoded form params) Create request (in XML) Create request (in JSON) Normal response Create response with number of rows created (in XML) Create response with number of rows created (in JSON) Invalid SQL Resource name SQL Exception / database error Updates rows using query params and URL-encoded form params or rows specified in a XML or JSON body. For hierarchical SQL Resources, parents and children must be updated in separate requests. Attach optional attribute values with which to filter update set. Use only with URL-encoded form params Update request (in URL-encoded form params) Updated request (in XML) Updated request (in JSON) Normal response Update response with number of rows updated (in XML) Update response with number of rows updated (in JSON) Invalid parameters Invalid SQL Resource name SQL Exception / database error Deletes one or more rows using query params or all rows in an XML body. Attribute values with which to filter delete set Delete request (in XML) Delete request (in JSON) Normal response Delete response with number of rows deleted (in XML) Delete response with number of rows deleted (in JSON) Invalid SQL Resource name SQL Exception / database error SQL Resource name Primary key value. Multiple values allowed for multi-valued primary key. Returns row for SQL Resource matching primary key res/sdk.film.Film/1001 Normal response Read response (in XML) Read response (in JSON) Invalid SQL Resource name SQL Exception / database error Creates children rows using XML or JSON body for hierarchical SQL Resources. Create request (in XML) Create request (in JSON) Normal response Invalid SQL Resource name SQL Exception / database error Updates specific row using URL-encoded form params or multiple child rows using XML or JSON body for hierarchical SQL Resources. Attribute values with which to filter update set. Use only with URL-encoded form params Update request (in URL-encoded form params) Update request (in XML) Update request (in JSON) Normal response Invalid parameters Invalid SQL Resource name SQL Exception / database error Deletes specific row by primary key. For hierarchical SQL Resources, deletes all children contained in the XML or JSON body. Optional delete request for children (in XML) Optional delete request for children (in JSON) Normal response Invalid SQL Resource name SQL Exception / database error Returns general restSQL framework configuration Returns logging configuration Returns security configuration SQL Resource name Returns SQL Resource definition (from user-provided XML file) definition/film Normal response Invalid SQL Resource name SQL Resource name Returns SQL Resource metadata as understood by restSQL metadata/film Normal response Invalid SQL Resource name SQL Resource name Reloads SQL Resource definition (from user-provided XML file) reload/film Normal response Invalid SQL Resource name Returns browsable list of current and rollover access, error and trace log files, if any Returns current access log Returns current error log Returns current trace log Returns summary statistics such as number of requests, errors and average response times Responds with pong. Useful to monitor service health. Returns db connection health Pretty printing Shows all current thread stack traces Pretty printing Returns restSQL WADL