curl --request GET \
--url https://api.jurichat.com/funnel-column/report \
--header 'x-jurichat-api-key: <api-key>'import requests
url = "https://api.jurichat.com/funnel-column/report"
headers = {"x-jurichat-api-key": "<api-key>"}
response = requests.get(url, headers=headers)
print(response.text)const options = {method: 'GET', headers: {'x-jurichat-api-key': '<api-key>'}};
fetch('https://api.jurichat.com/funnel-column/report', 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.jurichat.com/funnel-column/report",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "GET",
CURLOPT_HTTPHEADER => [
"x-jurichat-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"
"net/http"
"io"
)
func main() {
url := "https://api.jurichat.com/funnel-column/report"
req, _ := http.NewRequest("GET", url, nil)
req.Header.Add("x-jurichat-api-key", "<api-key>")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.get("https://api.jurichat.com/funnel-column/report")
.header("x-jurichat-api-key", "<api-key>")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.jurichat.com/funnel-column/report")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Get.new(url)
request["x-jurichat-api-key"] = '<api-key>'
response = http.request(request)
puts response.read_body{
"funnel": {
"id": "<string>",
"name": "<string>"
},
"data": [
{
"id": "<string>",
"columnId": "<string>",
"columnName": "<string>",
"channel": "<string>",
"user": {
"id": "<string>",
"name": "<string>",
"imageUrl": "<string>"
},
"person": {
"id": "<string>",
"name": "<string>",
"email": "<string>",
"phoneNumber": "<string>"
},
"customFields": [
{
"id": "<string>",
"value": "<string>"
}
],
"tags": [
{
"id": "<string>",
"name": "<string>"
}
],
"legalArea": {
"id": "<string>",
"name": "<string>"
},
"createdAt": "2023-11-07T05:31:56Z",
"lastInteractionAt": "2023-11-07T05:31:56Z"
}
]
}{
"message": "<string>",
"statusCode": 123,
"code": "<string>",
"details": "<string>"
}Gerar dados do relatório do funil
Retorna os dados filtrados do funil de CRM usados nos relatórios em PDF e Excel.
curl --request GET \
--url https://api.jurichat.com/funnel-column/report \
--header 'x-jurichat-api-key: <api-key>'import requests
url = "https://api.jurichat.com/funnel-column/report"
headers = {"x-jurichat-api-key": "<api-key>"}
response = requests.get(url, headers=headers)
print(response.text)const options = {method: 'GET', headers: {'x-jurichat-api-key': '<api-key>'}};
fetch('https://api.jurichat.com/funnel-column/report', 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.jurichat.com/funnel-column/report",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "GET",
CURLOPT_HTTPHEADER => [
"x-jurichat-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"
"net/http"
"io"
)
func main() {
url := "https://api.jurichat.com/funnel-column/report"
req, _ := http.NewRequest("GET", url, nil)
req.Header.Add("x-jurichat-api-key", "<api-key>")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.get("https://api.jurichat.com/funnel-column/report")
.header("x-jurichat-api-key", "<api-key>")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.jurichat.com/funnel-column/report")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Get.new(url)
request["x-jurichat-api-key"] = '<api-key>'
response = http.request(request)
puts response.read_body{
"funnel": {
"id": "<string>",
"name": "<string>"
},
"data": [
{
"id": "<string>",
"columnId": "<string>",
"columnName": "<string>",
"channel": "<string>",
"user": {
"id": "<string>",
"name": "<string>",
"imageUrl": "<string>"
},
"person": {
"id": "<string>",
"name": "<string>",
"email": "<string>",
"phoneNumber": "<string>"
},
"customFields": [
{
"id": "<string>",
"value": "<string>"
}
],
"tags": [
{
"id": "<string>",
"name": "<string>"
}
],
"legalArea": {
"id": "<string>",
"name": "<string>"
},
"createdAt": "2023-11-07T05:31:56Z",
"lastInteractionAt": "2023-11-07T05:31:56Z"
}
]
}{
"message": "<string>",
"statusCode": 123,
"code": "<string>",
"details": "<string>"
}Authorizations
Chave de API do escritório (criada no painel). Envie o valor no header x-jurichat-api-key.
Query Parameters
ID do funil.
^[cC][^\s-]{8,}$Início do período (ISO 8601, meia-noite local). Exige type. Mesmo formato do filtro do board.
Fim do período (ISO 8601, meia-noite local do último dia). Opcional; sem end filtra a partir de start.
Campo filtrado por start/end: criação do card no CRM ou última mensagem.
createdAt, lastInteraction Legado: filtra cards criados no dia desta data (ISO 8601). Prefira start/end + type.
Legado: filtra pelo último contato no dia desta data (ISO 8601). Prefira start/end + type.
Filtra pelo responsável do card.
^[cC][^\s-]{8,}$IDs de etiquetas separados por vírgula.
Filtra por uma coluna do funil.
^[cC][^\s-]{8,}$Filtra pelo canal do lead.
Busca por nome, e-mail ou telefone do contato.
Quando verdadeiro, considera apenas os cards cujo contato tem mensagem não lida.
Campo de ordenação dos cards.
manual, name, createdAt, lastInteraction Direção da ordenação.
asc, desc