Exportar planilha
curl --request POST \
--url https://api.olie.ai/api/management/spreadsheet-operations/export/{type} \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"columns": [
"project.id",
"project.name",
"project.customer"
],
"dynamic_forms": [
{
"model": "project"
},
{
"model": "project_funnel",
"id": "019dd427-5d13-71bf-9a09-d75aa2bf4bd7"
}
],
"filters": [
{}
]
}
'import requests
url = "https://api.olie.ai/api/management/spreadsheet-operations/export/{type}"
payload = {
"columns": ["project.id", "project.name", "project.customer"],
"dynamic_forms": [
{ "model": "project" },
{
"model": "project_funnel",
"id": "019dd427-5d13-71bf-9a09-d75aa2bf4bd7"
}
],
"filters": [{}]
}
headers = {
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify({
columns: ['project.id', 'project.name', 'project.customer'],
dynamic_forms: [
{model: 'project'},
{model: 'project_funnel', id: '019dd427-5d13-71bf-9a09-d75aa2bf4bd7'}
],
filters: [{}]
})
};
fetch('https://api.olie.ai/api/management/spreadsheet-operations/export/{type}', 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.olie.ai/api/management/spreadsheet-operations/export/{type}",
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([
'columns' => [
'project.id',
'project.name',
'project.customer'
],
'dynamic_forms' => [
[
'model' => 'project'
],
[
'model' => 'project_funnel',
'id' => '019dd427-5d13-71bf-9a09-d75aa2bf4bd7'
]
],
'filters' => [
[
]
]
]),
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>",
"Content-Type: application/json"
],
]);
$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.olie.ai/api/management/spreadsheet-operations/export/{type}"
payload := strings.NewReader("{\n \"columns\": [\n \"project.id\",\n \"project.name\",\n \"project.customer\"\n ],\n \"dynamic_forms\": [\n {\n \"model\": \"project\"\n },\n {\n \"model\": \"project_funnel\",\n \"id\": \"019dd427-5d13-71bf-9a09-d75aa2bf4bd7\"\n }\n ],\n \"filters\": [\n {}\n ]\n}")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("Authorization", "Bearer <token>")
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.olie.ai/api/management/spreadsheet-operations/export/{type}")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("{\n \"columns\": [\n \"project.id\",\n \"project.name\",\n \"project.customer\"\n ],\n \"dynamic_forms\": [\n {\n \"model\": \"project\"\n },\n {\n \"model\": \"project_funnel\",\n \"id\": \"019dd427-5d13-71bf-9a09-d75aa2bf4bd7\"\n }\n ],\n \"filters\": [\n {}\n ]\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.olie.ai/api/management/spreadsheet-operations/export/{type}")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"columns\": [\n \"project.id\",\n \"project.name\",\n \"project.customer\"\n ],\n \"dynamic_forms\": [\n {\n \"model\": \"project\"\n },\n {\n \"model\": \"project_funnel\",\n \"id\": \"019dd427-5d13-71bf-9a09-d75aa2bf4bd7\"\n }\n ],\n \"filters\": [\n {}\n ]\n}"
response = http.request(request)
puts response.read_body{
"response": true,
"spreadsheet_operation": {
"id": "c8f6c4a2-31af-f523-ad00-47b2ce67491e",
"action": "export",
"type": "project",
"status": "completed",
"total_rows": 120,
"processed_rows": 120,
"percentage": 100,
"errors_count": 0,
"metadata": {},
"file_name": "project_2026-06-01-143022.xlsx",
"initiator_type": "App\\Models\\User",
"initiator_id": "ee989a1d-afe3-4ff7-f4fb-bec440e8b372",
"initiator": {
"id": "7b6c3328-3066-e4e3-ae36-911996a826da",
"name": "string",
"avatar_url": "string"
},
"started_at": "2026-04-23T17:57:57.942Z",
"completed_at": "1980-11-02T01:58:58.018Z",
"created_at": "1950-02-26T12:34:00.424Z",
"updated_at": "1955-03-13T19:55:56.035Z"
}
}spreadsheet-operations
Exportar planilha
Cria uma operação de export assíncrona (XLSX). O body depende do {type} na URL (veja os schemas abaixo).
A operação fica pending e o arquivo fica disponível em GET /spreadsheet-operations/{operation}/download após completed.
POST
/
api
/
management
/
spreadsheet-operations
/
export
/
{type}
Exportar planilha
curl --request POST \
--url https://api.olie.ai/api/management/spreadsheet-operations/export/{type} \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"columns": [
"project.id",
"project.name",
"project.customer"
],
"dynamic_forms": [
{
"model": "project"
},
{
"model": "project_funnel",
"id": "019dd427-5d13-71bf-9a09-d75aa2bf4bd7"
}
],
"filters": [
{}
]
}
'import requests
url = "https://api.olie.ai/api/management/spreadsheet-operations/export/{type}"
payload = {
"columns": ["project.id", "project.name", "project.customer"],
"dynamic_forms": [
{ "model": "project" },
{
"model": "project_funnel",
"id": "019dd427-5d13-71bf-9a09-d75aa2bf4bd7"
}
],
"filters": [{}]
}
headers = {
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify({
columns: ['project.id', 'project.name', 'project.customer'],
dynamic_forms: [
{model: 'project'},
{model: 'project_funnel', id: '019dd427-5d13-71bf-9a09-d75aa2bf4bd7'}
],
filters: [{}]
})
};
fetch('https://api.olie.ai/api/management/spreadsheet-operations/export/{type}', 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.olie.ai/api/management/spreadsheet-operations/export/{type}",
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([
'columns' => [
'project.id',
'project.name',
'project.customer'
],
'dynamic_forms' => [
[
'model' => 'project'
],
[
'model' => 'project_funnel',
'id' => '019dd427-5d13-71bf-9a09-d75aa2bf4bd7'
]
],
'filters' => [
[
]
]
]),
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>",
"Content-Type: application/json"
],
]);
$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.olie.ai/api/management/spreadsheet-operations/export/{type}"
payload := strings.NewReader("{\n \"columns\": [\n \"project.id\",\n \"project.name\",\n \"project.customer\"\n ],\n \"dynamic_forms\": [\n {\n \"model\": \"project\"\n },\n {\n \"model\": \"project_funnel\",\n \"id\": \"019dd427-5d13-71bf-9a09-d75aa2bf4bd7\"\n }\n ],\n \"filters\": [\n {}\n ]\n}")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("Authorization", "Bearer <token>")
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.olie.ai/api/management/spreadsheet-operations/export/{type}")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("{\n \"columns\": [\n \"project.id\",\n \"project.name\",\n \"project.customer\"\n ],\n \"dynamic_forms\": [\n {\n \"model\": \"project\"\n },\n {\n \"model\": \"project_funnel\",\n \"id\": \"019dd427-5d13-71bf-9a09-d75aa2bf4bd7\"\n }\n ],\n \"filters\": [\n {}\n ]\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.olie.ai/api/management/spreadsheet-operations/export/{type}")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"columns\": [\n \"project.id\",\n \"project.name\",\n \"project.customer\"\n ],\n \"dynamic_forms\": [\n {\n \"model\": \"project\"\n },\n {\n \"model\": \"project_funnel\",\n \"id\": \"019dd427-5d13-71bf-9a09-d75aa2bf4bd7\"\n }\n ],\n \"filters\": [\n {}\n ]\n}"
response = http.request(request)
puts response.read_body{
"response": true,
"spreadsheet_operation": {
"id": "c8f6c4a2-31af-f523-ad00-47b2ce67491e",
"action": "export",
"type": "project",
"status": "completed",
"total_rows": 120,
"processed_rows": 120,
"percentage": 100,
"errors_count": 0,
"metadata": {},
"file_name": "project_2026-06-01-143022.xlsx",
"initiator_type": "App\\Models\\User",
"initiator_id": "ee989a1d-afe3-4ff7-f4fb-bec440e8b372",
"initiator": {
"id": "7b6c3328-3066-e4e3-ae36-911996a826da",
"name": "string",
"avatar_url": "string"
},
"started_at": "2026-04-23T17:57:57.942Z",
"completed_at": "1980-11-02T01:58:58.018Z",
"created_at": "1950-02-26T12:34:00.424Z",
"updated_at": "1955-03-13T19:55:56.035Z"
}
}Authorizations
Bearer authentication header of the form Bearer <token>, where <token> is your auth token.
Path Parameters
Tipo de exportação: project, customer, contact, form_answer, answer_history, agent_execution ou project_execution.
Available options:
project, customer, contact, form_answer, answer_history, agent_execution, project_execution Body
application/json
- Export Project
- Export Customer
- Export Contact
- Export Form Answer
- Export Answer History
- Export Agent Execution
- Export Project Execution
Payload para POST /export/project.
Chaves das colunas (deve incluir todas as requiredKeys do catálogo em GET /export/{type}/columns).
Example:
[
"project.id",
"project.name",
"project.customer"
]
Formulários dinâmicos opcionais que entram no layout e no payload de exportação.
Show child attributes
Show child attributes
Example:
[
{ "model": "project" },
{
"model": "project_funnel",
"id": "019dd427-5d13-71bf-9a09-d75aa2bf4bd7"
}
]
Busca avançada (array de filtros).
Was this page helpful?
⌘I