Start a full database view export from a structured request.

curl --request POST \
  --url https://api.revoengine.com/api/v1/databases/views/{databaseViewId}/exportData \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "count": true,
  "filter": "{\"and\":[{\"field\":\"name\",\"op\":\"ilike\",\"value\":\"Ops\"},{\"field\":\"deletedAt\",\"op\":\"isNull\"}]}",
  "sort": "{\"name\":\"ASC\",\"lastUpdateAt\":\"DESC\"}",
  "distinct": "category,global",
  "fields": "[\"databaseId\",\"name\",{\"fn\":\"COUNT\",\"args\":[\"users.userId\"],\"as\":\"userCount\",\"filterType\":\"number\"}]",
  "joins": "[{\"table\":\"groups_users\",\"alias\":\"gu\",\"type\":\"left\",\"on\":{\"left\":\"gu.groupsGroupId\",\"op\":\"=\",\"right\":\"g.groupId\"}}]",
  "groupBy": "[\"category\",\"global\"]",
  "cast": "{\"userCount\":\"INTEGER\"}",
  "with": "[{\"name\":\"active_groups\",\"query\":{\"from\":{\"table\":\"groups\",\"alias\":\"g\",\"definition\":[]}}}]",
  "debug": false,
  "join": "{\"orders\":[\"customerId\",\"customerId\",\"left\"]}",
  "format": "xlsx",
  "retention": {
    "ttlSeconds": 604800
  },
  "delimiter": "|",
  "boolType": "boolean",
  "emptyNull": true,
  "encodedJson": false,
  "storageDestination": "ROOT",
  "fileName": "contracts-full.xlsx",
  "restricted": false
}
'

const options = {
  method: 'POST',
  headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
  body: JSON.stringify({
    count: true,
    filter: '{"and":[{"field":"name","op":"ilike","value":"Ops"},{"field":"deletedAt","op":"isNull"}]}',
    sort: '{"name":"ASC","lastUpdateAt":"DESC"}',
    distinct: 'category,global',
    fields: '["databaseId","name",{"fn":"COUNT","args":["users.userId"],"as":"userCount","filterType":"number"}]',
    joins: '[{"table":"groups_users","alias":"gu","type":"left","on":{"left":"gu.groupsGroupId","op":"=","right":"g.groupId"}}]',
    groupBy: '["category","global"]',
    cast: '{"userCount":"INTEGER"}',
    with: '[{"name":"active_groups","query":{"from":{"table":"groups","alias":"g","definition":[]}}}]',
    debug: false,
    join: '{"orders":["customerId","customerId","left"]}',
    format: 'xlsx',
    retention: {ttlSeconds: 604800},
    delimiter: '|',
    boolType: 'boolean',
    emptyNull: true,
    encodedJson: false,
    storageDestination: 'ROOT',
    fileName: 'contracts-full.xlsx',
    restricted: false
  })
};

fetch('https://api.revoengine.com/api/v1/databases/views/{databaseViewId}/exportData', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

import requests

url = "https://api.revoengine.com/api/v1/databases/views/{databaseViewId}/exportData"

payload = {
    "count": True,
    "filter": "{\"and\":[{\"field\":\"name\",\"op\":\"ilike\",\"value\":\"Ops\"},{\"field\":\"deletedAt\",\"op\":\"isNull\"}]}",
    "sort": "{\"name\":\"ASC\",\"lastUpdateAt\":\"DESC\"}",
    "distinct": "category,global",
    "fields": "[\"databaseId\",\"name\",{\"fn\":\"COUNT\",\"args\":[\"users.userId\"],\"as\":\"userCount\",\"filterType\":\"number\"}]",
    "joins": "[{\"table\":\"groups_users\",\"alias\":\"gu\",\"type\":\"left\",\"on\":{\"left\":\"gu.groupsGroupId\",\"op\":\"=\",\"right\":\"g.groupId\"}}]",
    "groupBy": "[\"category\",\"global\"]",
    "cast": "{\"userCount\":\"INTEGER\"}",
    "with": "[{\"name\":\"active_groups\",\"query\":{\"from\":{\"table\":\"groups\",\"alias\":\"g\",\"definition\":[]}}}]",
    "debug": False,
    "join": "{\"orders\":[\"customerId\",\"customerId\",\"left\"]}",
    "format": "xlsx",
    "retention": { "ttlSeconds": 604800 },
    "delimiter": "|",
    "boolType": "boolean",
    "emptyNull": True,
    "encodedJson": False,
    "storageDestination": "ROOT",
    "fileName": "contracts-full.xlsx",
    "restricted": False
}
headers = {
    "Authorization": "Bearer <token>",
    "Content-Type": "application/json"
}

response = requests.post(url, json=payload, headers=headers)

print(response.text)