Preview Delete By Metadata
curl --request POST \
--url https://api.fieldwise.ai/api/v1/documents/delete/preview \
--header 'Content-Type: application/json' \
--header 'X-API-Key: <api-key>' \
--data '
{
"created_at_filter": {
"$gte": "2024-01-01T00:00:00",
"$lt": "2024-12-31T23:59:59"
},
"metadata_filter": {
"$or": [
{
"category": "finance"
},
{
"$and": [
{
"status": "archived"
},
{
"age": {
"$gt": 365
}
}
]
}
]
},
"updated_at_filter": {
"$gte": "2024-01-01T00:00:00",
"$lt": "2024-12-31T23:59:59"
}
}
'import requests
url = "https://api.fieldwise.ai/api/v1/documents/delete/preview"
payload = {
"created_at_filter": {
"$gte": "2024-01-01T00:00:00",
"$lt": "2024-12-31T23:59:59"
},
"metadata_filter": { "$or": [{ "category": "finance" }, { "$and": [{ "status": "archived" }, { "age": { "$gt": 365 } }] }] },
"updated_at_filter": {
"$gte": "2024-01-01T00:00:00",
"$lt": "2024-12-31T23:59:59"
}
}
headers = {
"X-API-Key": "<api-key>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {'X-API-Key': '<api-key>', 'Content-Type': 'application/json'},
body: JSON.stringify({
created_at_filter: {$gte: '2024-01-01T00:00:00', $lt: '2024-12-31T23:59:59'},
metadata_filter: {
$or: [{category: 'finance'}, {$and: [{status: 'archived'}, {age: {$gt: 365}}]}]
},
updated_at_filter: {$gte: '2024-01-01T00:00:00', $lt: '2024-12-31T23:59:59'}
})
};
fetch('https://api.fieldwise.ai/api/v1/documents/delete/preview', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.fieldwise.ai/api/v1/documents/delete/preview",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
'created_at_filter' => [
'$gte' => '2024-01-01T00:00:00',
'$lt' => '2024-12-31T23:59:59'
],
'metadata_filter' => [
'$or' => [
[
'category' => 'finance'
],
[
'$and' => [
[
'status' => 'archived'
],
[
'age' => [
'$gt' => 365
]
]
]
]
]
],
'updated_at_filter' => [
'$gte' => '2024-01-01T00:00:00',
'$lt' => '2024-12-31T23:59:59'
]
]),
CURLOPT_HTTPHEADER => [
"Content-Type: application/json",
"X-API-Key: <api-key>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://api.fieldwise.ai/api/v1/documents/delete/preview"
payload := strings.NewReader("{\n \"created_at_filter\": {\n \"$gte\": \"2024-01-01T00:00:00\",\n \"$lt\": \"2024-12-31T23:59:59\"\n },\n \"metadata_filter\": {\n \"$or\": [\n {\n \"category\": \"finance\"\n },\n {\n \"$and\": [\n {\n \"status\": \"archived\"\n },\n {\n \"age\": {\n \"$gt\": 365\n }\n }\n ]\n }\n ]\n },\n \"updated_at_filter\": {\n \"$gte\": \"2024-01-01T00:00:00\",\n \"$lt\": \"2024-12-31T23:59:59\"\n }\n}")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("X-API-Key", "<api-key>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.post("https://api.fieldwise.ai/api/v1/documents/delete/preview")
.header("X-API-Key", "<api-key>")
.header("Content-Type", "application/json")
.body("{\n \"created_at_filter\": {\n \"$gte\": \"2024-01-01T00:00:00\",\n \"$lt\": \"2024-12-31T23:59:59\"\n },\n \"metadata_filter\": {\n \"$or\": [\n {\n \"category\": \"finance\"\n },\n {\n \"$and\": [\n {\n \"status\": \"archived\"\n },\n {\n \"age\": {\n \"$gt\": 365\n }\n }\n ]\n }\n ]\n },\n \"updated_at_filter\": {\n \"$gte\": \"2024-01-01T00:00:00\",\n \"$lt\": \"2024-12-31T23:59:59\"\n }\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.fieldwise.ai/api/v1/documents/delete/preview")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["X-API-Key"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"created_at_filter\": {\n \"$gte\": \"2024-01-01T00:00:00\",\n \"$lt\": \"2024-12-31T23:59:59\"\n },\n \"metadata_filter\": {\n \"$or\": [\n {\n \"category\": \"finance\"\n },\n {\n \"$and\": [\n {\n \"status\": \"archived\"\n },\n {\n \"age\": {\n \"$gt\": 365\n }\n }\n ]\n }\n ]\n },\n \"updated_at_filter\": {\n \"$gte\": \"2024-01-01T00:00:00\",\n \"$lt\": \"2024-12-31T23:59:59\"\n }\n}"
response = http.request(request)
puts response.read_body{
"data": {
"document_count": 123,
"document_ids": [
123
]
},
"success": true,
"error": {
"error_code": "RESOURCE_NOT_FOUND",
"message": "Resource not found"
},
"meta": {
"timestamp": "2023-11-07T05:31:56Z",
"version": "1.0"
}
}{
"error_code": "RESOURCE_NOT_FOUND",
"message": "Resource not found"
}{
"error_code": "RESOURCE_NOT_FOUND",
"message": "Resource not found"
}{
"detail": [
{
"loc": [
"<string>"
],
"msg": "<string>",
"type": "<string>"
}
]
}{
"error_code": "RESOURCE_NOT_FOUND",
"message": "Resource not found"
}Documents
Preview Delete By Metadata
Preview how many documents would be deleted by the metadata filter.
POST
/
api
/
v1
/
documents
/
delete
/
preview
Preview Delete By Metadata
curl --request POST \
--url https://api.fieldwise.ai/api/v1/documents/delete/preview \
--header 'Content-Type: application/json' \
--header 'X-API-Key: <api-key>' \
--data '
{
"created_at_filter": {
"$gte": "2024-01-01T00:00:00",
"$lt": "2024-12-31T23:59:59"
},
"metadata_filter": {
"$or": [
{
"category": "finance"
},
{
"$and": [
{
"status": "archived"
},
{
"age": {
"$gt": 365
}
}
]
}
]
},
"updated_at_filter": {
"$gte": "2024-01-01T00:00:00",
"$lt": "2024-12-31T23:59:59"
}
}
'import requests
url = "https://api.fieldwise.ai/api/v1/documents/delete/preview"
payload = {
"created_at_filter": {
"$gte": "2024-01-01T00:00:00",
"$lt": "2024-12-31T23:59:59"
},
"metadata_filter": { "$or": [{ "category": "finance" }, { "$and": [{ "status": "archived" }, { "age": { "$gt": 365 } }] }] },
"updated_at_filter": {
"$gte": "2024-01-01T00:00:00",
"$lt": "2024-12-31T23:59:59"
}
}
headers = {
"X-API-Key": "<api-key>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {'X-API-Key': '<api-key>', 'Content-Type': 'application/json'},
body: JSON.stringify({
created_at_filter: {$gte: '2024-01-01T00:00:00', $lt: '2024-12-31T23:59:59'},
metadata_filter: {
$or: [{category: 'finance'}, {$and: [{status: 'archived'}, {age: {$gt: 365}}]}]
},
updated_at_filter: {$gte: '2024-01-01T00:00:00', $lt: '2024-12-31T23:59:59'}
})
};
fetch('https://api.fieldwise.ai/api/v1/documents/delete/preview', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.fieldwise.ai/api/v1/documents/delete/preview",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
'created_at_filter' => [
'$gte' => '2024-01-01T00:00:00',
'$lt' => '2024-12-31T23:59:59'
],
'metadata_filter' => [
'$or' => [
[
'category' => 'finance'
],
[
'$and' => [
[
'status' => 'archived'
],
[
'age' => [
'$gt' => 365
]
]
]
]
]
],
'updated_at_filter' => [
'$gte' => '2024-01-01T00:00:00',
'$lt' => '2024-12-31T23:59:59'
]
]),
CURLOPT_HTTPHEADER => [
"Content-Type: application/json",
"X-API-Key: <api-key>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://api.fieldwise.ai/api/v1/documents/delete/preview"
payload := strings.NewReader("{\n \"created_at_filter\": {\n \"$gte\": \"2024-01-01T00:00:00\",\n \"$lt\": \"2024-12-31T23:59:59\"\n },\n \"metadata_filter\": {\n \"$or\": [\n {\n \"category\": \"finance\"\n },\n {\n \"$and\": [\n {\n \"status\": \"archived\"\n },\n {\n \"age\": {\n \"$gt\": 365\n }\n }\n ]\n }\n ]\n },\n \"updated_at_filter\": {\n \"$gte\": \"2024-01-01T00:00:00\",\n \"$lt\": \"2024-12-31T23:59:59\"\n }\n}")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("X-API-Key", "<api-key>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.post("https://api.fieldwise.ai/api/v1/documents/delete/preview")
.header("X-API-Key", "<api-key>")
.header("Content-Type", "application/json")
.body("{\n \"created_at_filter\": {\n \"$gte\": \"2024-01-01T00:00:00\",\n \"$lt\": \"2024-12-31T23:59:59\"\n },\n \"metadata_filter\": {\n \"$or\": [\n {\n \"category\": \"finance\"\n },\n {\n \"$and\": [\n {\n \"status\": \"archived\"\n },\n {\n \"age\": {\n \"$gt\": 365\n }\n }\n ]\n }\n ]\n },\n \"updated_at_filter\": {\n \"$gte\": \"2024-01-01T00:00:00\",\n \"$lt\": \"2024-12-31T23:59:59\"\n }\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.fieldwise.ai/api/v1/documents/delete/preview")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["X-API-Key"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"created_at_filter\": {\n \"$gte\": \"2024-01-01T00:00:00\",\n \"$lt\": \"2024-12-31T23:59:59\"\n },\n \"metadata_filter\": {\n \"$or\": [\n {\n \"category\": \"finance\"\n },\n {\n \"$and\": [\n {\n \"status\": \"archived\"\n },\n {\n \"age\": {\n \"$gt\": 365\n }\n }\n ]\n }\n ]\n },\n \"updated_at_filter\": {\n \"$gte\": \"2024-01-01T00:00:00\",\n \"$lt\": \"2024-12-31T23:59:59\"\n }\n}"
response = http.request(request)
puts response.read_body{
"data": {
"document_count": 123,
"document_ids": [
123
]
},
"success": true,
"error": {
"error_code": "RESOURCE_NOT_FOUND",
"message": "Resource not found"
},
"meta": {
"timestamp": "2023-11-07T05:31:56Z",
"version": "1.0"
}
}{
"error_code": "RESOURCE_NOT_FOUND",
"message": "Resource not found"
}{
"error_code": "RESOURCE_NOT_FOUND",
"message": "Resource not found"
}{
"detail": [
{
"loc": [
"<string>"
],
"msg": "<string>",
"type": "<string>"
}
]
}{
"error_code": "RESOURCE_NOT_FOUND",
"message": "Resource not found"
}Authorizations
Headers
Body
application/json
Request model for deleting documents by metadata filter.
Metadata filters using MongoDB-like query syntax
Filter by created_at database field. Supports operators: $eq, $ne, $gt, $lt, $gte, $lte, $in, $nin. Use ISO date format (e.g., '2024-01-01T00:00:00')
Filter by updated_at database field. Supports operators: $eq, $ne, $gt, $lt, $gte, $lte, $in, $nin. Use ISO date format (e.g., '2024-01-01T00:00:00')
Response
Successful Response
Response data
Show child attributes
Show child attributes
Schema for API error responses.
Show child attributes
Show child attributes
Example:
{
"error_code": "RESOURCE_NOT_FOUND",
"message": "Resource not found"
}
Metadata for API responses
Show child attributes
Show child attributes
⌘I