Request with Authentication — Request Parameter
If a request requires more than one set of credentials, the creds parameter must be used, as in this example.
Request
curl -v http://localhost:8093/query/service \
-d 'statement=SELECT hotel.name, airport.airportname
FROM `travel-sample`.inventory.hotel
JOIN `travel-sample`.inventory.airport
ON hotel.city = airport.city LIMIT 1
& creds=[{"user": "local:simon", "pass": "fizzbuzz"},
{"user": "admin:Administrator", "pass": "password"}]'
Response
{
"requestID": "3c6407ff-0501-475f-b922-0540c329d708",
"signature": {
"airportname": "json",
"name": "json"
},
"results": [
{
"airportname": "Annapolis",
"name": "Sea Ranch Lodge"
}
],
"status": "success",
"metrics": {
"elapsedTime": "73.761259ms",
"executionTime": "73.362629ms",
"resultCount": 1,
"resultSize": 52,
"serviceLoad": 12
}
}