Performing query operations

Query or search operations can be used to fetch data out of CloudIO Platform. Special characters in the attribute names and values can be passed with the request payload.

The name-value pairs specified as part of the data JSON Object may use the following special characters to perform a complex search

Performing an insert operation

Using the insert operation, the client application can insert one or more rows in the table. JSON POST uses the JSON Array payload of the objects type with name-value pairs, where the name should match the datasource attribute name in camel case format.

For example, Customer Name attribute should be named as customerName for the key in the JSON Object.

The URI to perform the insert operation: /api/Datasource/insert.

Sample JSON payload for an insert operation

[
 "accountNumber": "345354",
 "address1": "100 Main St",
 "creationDate": "2015-10-28T01:42:30.789Z",
 "createdBy": 1,
 "lastUpdateDate": "2015-10-28T01:42:46.964Z",
 "lastUpdatedBy": 1,
 "partyName": "CloudIO Inc."
,
 "accountNumber": "345355",
 "address1": "333 Main St",
 "creationDate": "2015-10-28T01:42:30.789Z",
 "createdBy": 1,
 "lastUpdateDate": "2015-10-28T01:42:46.964Z",
 "lastUpdatedBy": 1,
 "partyName": "CloudIO India Pvt. Ltd.
]

Note: Ensure that all the attributes that are marked mandatory at the datasource level are populated.

Performing an update operation

Using the update operation, the client application can update one or more rows in the table. JSON POST uses the JSON Array payload of the type—objects. All the primary key attributes must have a value, and only the values of the attributes that are passed in the payload are updated.

The URI to perform the update operation: /api/DataSource/update

Performing a delete operation

Using the Delete operation, the client application can delete one or more records from the DB. JSON POST uses the JSON Array payload of the type—objects. Only the primary key attributes are required for the delete operation.

The URI to perform a delete operation: /api/DataSource/delete