NoCodeAPI

Get All Database Table

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 Rows

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

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.

Search in a table

Search in a table

				
					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.

QUICKBOOKS ONLINE INTEGRATION NOW LIVE!!