When I run a select query ("Select top 1 * from c") on a container I get:
{
"id": "102",
"sid": "s-102",
"name": "Bena",
"grade": "2",
"_rid": "ruxSAIiGPgYCAAAAAAAAAA==",
"_self": "dbs/ruxSAA==/colls/ruxSAIiGPgY=/docs/ruxSAIiGPgYCAAAAAAAAAA==/",
"_etag": "\"00006000-0000-1900-0000-5f4354320000\"",
"_attachments": "attachments/",
"_ts": 1598247986
}
I don't want _rid, _self,_etag etc, I just want the entities eg:
{
"id": "102",
"sid": "s-102",
"name": "Bena",
"grade": "2"
}
Current code:
CosmosDatabase db1=client.getDatabase("Student");
CosmosContainer c=db1.getContainer("Stu");
CosmosQueryRequestOptions options = new CosmosQueryRequestOptions();
options.setMaxBufferedItemCount(5);
String sql = "SELECT TOP 1 * FROM s ";
CosmosPagedIterable<JSONObject> cpi=c.queryItems(sql, options, JSONObject.class);