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": "d28bd7e3-6c4f-4751-a2c7-5729dca8630b",
  "db_table_id": "bd9c4f95-501c-4b6b-8165-d14b6a999845",
  "id_in_table": "87468b8c-4251-40ee-a183-4ba84fbe39ce",
  "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": "67819111-92df-49cf-a546-1c559f2ef255",
  "description": "sample string 11",
  "tags": "sample string 12",
  "date_update": "2026-06-16T21:17:14.4032306+00:00",
  "date_add": "2026-06-16T21:17:14.4032306+00:00",
  "dateutc_add": "2026-06-16T21:17:14.4032306+00:00",
  "name": "sample string 16",
  "file_size": 17,
  "modified_dateutc": "2026-06-16T21:17:14.4032306+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-06-16T21:17:14.403Z</date_add>
  <date_update>2026-06-16T21:17:14.403Z</date_update>
  <dateutc_add>2026-06-16T21:17:14.403Z</dateutc_add>
  <db_table_id>bd9c4f95-501c-4b6b-8165-d14b6a999845</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>d28bd7e3-6c4f-4751-a2c7-5729dca8630b</id>
  <id_in_table>87468b8c-4251-40ee-a183-4ba84fbe39ce</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-06-16T21:17:14.403Z</modified_dateutc>
  <name>sample string 16</name>
  <sys_logical_delete>true</sys_logical_delete>
  <tags>sample string 12</tags>
  <user_id>67819111-92df-49cf-a546-1c559f2ef255</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": "a9634aff-820f-4219-b7c0-d671763e85ec",
  "db_table_id": "da79132f-b159-480a-944f-9992676a3691",
  "id_in_table": "dfb1a87a-4a1f-44e1-9729-ca76224df8c1",
  "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": "0de9d101-c8eb-444f-8e0d-71fcdb820c55",
  "description": "sample string 11",
  "tags": "sample string 12",
  "date_update": "2026-06-16T21:17:14.4032306+00:00",
  "date_add": "2026-06-16T21:17:14.4032306+00:00",
  "dateutc_add": "2026-06-16T21:17:14.4032306+00:00",
  "name": "sample string 16",
  "file_size": 17,
  "modified_dateutc": "2026-06-16T21:17:14.4032306+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-06-16T21:17:14.403Z</date_add>
  <date_update>2026-06-16T21:17:14.403Z</date_update>
  <dateutc_add>2026-06-16T21:17:14.403Z</dateutc_add>
  <db_table_id>da79132f-b159-480a-944f-9992676a3691</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>a9634aff-820f-4219-b7c0-d671763e85ec</id>
  <id_in_table>dfb1a87a-4a1f-44e1-9729-ca76224df8c1</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-06-16T21:17:14.403Z</modified_dateutc>
  <name>sample string 16</name>
  <sys_logical_delete>true</sys_logical_delete>
  <tags>sample string 12</tags>
  <user_id>0de9d101-c8eb-444f-8e0d-71fcdb820c55</user_id>
</db_file>