Insert Documents
Inserts one or more JSON documents into a collection. The collection is created automatically if it does not exist.
Authentication
Requires Api-Key and Api-Secret, or a Glue owner token where the database owner is allowed.
HTTP Request
curl -X POST "https://api.hola.cloud/v1/databases/a1b2c3d4-e5f6-7890-abcd-ef1234567890/collections/users:insert" \
-H "Api-Key: 1abbe476-6ad6-4b97-9cca-6deb6ab2901d" \
-H "Api-Secret: 4bda6d52-762b-4e5d-bed7-85614c13b8bf" \
-H "Content-Type: application/jsonl" \
-d '{"id":"user-1","name":"Alice","role":"admin"}
{"id":"user-2","name":"Bob","role":"member"}'POST /v1/databases/a1b2c3d4-e5f6-7890-abcd-ef1234567890/collections/users:insert HTTP/1.1
Host: api.hola.cloud
Api-Key: 1abbe476-6ad6-4b97-9cca-6deb6ab2901d
Api-Secret: 4bda6d52-762b-4e5d-bed7-85614c13b8bf
Content-Type: application/jsonl
{"id":"user-1","name":"Alice","role":"admin"}
{"id":"user-2","name":"Bob","role":"member"}package main
import (
"fmt"
"io"
"net/http"
"encoding/json"
"strings"
)
func main() {
payload := map[string]any{"id": "user-1", "name": "Alice", "role": "admin"}
bodyBytes, err := json.Marshal(payload)
if err != nil {
panic(err)
}
body := string(bodyBytes)
req, err := http.NewRequest("POST", "https://api.hola.cloud/v1/databases/a1b2c3d4-e5f6-7890-abcd-ef1234567890/collections/users:insert", strings.NewReader(body))
if err != nil {
panic(err)
}
req.Header.Set("Api-Key", "1abbe476-6ad6-4b97-9cca-6deb6ab2901d")
req.Header.Set("Api-Secret", "4bda6d52-762b-4e5d-bed7-85614c13b8bf")
req.Header.Set("Content-Type", "application/jsonl")
resp, err := http.DefaultClient.Do(req)
if err != nil {
panic(err)
}
defer resp.Body.Close()
responseBody, err := io.ReadAll(resp.Body)
if err != nil {
panic(err)
}
fmt.Println(string(responseBody))
}
<?php
$payload = ['id' => 'user-1', 'name' => 'Alice', 'role' => 'admin'];
$body = json_encode($payload);
$ch = curl_init();
curl_setopt_array($ch, [
CURLOPT_URL => 'https://api.hola.cloud/v1/databases/a1b2c3d4-e5f6-7890-abcd-ef1234567890/collections/users:insert',
CURLOPT_RETURNTRANSFER => true,
CURLOPT_CUSTOMREQUEST => 'POST',
CURLOPT_POSTFIELDS => $body,
CURLOPT_HTTPHEADER => [
'Api-Key: 1abbe476-6ad6-4b97-9cca-6deb6ab2901d',
'Api-Secret: 4bda6d52-762b-4e5d-bed7-85614c13b8bf',
'Content-Type: application/jsonl',
],
]);
$response = curl_exec($ch);
if ($response === false) {
throw new Exception(curl_error($ch));
}
curl_close($ch);
echo $response;
import requests
import json
headers = {
"Api-Key": "1abbe476-6ad6-4b97-9cca-6deb6ab2901d",
"Api-Secret": "4bda6d52-762b-4e5d-bed7-85614c13b8bf",
"Content-Type": "application/jsonl",
}
payload = {"id": "user-1", "name": "Alice", "role": "admin"}
body = json.dumps(payload)
response = requests.request(
"POST",
"https://api.hola.cloud/v1/databases/a1b2c3d4-e5f6-7890-abcd-ef1234567890/collections/users:insert",
headers=headers,
data=body
)
print(response.text)
const payload = {"id": "user-1", "name": "Alice", "role": "admin"};
const response = await fetch("https://api.hola.cloud/v1/databases/a1b2c3d4-e5f6-7890-abcd-ef1234567890/collections/users:insert", {
method: "POST",
headers: {
"Api-Key": "1abbe476-6ad6-4b97-9cca-6deb6ab2901d",
"Api-Secret": "4bda6d52-762b-4e5d-bed7-85614c13b8bf",
"Content-Type": "application/jsonl"
},
body: JSON.stringify(payload)
});
console.log(await response.text());
const payload = {"id": "user-1", "name": "Alice", "role": "admin"};
const response = await fetch("https://api.hola.cloud/v1/databases/a1b2c3d4-e5f6-7890-abcd-ef1234567890/collections/users:insert", {
method: "POST",
headers: {
"Api-Key": "1abbe476-6ad6-4b97-9cca-6deb6ab2901d",
"Api-Secret": "4bda6d52-762b-4e5d-bed7-85614c13b8bf",
"Content-Type": "application/jsonl"
},
body: JSON.stringify(payload)
});
const text = await response.text();
console.log(text);
import java.net.URI;
import java.net.http.HttpClient;
import java.net.http.HttpRequest;
import java.net.http.HttpResponse;
import com.fasterxml.jackson.databind.ObjectMapper;
import java.util.Map;
import java.util.List;
public class Main {
public static void main(String[] args) throws Exception {
var payload = Map.of("id", "user-1", "name", "Alice", "role", "admin");
var body = new ObjectMapper().writeValueAsString(payload);
var request = HttpRequest.newBuilder()
.uri(URI.create("https://api.hola.cloud/v1/databases/a1b2c3d4-e5f6-7890-abcd-ef1234567890/collections/users:insert"))
.method("POST", HttpRequest.BodyPublishers.ofString(body))
.header("Api-Key", "1abbe476-6ad6-4b97-9cca-6deb6ab2901d")
.header("Api-Secret", "4bda6d52-762b-4e5d-bed7-85614c13b8bf")
.header("Content-Type", "application/jsonl")
.build();
var response = HttpClient.newHttpClient().send(request, HttpResponse.BodyHandlers.ofString());
System.out.println(response.body());
}
}Response
Status: 201 Created when at least one document is inserted. The response is JSON Lines with the inserted documents.
1{"id":"user-1","name":"Alice","role":"admin"}
2{"id":"user-2","name":"Bob","role":"member"}
If the request body is empty, the response is 204 No Content. Unique index conflicts return 409 Conflict before any response body is written.
Comments