Add/update db_file

Request Information

URI Parameters :

None.

Body Parameters :

db_file
NameDescriptionTypeAdditional information
id

Primary key

globally unique identifier

Required

db_table_id

Table.id of the linked entity

globally unique identifier
id_in_table

Id of the linked entity

globally unique identifier
file_type

string
is_default

boolean
file_name

File_name of the file

string
mime_type

string
file_content

Collection of byte
image_width

In case of picture, the original width

integer
image_heigth

In case of picture, the original heigth

integer
user_id

globally unique identifier
description

string
tags

string
date_update

date
date_add

date
dateutc_add

date
name

string
file_size

integer
modified_dateutc

Readonly system field managed by database, filled with GetUtcDate when adding,updating

date
is_showonweb

Is available on ServiceDesk?

boolean
sys_logical_delete

boolean

Request Formats :

application/json, text/json

Sample:
{
  "id": "7a917dc4-ca52-406a-852b-ef4574641683",
  "db_table_id": "0d78a1d7-941b-4326-aed9-2327d0a0146b",
  "id_in_table": "c2ec2b85-724f-4d90-831f-662b66d3a5d3",
  "file_type": "sample string 4",
  "is_default": true,
  "file_name": "sample string 6",
  "mime_type": "sample string 7",
  "file_content": "QEA=",
  "image_width": 8,
  "image_heigth": 9,
  "user_id": "999c54c3-b233-483d-b1ef-f9bd8730acaf",
  "description": "sample string 11",
  "tags": "sample string 12",
  "date_update": "2026-03-07T14:50:12.9140848+00:00",
  "date_add": "2026-03-07T14:50:12.9140848+00:00",
  "dateutc_add": "2026-03-07T14:50:12.9140848+00:00",
  "name": "sample string 16",
  "file_size": 17,
  "modified_dateutc": "2026-03-07T14:50:12.9140848+00:00",
  "is_showonweb": true,
  "sys_logical_delete": true
}

application/xml, text/xml

Sample:
<db_file xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
  <date_add>2026-03-07T14:50:12.914Z</date_add>
  <date_update>2026-03-07T14:50:12.914Z</date_update>
  <dateutc_add>2026-03-07T14:50:12.914Z</dateutc_add>
  <db_table_id>0d78a1d7-941b-4326-aed9-2327d0a0146b</db_table_id>
  <description>sample string 11</description>
  <file_content>QEA=</file_content>
  <file_name>sample string 6</file_name>
  <file_size>17</file_size>
  <file_type>sample string 4</file_type>
  <id>7a917dc4-ca52-406a-852b-ef4574641683</id>
  <id_in_table>c2ec2b85-724f-4d90-831f-662b66d3a5d3</id_in_table>
  <image_heigth>9</image_heigth>
  <image_width>8</image_width>
  <is_default>true</is_default>
  <is_showonweb>true</is_showonweb>
  <mime_type>sample string 7</mime_type>
  <modified_dateutc>2026-03-07T14:50:12.914Z</modified_dateutc>
  <name>sample string 16</name>
  <sys_logical_delete>true</sys_logical_delete>
  <tags>sample string 12</tags>
  <user_id>999c54c3-b233-483d-b1ef-f9bd8730acaf</user_id>
</db_file>

Response Information

Resource Description :

db_file
NameDescriptionTypeAdditional information
id

Primary key

globally unique identifier

Required

db_table_id

Table.id of the linked entity

globally unique identifier
id_in_table

Id of the linked entity

globally unique identifier
file_type

string
is_default

boolean
file_name

File_name of the file

string
mime_type

string
file_content

Collection of byte
image_width

In case of picture, the original width

integer
image_heigth

In case of picture, the original heigth

integer
user_id

globally unique identifier
description

string
tags

string
date_update

date
date_add

date
dateutc_add

date
name

string
file_size

integer
modified_dateutc

Readonly system field managed by database, filled with GetUtcDate when adding,updating

date
is_showonweb

Is available on ServiceDesk?

boolean
sys_logical_delete

boolean

Response Formats

application/json, text/json

Sample:
{
  "id": "2fcdd7df-01f5-482f-b9aa-6489f1258012",
  "db_table_id": "9eb9b218-9b84-48ab-80b7-1a342cbf68d3",
  "id_in_table": "374a60a7-e230-4b84-8e1d-37b19f67ae39",
  "file_type": "sample string 4",
  "is_default": true,
  "file_name": "sample string 6",
  "mime_type": "sample string 7",
  "file_content": "QEA=",
  "image_width": 8,
  "image_heigth": 9,
  "user_id": "408d5bdc-daf7-44b5-aace-4690ea584e5c",
  "description": "sample string 11",
  "tags": "sample string 12",
  "date_update": "2026-03-07T14:50:12.9260702+00:00",
  "date_add": "2026-03-07T14:50:12.9260702+00:00",
  "dateutc_add": "2026-03-07T14:50:12.9260702+00:00",
  "name": "sample string 16",
  "file_size": 17,
  "modified_dateutc": "2026-03-07T14:50:12.9260702+00:00",
  "is_showonweb": true,
  "sys_logical_delete": true
}

application/xml, text/xml

Sample:
<db_file xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
  <date_add>2026-03-07T14:50:12.926Z</date_add>
  <date_update>2026-03-07T14:50:12.926Z</date_update>
  <dateutc_add>2026-03-07T14:50:12.926Z</dateutc_add>
  <db_table_id>9eb9b218-9b84-48ab-80b7-1a342cbf68d3</db_table_id>
  <description>sample string 11</description>
  <file_content>QEA=</file_content>
  <file_name>sample string 6</file_name>
  <file_size>17</file_size>
  <file_type>sample string 4</file_type>
  <id>2fcdd7df-01f5-482f-b9aa-6489f1258012</id>
  <id_in_table>374a60a7-e230-4b84-8e1d-37b19f67ae39</id_in_table>
  <image_heigth>9</image_heigth>
  <image_width>8</image_width>
  <is_default>true</is_default>
  <is_showonweb>true</is_showonweb>
  <mime_type>sample string 7</mime_type>
  <modified_dateutc>2026-03-07T14:50:12.926Z</modified_dateutc>
  <name>sample string 16</name>
  <sys_logical_delete>true</sys_logical_delete>
  <tags>sample string 12</tags>
  <user_id>408d5bdc-daf7-44b5-aace-4690ea584e5c</user_id>
</db_file>