List of endpoints

PostGresSQL

List all the database collections in PostGresSQL. By default 20 collections are included, will need to be an enterprise user to get more.

				
					https://localhost:3000/hello/PostGresApi/IzHKeQxKnIDDpyhH/list_table

List table data

				
					https://localhost:3000/hello/PostGresApi/IzHKeQxKnIDDpyhH/list_rows

– Params:

Object	Description
`table_name`	[Required] Name of table you want to search in.
`projection`	[Optional] Fields to include in search result, separated by comma (,)
`pagination_next_index`	[Optional] Index to start the pagination from, for eg: If 10 record is being shown then your next index will be from 10
`sort_by`	[Optional] Fields separated by comma (,)
`sort_order`	[Optional] values accepted are asc and desc
`limit`	[Optional] No. of rows to be retuned, by default 10, will need to be enterprise to get more.

– Body data format example:

{
     "name": "Nocode",
    "email": "nocode@nocode,com",
    "time": "1348853312"
}

Update row in database using ID

				
					https://localhost:3000/hello/PostGresApi/IzHKeQxKnIDDpyhH/update_rows

– Params :

Object	Description
`table_name`	[Required] Name of table you want to search in
`identifier`	[Required] Field name by which you want to update the row.
`identifier_value`	[Required] Field value by which you want to update the row.

				
					https://localhost:3000/hello/PostGresApi/IzHKeQxKnIDDpyhH/search_rows

– Params:

Object	Description
`table_name`	[Required] Name of table you want to search in.
`search_string`	[Required] String to search
`search_field`	[Required] Field name to search in
`projection`	[Optional] Fields to include in search result, separated by comma (,)/td>
`pagination_next_index`	[Optional] Index to start the pagination from, for eg: if 10 record is being shown then your next index will be from 10
`sort_by`	[Optional] Fields separated by comma (,)
`sort_order`	[Optional] values accepted are asc and desc
`limit`	[Optional] No. of rows to be returned, by default 20, will need to be enterprise to get more.