curl --request POST \
  --url https://api-dev.narrative.io/v2/access-rules \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "name": "example_access_rule",
  "display_name": "Example Access Rule",
  "description": "This is an example access rule.",
  "image": "https://example.com/image.png",
  "tags": [
    "tag1",
    "tag2"
  ],
  "nql": "SELECT tar.\"maid\" FROM company_data.\"11370\" tar",
  "collaborators": {
    "query": {
      "type": "inclusion",
      "company_ids": [
        789
      ]
    },
    "view": {
      "type": "all"
    }
  },
  "price_cpm_usd": 10
}
'

import requests

url = "https://api-dev.narrative.io/v2/access-rules"

payload = {
    "name": "example_access_rule",
    "display_name": "Example Access Rule",
    "description": "This is an example access rule.",
    "image": "https://example.com/image.png",
    "tags": ["tag1", "tag2"],
    "nql": "SELECT tar.\"maid\" FROM company_data.\"11370\" tar",
    "collaborators": {
        "query": {
            "type": "inclusion",
            "company_ids": [789]
        },
        "view": { "type": "all" }
    },
    "price_cpm_usd": 10
}
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({
    name: 'example_access_rule',
    display_name: 'Example Access Rule',
    description: 'This is an example access rule.',
    image: 'https://example.com/image.png',
    tags: ['tag1', 'tag2'],
    nql: 'SELECT tar."maid" FROM company_data."11370" tar',
    collaborators: {query: {type: 'inclusion', company_ids: [789]}, view: {type: 'all'}},
    price_cpm_usd: 10
  })
};

fetch('https://api-dev.narrative.io/v2/access-rules', 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-dev.narrative.io/v2/access-rules",
  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([
    'name' => 'example_access_rule',
    'display_name' => 'Example Access Rule',
    'description' => 'This is an example access rule.',
    'image' => 'https://example.com/image.png',
    'tags' => [
        'tag1',
        'tag2'
    ],
    'nql' => 'SELECT tar."maid" FROM company_data."11370" tar',
    'collaborators' => [
        'query' => [
                'type' => 'inclusion',
                'company_ids' => [
                                789
                ]
        ],
        'view' => [
                'type' => 'all'
        ]
    ],
    'price_cpm_usd' => 10
  ]),
  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-dev.narrative.io/v2/access-rules"

	payload := strings.NewReader("{\n  \"name\": \"example_access_rule\",\n  \"display_name\": \"Example Access Rule\",\n  \"description\": \"This is an example access rule.\",\n  \"image\": \"https://example.com/image.png\",\n  \"tags\": [\n    \"tag1\",\n    \"tag2\"\n  ],\n  \"nql\": \"SELECT tar.\\\"maid\\\" FROM company_data.\\\"11370\\\" tar\",\n  \"collaborators\": {\n    \"query\": {\n      \"type\": \"inclusion\",\n      \"company_ids\": [\n        789\n      ]\n    },\n    \"view\": {\n      \"type\": \"all\"\n    }\n  },\n  \"price_cpm_usd\": 10\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-dev.narrative.io/v2/access-rules")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"name\": \"example_access_rule\",\n  \"display_name\": \"Example Access Rule\",\n  \"description\": \"This is an example access rule.\",\n  \"image\": \"https://example.com/image.png\",\n  \"tags\": [\n    \"tag1\",\n    \"tag2\"\n  ],\n  \"nql\": \"SELECT tar.\\\"maid\\\" FROM company_data.\\\"11370\\\" tar\",\n  \"collaborators\": {\n    \"query\": {\n      \"type\": \"inclusion\",\n      \"company_ids\": [\n        789\n      ]\n    },\n    \"view\": {\n      \"type\": \"all\"\n    }\n  },\n  \"price_cpm_usd\": 10\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://api-dev.narrative.io/v2/access-rules")

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  \"name\": \"example_access_rule\",\n  \"display_name\": \"Example Access Rule\",\n  \"description\": \"This is an example access rule.\",\n  \"image\": \"https://example.com/image.png\",\n  \"tags\": [\n    \"tag1\",\n    \"tag2\"\n  ],\n  \"nql\": \"SELECT tar.\\\"maid\\\" FROM company_data.\\\"11370\\\" tar\",\n  \"collaborators\": {\n    \"query\": {\n      \"type\": \"inclusion\",\n      \"company_ids\": [\n        789\n      ]\n    },\n    \"view\": {\n      \"type\": \"all\"\n    }\n  },\n  \"price_cpm_usd\": 10\n}"

response = http.request(request)
puts response.read_body

{
  "name": "access_rule_ebc86610_0907_4374_8fc9_be360f0ff8d0",
  "id": 1,
  "company_id": 1,
  "company_name": "company",
  "company_slug": "company_slug_60a4e678_1d56_48a7_8b8b_4e1d689b11a6",
  "data_plane_id": "f79cbdae-4848-47ca-95e8-69588364d185",
  "display_name": "display name",
  "description": "description",
  "image": "https://narrative.test/1.png",
  "status": "active",
  "tags": [
    "_nio_access_rule"
  ],
  "nql": "select company_data.\"1\".columnA from company_data.\"1\" WHERE columnA = columnB",
  "schema": {
    "type": "object",
    "properties": {
      "columnA": {
        "display_name": "columnA",
        "type": "string"
      }
    },
    "required": [
      "columnA"
    ]
  },
  "collaborators": {
    "query": {
      "type": "inclusion",
      "company_ids": [
        789
      ]
    },
    "view": {
      "type": "all"
    }
  },
  "price_cpm_usd": 1000.054,
  "metadata": {
    "created_at": "2023-12-14T21:36:51.847901",
    "created_by": 42,
    "updated_at": "2023-12-14T21:36:51.847901",
    "updated_by": null
  },
  "dataset_ids": [
    42
  ],
  "type": "owned",
  "is_owned": true,
  "mappings": [
    {
      "attribute_id": 42,
      "attribute_name": "id",
      "properties": [
        "id.type",
        "id.value"
      ]
    }
  ],
  "query_policy": null
}

{
  "error": "Unauthorized",
  "error_description": "You are not authorized to use this endpoint."
}

{
  "type": null,
  "title": "Failed to Parse Query",
  "status": 400,
  "detail": "Invalid query format.",
  "instance": "/nql/validate",
  "log_id": "c06fea02-0950-45c6-aaff-07ab07c0d04c",
  "debug": null
}

{
  "title": "Unsupported Type Error: DECIMAL",
  "status": 422,
  "detail": "Column 'decimal_value' has type DECIMAL, which is not supported as an output column of a materialized view. CAST the column to a supported type such as DOUBLE, BIGINT, VARCHAR, BOOLEAN, or TIMESTAMP.",
  "instance": "/v2/accessrules/create",
  "log_id": "c904b703-d41e-4372-9276-9f4bdc8ad031",
  "debug": {
    "column": "decimal_value",
    "type_name": "DECIMAL"
  }
}