I’m trying to SELECT all the fields in the bucket using GET request http://node:8093/query/service?statement=select%20*%20from%20mybucket in N1QL, but the returned JSON does not include the document id, and the blob attachment. What type of query will I used to include them in the result.

N1QL querying id and attachments

newbee September 19, 2019, 3:35am 6

Got this, thank you @jens very helpful as usual. I also add blob_%2F before the image name. Something like this
node/dbname/docid/blob_%2Fimagename

Topic		Replies	Views
Get document _id from N1QL query row SQL++ n1ql	1	2474	June 1, 2017
Retrive Document ID SQL++	1	1466	November 1, 2016
N1ql Select Document by document KEY Golang Couchbase Server n1ql	5	1665	February 7, 2018
Getting the key of the document when querying via N1QL SQL++ query , n1ql , index	2	5033	September 15, 2017
Get the document along with the id SQL++	10	8232	September 12, 2017

N1QL querying id and attachments

Related topics