Update a table field

curl --request PATCH \
  --url https://api.useinvent.com/orgs/{org_id}/tables/{table_id}/fields/{field_id} \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "key": "<string>",
  "schema": {
    "type": "file",
    "name": "<string>",
    "description": "<string>",
    "optional": true,
    "array": true,
    "placeholder": "<string>",
    "display": {},
    "order": 1,
    "link": "<string>",
    "metadata": {},
    "allowed_modes": [],
    "broadcast_field": true,
    "broadcast_exposed": true,
    "integration_field": true,
    "display_field": true,
    "conditions": [
      {
        "field": "<string>",
        "value": "<unknown>"
      }
    ],
    "hidden": true,
    "picker": {
      "type": "google_drive",
      "views": [],
      "selectable_mime_types": [
        "<string>"
      ]
    },
    "requires": [
      "<string>"
    ],
    "disable_variables": true,
    "allowed_types": [
      "<string>"
    ],
    "visibility": "PRIVATE",
    "default": {
      "id": "<string>",
      "file_path": "<string>",
      "file_filename": "document.pdf",
      "file_size": 1024,
      "file_mimetype": "application/pdf",
      "file_url": "<string>",
      "created_at": "2023-11-07T05:31:56Z"
    }
  },
  "config": {},
  "icon": "<string>",
  "connection_id": "<string>",
  "unique": true,
  "readonly": true,
  "archived": true
}
'

import requests

url = "https://api.useinvent.com/orgs/{org_id}/tables/{table_id}/fields/{field_id}"

payload = {
    "key": "<string>",
    "schema": {
        "type": "file",
        "name": "<string>",
        "description": "<string>",
        "optional": True,
        "array": True,
        "placeholder": "<string>",
        "display": {},
        "order": 1,
        "link": "<string>",
        "metadata": {},
        "allowed_modes": [],
        "broadcast_field": True,
        "broadcast_exposed": True,
        "integration_field": True,
        "display_field": True,
        "conditions": [
            {
                "field": "<string>",
                "value": "<unknown>"
            }
        ],
        "hidden": True,
        "picker": {
            "type": "google_drive",
            "views": [],
            "selectable_mime_types": ["<string>"]
        },
        "requires": ["<string>"],
        "disable_variables": True,
        "allowed_types": ["<string>"],
        "visibility": "PRIVATE",
        "default": {
            "id": "<string>",
            "file_path": "<string>",
            "file_filename": "document.pdf",
            "file_size": 1024,
            "file_mimetype": "application/pdf",
            "file_url": "<string>",
            "created_at": "2023-11-07T05:31:56Z"
        }
    },
    "config": {},
    "icon": "<string>",
    "connection_id": "<string>",
    "unique": True,
    "readonly": True,
    "archived": True
}
headers = {
    "Authorization": "Bearer <token>",
    "Content-Type": "application/json"
}

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

print(response.text)

const options = {
  method: 'PATCH',
  headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
  body: JSON.stringify({
    key: '<string>',
    schema: {
      type: 'file',
      name: '<string>',
      description: '<string>',
      optional: true,
      array: true,
      placeholder: '<string>',
      display: {},
      order: 1,
      link: '<string>',
      metadata: {},
      allowed_modes: [],
      broadcast_field: true,
      broadcast_exposed: true,
      integration_field: true,
      display_field: true,
      conditions: [{field: '<string>', value: '<unknown>'}],
      hidden: true,
      picker: {type: 'google_drive', views: [], selectable_mime_types: ['<string>']},
      requires: ['<string>'],
      disable_variables: true,
      allowed_types: ['<string>'],
      visibility: 'PRIVATE',
      default: {
        id: '<string>',
        file_path: '<string>',
        file_filename: 'document.pdf',
        file_size: 1024,
        file_mimetype: 'application/pdf',
        file_url: '<string>',
        created_at: '2023-11-07T05:31:56Z'
      }
    },
    config: {},
    icon: '<string>',
    connection_id: '<string>',
    unique: true,
    readonly: true,
    archived: true
  })
};

fetch('https://api.useinvent.com/orgs/{org_id}/tables/{table_id}/fields/{field_id}', 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.useinvent.com/orgs/{org_id}/tables/{table_id}/fields/{field_id}",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "PATCH",
  CURLOPT_POSTFIELDS => json_encode([
    'key' => '<string>',
    'schema' => [
        'type' => 'file',
        'name' => '<string>',
        'description' => '<string>',
        'optional' => true,
        'array' => true,
        'placeholder' => '<string>',
        'display' => [
                
        ],
        'order' => 1,
        'link' => '<string>',
        'metadata' => [
                
        ],
        'allowed_modes' => [
                
        ],
        'broadcast_field' => true,
        'broadcast_exposed' => true,
        'integration_field' => true,
        'display_field' => true,
        'conditions' => [
                [
                                'field' => '<string>',
                                'value' => '<unknown>'
                ]
        ],
        'hidden' => true,
        'picker' => [
                'type' => 'google_drive',
                'views' => [
                                
                ],
                'selectable_mime_types' => [
                                '<string>'
                ]
        ],
        'requires' => [
                '<string>'
        ],
        'disable_variables' => true,
        'allowed_types' => [
                '<string>'
        ],
        'visibility' => 'PRIVATE',
        'default' => [
                'id' => '<string>',
                'file_path' => '<string>',
                'file_filename' => 'document.pdf',
                'file_size' => 1024,
                'file_mimetype' => 'application/pdf',
                'file_url' => '<string>',
                'created_at' => '2023-11-07T05:31:56Z'
        ]
    ],
    'config' => [
        
    ],
    'icon' => '<string>',
    'connection_id' => '<string>',
    'unique' => true,
    'readonly' => true,
    'archived' => true
  ]),
  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.useinvent.com/orgs/{org_id}/tables/{table_id}/fields/{field_id}"

	payload := strings.NewReader("{\n  \"key\": \"<string>\",\n  \"schema\": {\n    \"type\": \"file\",\n    \"name\": \"<string>\",\n    \"description\": \"<string>\",\n    \"optional\": true,\n    \"array\": true,\n    \"placeholder\": \"<string>\",\n    \"display\": {},\n    \"order\": 1,\n    \"link\": \"<string>\",\n    \"metadata\": {},\n    \"allowed_modes\": [],\n    \"broadcast_field\": true,\n    \"broadcast_exposed\": true,\n    \"integration_field\": true,\n    \"display_field\": true,\n    \"conditions\": [\n      {\n        \"field\": \"<string>\",\n        \"value\": \"<unknown>\"\n      }\n    ],\n    \"hidden\": true,\n    \"picker\": {\n      \"type\": \"google_drive\",\n      \"views\": [],\n      \"selectable_mime_types\": [\n        \"<string>\"\n      ]\n    },\n    \"requires\": [\n      \"<string>\"\n    ],\n    \"disable_variables\": true,\n    \"allowed_types\": [\n      \"<string>\"\n    ],\n    \"visibility\": \"PRIVATE\",\n    \"default\": {\n      \"id\": \"<string>\",\n      \"file_path\": \"<string>\",\n      \"file_filename\": \"document.pdf\",\n      \"file_size\": 1024,\n      \"file_mimetype\": \"application/pdf\",\n      \"file_url\": \"<string>\",\n      \"created_at\": \"2023-11-07T05:31:56Z\"\n    }\n  },\n  \"config\": {},\n  \"icon\": \"<string>\",\n  \"connection_id\": \"<string>\",\n  \"unique\": true,\n  \"readonly\": true,\n  \"archived\": true\n}")

	req, _ := http.NewRequest("PATCH", 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.patch("https://api.useinvent.com/orgs/{org_id}/tables/{table_id}/fields/{field_id}")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"key\": \"<string>\",\n  \"schema\": {\n    \"type\": \"file\",\n    \"name\": \"<string>\",\n    \"description\": \"<string>\",\n    \"optional\": true,\n    \"array\": true,\n    \"placeholder\": \"<string>\",\n    \"display\": {},\n    \"order\": 1,\n    \"link\": \"<string>\",\n    \"metadata\": {},\n    \"allowed_modes\": [],\n    \"broadcast_field\": true,\n    \"broadcast_exposed\": true,\n    \"integration_field\": true,\n    \"display_field\": true,\n    \"conditions\": [\n      {\n        \"field\": \"<string>\",\n        \"value\": \"<unknown>\"\n      }\n    ],\n    \"hidden\": true,\n    \"picker\": {\n      \"type\": \"google_drive\",\n      \"views\": [],\n      \"selectable_mime_types\": [\n        \"<string>\"\n      ]\n    },\n    \"requires\": [\n      \"<string>\"\n    ],\n    \"disable_variables\": true,\n    \"allowed_types\": [\n      \"<string>\"\n    ],\n    \"visibility\": \"PRIVATE\",\n    \"default\": {\n      \"id\": \"<string>\",\n      \"file_path\": \"<string>\",\n      \"file_filename\": \"document.pdf\",\n      \"file_size\": 1024,\n      \"file_mimetype\": \"application/pdf\",\n      \"file_url\": \"<string>\",\n      \"created_at\": \"2023-11-07T05:31:56Z\"\n    }\n  },\n  \"config\": {},\n  \"icon\": \"<string>\",\n  \"connection_id\": \"<string>\",\n  \"unique\": true,\n  \"readonly\": true,\n  \"archived\": true\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://api.useinvent.com/orgs/{org_id}/tables/{table_id}/fields/{field_id}")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Patch.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n  \"key\": \"<string>\",\n  \"schema\": {\n    \"type\": \"file\",\n    \"name\": \"<string>\",\n    \"description\": \"<string>\",\n    \"optional\": true,\n    \"array\": true,\n    \"placeholder\": \"<string>\",\n    \"display\": {},\n    \"order\": 1,\n    \"link\": \"<string>\",\n    \"metadata\": {},\n    \"allowed_modes\": [],\n    \"broadcast_field\": true,\n    \"broadcast_exposed\": true,\n    \"integration_field\": true,\n    \"display_field\": true,\n    \"conditions\": [\n      {\n        \"field\": \"<string>\",\n        \"value\": \"<unknown>\"\n      }\n    ],\n    \"hidden\": true,\n    \"picker\": {\n      \"type\": \"google_drive\",\n      \"views\": [],\n      \"selectable_mime_types\": [\n        \"<string>\"\n      ]\n    },\n    \"requires\": [\n      \"<string>\"\n    ],\n    \"disable_variables\": true,\n    \"allowed_types\": [\n      \"<string>\"\n    ],\n    \"visibility\": \"PRIVATE\",\n    \"default\": {\n      \"id\": \"<string>\",\n      \"file_path\": \"<string>\",\n      \"file_filename\": \"document.pdf\",\n      \"file_size\": 1024,\n      \"file_mimetype\": \"application/pdf\",\n      \"file_url\": \"<string>\",\n      \"created_at\": \"2023-11-07T05:31:56Z\"\n    }\n  },\n  \"config\": {},\n  \"icon\": \"<string>\",\n  \"connection_id\": \"<string>\",\n  \"unique\": true,\n  \"readonly\": true,\n  \"archived\": true\n}"

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

{
  "id": "<string>",
  "table_id": "<string>",
  "key": "<string>",
  "type": "id",
  "schema": {
    "type": "file",
    "name": "<string>",
    "description": "<string>",
    "optional": true,
    "array": true,
    "placeholder": "<string>",
    "display": {
      "field": "inline",
      "container": "grid",
      "empty": "show",
      "render": "button"
    },
    "order": 1,
    "link": "<string>",
    "metadata": {},
    "allowed_modes": [
      "all"
    ],
    "broadcast_field": true,
    "broadcast_exposed": true,
    "integration_field": true,
    "display_field": true,
    "conditions": [
      {
        "field": "<string>",
        "operator": "eq",
        "value": "<unknown>"
      }
    ],
    "hidden": true,
    "picker": {
      "type": "google_drive",
      "views": [
        "DOCS"
      ],
      "selectable_mime_types": [
        "<string>"
      ]
    },
    "requires": [
      "<string>"
    ],
    "disable_variables": true,
    "allowed_types": [
      "<string>"
    ],
    "visibility": "PRIVATE",
    "default": {
      "id": "<string>",
      "file_path": "<string>",
      "file_filename": "document.pdf",
      "file_size": 1024,
      "file_mimetype": "application/pdf",
      "file_url": "<string>",
      "created_at": "2023-11-07T05:31:56Z"
    }
  },
  "readonly": true,
  "sortable": true,
  "groupable_in": [
    "table"
  ],
  "kind": "system"
}