I created a MySQL instance in the Storage module > SQL and in it I created a database called vendas
...
How could I make GET, POST, and DELETE requests in this database using Google Cloud Platform APIs?
I've tried it this way:
GET -> https://www.googleapis.com/sql/v1beta4/projects/projeto1/instances/bd-projeto1/databases/vendas
Only the result is just the instance structure
response.body
{
"kind": "sql#database",
"selfLink": "https://www.googleapis.com/sql/v1beta4/projects/projeto1/instances/bd-projeto1/databases/vendas",
"name": "vendas",
"etag": "\"6fNGoGJ6Wfqdqwsqw02dVapvSvA/rXoe10k2wwFavasdq_rbm8q9WJds\"",
"project": "projeto1",
"instance": "bd-projeto1",
"charset": "utf8",
"collation": "utf8_general_ci"
}
And what I want is a JSON that fetches the records from some database table vendas
, such as the clients table:
{
"id": 1,
"nome": "matheus",
"data_nascimento": "26/12/1996"
}