Insert a new record:

curl https://opendata-staging.open1.eu/el/api/action/datastore_upsert \
-H"Authorization:$API_TOKEN" -d '
{
  "resource_id": "bd96be55-5021-4aab-9580-5ae30b60fa88",
  "method": "insert",
  "records: [
    {
      "category_code": "free-form text",
      "name": "free-form text"
    }
  ]
}'

const resp = await fetch(`https://opendata-staging.open1.eu/el/api/action/datastore_upsert`, {
    method: 'POST',
    headers: {
        'content-type': 'application/json',
        authorization: API_TOKEN
    },
    body: JSON.stringify({
        resource_id: 'bd96be55-5021-4aab-9580-5ae30b60fa88',
        method: "insert",
        records: [{
            category_code: "free-form text",
            name: "free-form text"
        }]
    })
await resp.json()

$json = @'
{
  "resource_id": "bd96be55-5021-4aab-9580-5ae30b60fa88",
  "method": "insert",
  "records": [
    {
      "category_code": "free-form text",
      "name": "free-form text"
    }
  ]
}
'@
$response = Invoke-RestMethod https://opendata-staging.open1.eu/el/api/action/datastore_upsert`
  -Method Post -Body $json -Headers @{"Authorization"="$API_TOKEN"}
$response.result.records

from ckanapi import RemoteCKAN

ck = RemoteCKAN('https://opendata-staging.open1.eu/el/', apikey=API_TOKEN)
result = ck.action.datastore_upsert(
    resource_id="bd96be55-5021-4aab-9580-5ae30b60fa88",
    method="insert",
    records=[{
        "category_code": "free-form text",
        "name": "free-form text"
    }]
)

library(httr2)

req <- request("https://opendata-staging.open1.eu/el/api/action/datastore_upsert")
result <- req %>% 
    req_headers(Authorization = API_TOKEN) %>% 
    req_body_json(list(
        resource_id = 'bd96be55-5021-4aab-9580-5ae30b60fa88', 
        method = 'insert',
        records = list(list(
            category_code = "free-form text",
            name = "free-form text"))))
    req_perform %>% 
    resp_body_json

Update an existing record:

curl https://opendata-staging.open1.eu/el/api/action/datastore_upsert \
-H"Authorization:$API_TOKEN" -d '
{
  "resource_id": "bd96be55-5021-4aab-9580-5ae30b60fa88",
  "method": "update",
  "records: [
    {
      "_id": "21",
      "category_code": "free-form text",
      "name": "free-form text"
    }
  ]
}'

const resp = await fetch(`https://opendata-staging.open1.eu/el/api/action/datastore_upsert`, {
    method: 'POST',
    headers: {
        'content-type': 'application/json',
        authorization: API_TOKEN
    },
    body: JSON.stringify({
        resource_id: 'bd96be55-5021-4aab-9580-5ae30b60fa88',
        method: "update",
        records: [{
            _id: "21",
            category_code: "free-form text",
            name: "free-form text"
        }]
    })
await resp.json()

$json = @'
{
  "resource_id": "bd96be55-5021-4aab-9580-5ae30b60fa88",
  "method": "update",
  "records": [
    {
      "_id": "21",
      "category_code": "free-form text",
      "name": "free-form text"
    }
  ]
}
'@
$response = Invoke-RestMethod https://opendata-staging.open1.eu/el/api/action/datastore_upsert`
  -Method Post -Body $json -Headers @{"Authorization"="$API_TOKEN"}
$response.result.records

from ckanapi import RemoteCKAN

ck = RemoteCKAN('https://opendata-staging.open1.eu/el/', apikey=API_TOKEN)
result = ck.action.datastore_upsert(
    resource_id="bd96be55-5021-4aab-9580-5ae30b60fa88",
    method="update",
    records=[{
        "_id": "21",
        "category_code": "free-form text",
        "name": "free-form text"
    }]
)

library(httr2)

req <- request("https://opendata-staging.open1.eu/el/api/action/datastore_upsert")
result <- req %>% 
    req_headers(Authorization = API_TOKEN) %>% 
    req_body_json(list(
        resource_id = 'bd96be55-5021-4aab-9580-5ae30b60fa88', 
        method = 'update',
        records = list(list(
            _id = "21",
            category_code = "free-form text",
            name = "free-form text"))))
    req_perform %>% 
    resp_body_json

"method" defaults to "upsert" i.e. records will be inserted or updated based on the primary key values passed

Delete a record:

curl https://opendata-staging.open1.eu/el/api/action/datastore_records_delete \
-H"Authorization:$API_TOKEN" -d '
{
  "resource_id": "bd96be55-5021-4aab-9580-5ae30b60fa88",
  "filters": {
    "_id": 1
  }
}'

const resp = await fetch(`https://opendata-staging.open1.eu/el/api/action/datastore_records_delete`, {
    method: 'POST',
    headers: {
        'content-type': 'application/json',
        authorization: API_TOKEN
    },
    body: JSON.stringify({
        resource_id: 'bd96be55-5021-4aab-9580-5ae30b60fa88',
        filters: {
            _id: 1
        }
    })
await resp.json()

$json = @'
{
  "resource_id": "bd96be55-5021-4aab-9580-5ae30b60fa88",
  "filters": {
    "_id": 1
  }
}
'@
$response = Invoke-RestMethod https://opendata-staging.open1.eu/el/api/action/datastore_records_delete`
  -Method Post -Body $json -Headers @{"Authorization"="$API_TOKEN"}
$response.result.records

from ckanapi import RemoteCKAN

ck = RemoteCKAN('https://opendata-staging.open1.eu/el/', apikey=API_TOKEN)
result = ck.action.datastore_records_delete(
    resource_id="bd96be55-5021-4aab-9580-5ae30b60fa88",
    filters={
        "_id": 1
    }
)

library(httr2)

req <- request("https://opendata-staging.open1.eu/el/api/action/datastore_records_delete")
result <- req %>% 
    req_headers(Authorization = API_TOKEN) %>% 
    req_body_json(list(
        resource_id = 'bd96be55-5021-4aab-9580-5ae30b60fa88', 
        filters = list(
            _id = 1)))
    req_perform %>% 
    resp_body_json