Export policy JSON to Excel

Accepts structured policy JSON and returns a downloadable Excel (.xlsx) workbook

posthttps://localhost:10001/api/v1/policies/export

bash

curl --request POST \
  --url 'https://localhost:10001/api/v1/policies/export' \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '{"controls":[{"citations":[{"title":"string","url":"string"}],"controlCode":"string","description":"string","title":"string"}],"description":"string","iconUrl":"string","name":"string","type":"string","version":"string"}'

javascript

const response = await fetch("https://localhost:10001/api/v1/policies/export", {
  method: "POST",
  headers: {
    "Authorization": "Bearer <token>",
    "Content-Type": "application/json"
  },
  body: JSON.stringify({
    "controls": [
      {
        "citations": [
          {
            "title": "string",
            "url": "string"
          }
        ],
        "controlCode": "string",
        "description": "string",
        "title": "string"
      }
    ],
    "description": "string",
    "iconUrl": "string",
    "name": "string",
    "type": "string",
    "version": "string"
  })
});

console.log(response.status);

typescript

const response = await fetch("https://localhost:10001/api/v1/policies/export", {
  method: "POST",
  headers: {
    "Authorization": "Bearer <token>",
    "Content-Type": "application/json"
  },
  body: JSON.stringify({
    "controls": [
      {
        "citations": [
          {
            "title": "string",
            "url": "string"
          }
        ],
        "controlCode": "string",
        "description": "string",
        "title": "string"
      }
    ],
    "description": "string",
    "iconUrl": "string",
    "name": "string",
    "type": "string",
    "version": "string"
  })
});
if (!response.ok) throw new Error(`${response.status} ${response.statusText}`);

console.log(response.status);

python

import requests

response = requests.post(
    "https://localhost:10001/api/v1/policies/export",
    headers={
        "Authorization": "Bearer <token>",
        "Content-Type": "application/json",
    },
    json={
        "controls": [
            {
                "citations": [
                    {
                        "title": "string",
                        "url": "string",
                    },
                ],
                "controlCode": "string",
                "description": "string",
                "title": "string",
            },
        ],
        "description": "string",
        "iconUrl": "string",
        "name": "string",
        "type": "string",
        "version": "string",
    },
)
response.raise_for_status()
print(response.status_code)

package main

import (
	"fmt"
	"io"
	"net/http"
	"strings"
)

func main() {
	body := strings.NewReader(`{
	  "controls": [
	    {
	      "citations": [
	        {
	          "title": "string",
	          "url": "string"
	        }
	      ],
	      "controlCode": "string",
	      "description": "string",
	      "title": "string"
	    }
	  ],
	  "description": "string",
	  "iconUrl": "string",
	  "name": "string",
	  "type": "string",
	  "version": "string"
	}`)
	req, err := http.NewRequest(http.MethodPost, "https://localhost:10001/api/v1/policies/export", body)
	if err != nil {
		panic(err)
	}
	req.Header.Set("Authorization", "Bearer <token>")
	req.Header.Set("Content-Type", "application/json")

	res, err := http.DefaultClient.Do(req)
	if err != nil {
		panic(err)
	}
	defer res.Body.Close()

	data, err := io.ReadAll(res.Body)
	if err != nil {
		panic(err)
	}
	fmt.Println(res.Status, string(data))
}

java

import java.net.URI;
import java.net.http.HttpClient;
import java.net.http.HttpRequest;
import java.net.http.HttpResponse;

public class Example {
    public static void main(String[] args) throws Exception {
        HttpRequest request = HttpRequest.newBuilder()
            .uri(URI.create("https://localhost:10001/api/v1/policies/export"))
            .header("Authorization", "Bearer <token>")
            .header("Content-Type", "application/json")
            .method("POST", HttpRequest.BodyPublishers.ofString("""
                {
                  "controls": [
                    {
                      "citations": [
                        {
                          "title": "string",
                          "url": "string"
                        }
                      ],
                      "controlCode": "string",
                      "description": "string",
                      "title": "string"
                    }
                  ],
                  "description": "string",
                  "iconUrl": "string",
                  "name": "string",
                  "type": "string",
                  "version": "string"
                }
                """))
            .build();

        HttpResponse<String> response = HttpClient.newHttpClient()
            .send(request, HttpResponse.BodyHandlers.ofString());
        System.out.println(response.statusCode() + " " + response.body());
    }
}

csharp

using System.Net.Http.Headers;
using System.Text;

using var client = new HttpClient();
using var request = new HttpRequestMessage(HttpMethod.Post, "https://localhost:10001/api/v1/policies/export");
request.Headers.Authorization = new AuthenticationHeaderValue("Bearer", "<token>");
request.Content = new StringContent("""
    {
      "controls": [
        {
          "citations": [
            {
              "title": "string",
              "url": "string"
            }
          ],
          "controlCode": "string",
          "description": "string",
          "title": "string"
        }
      ],
      "description": "string",
      "iconUrl": "string",
      "name": "string",
      "type": "string",
      "version": "string"
    }
    """, Encoding.UTF8, "application/json");

using var response = await client.SendAsync(request);
Console.WriteLine($"{(int)response.StatusCode} {await response.Content.ReadAsStringAsync()}");

php

<?php

$ch = curl_init('https://localhost:10001/api/v1/policies/export');
curl_setopt_array($ch, [
    CURLOPT_CUSTOMREQUEST => 'POST',
    CURLOPT_HTTPHEADER => [
        'Authorization: Bearer <token>',
        'Content-Type: application/json',
    ],
    CURLOPT_POSTFIELDS => <<<'JSON'
    {
      "controls": [
        {
          "citations": [
            {
              "title": "string",
              "url": "string"
            }
          ],
          "controlCode": "string",
          "description": "string",
          "title": "string"
        }
      ],
      "description": "string",
      "iconUrl": "string",
      "name": "string",
      "type": "string",
      "version": "string"
    }
    JSON,
    CURLOPT_RETURNTRANSFER => true,
]);

$response = curl_exec($ch);
$status = curl_getinfo($ch, CURLINFO_RESPONSE_CODE);
echo $status . " " . $response . PHP_EOL;

ruby

require "net/http"

uri = URI("https://localhost:10001/api/v1/policies/export")
request = Net::HTTP::Post.new(uri)
request["Authorization"] = "Bearer <token>"
request["Content-Type"] = "application/json"
request.body = <<~'JSON'
  {
    "controls": [
      {
        "citations": [
          {
            "title": "string",
            "url": "string"
          }
        ],
        "controlCode": "string",
        "description": "string",
        "title": "string"
      }
    ],
    "description": "string",
    "iconUrl": "string",
    "name": "string",
    "type": "string",
    "version": "string"
  }
JSON

response = Net::HTTP.start(uri.hostname, uri.port, use_ssl: uri.scheme == "https") do |http|
  http.request(request)
end
puts "#{response.code} #{response.body}"

rust

// Cargo.toml dependencies: reqwest (features "json"), serde_json, tokio (features "full")
use serde_json::json;

#[tokio::main]
async fn main() -> Result<(), Box<dyn std::error::Error>> {
    let response = reqwest::Client::new()
        .post("https://localhost:10001/api/v1/policies/export")
        .header("Authorization", "Bearer <token>")
        .json(&json!({
            "controls": [
                {
                    "citations": [
                        {
                            "title": "string",
                            "url": "string"
                        }
                    ],
                    "controlCode": "string",
                    "description": "string",
                    "title": "string"
                }
            ],
            "description": "string",
            "iconUrl": "string",
            "name": "string",
            "type": "string",
            "version": "string"
        }))
        .send()
        .await?;

    println!("{} {}", response.status(), response.text().await?);
    Ok(())
}

Authorizations

BearerAuth · API key in header "Authorization" — Type "Bearer" followed by a space and JWT token.

Request bodyrequired

Policy data

application/json

controlshandlers.ExportPolicyControlRequest[]
Rendered into the Controls sheet
Show properties
Array of handlers.ExportPolicyControlRequest
- citationscore.Citation[]
  Title/URL pairs in the sheet
  Show properties
  Array of core.Citation
  titlestring
  Up to 255 characters; trimmed
  urlstring
  An absolute http or https URL with a hostname, up to 2048 bytes; trimmed
- controlCodestring
- descriptionstring
- titlestring
descriptionstring
iconUrlstring
namestring
typestring
versionstring

Examplejson

{
  "controls": [
    {
      "citations": [
        {
          "title": "string",
          "url": "string"
        }
      ],
      "controlCode": "string",
      "description": "string",
      "title": "string"
    }
  ],
  "description": "string",
  "iconUrl": "string",
  "name": "string",
  "type": "string",
  "version": "string"
}