Creates a new db_file by supplying directly the field db_file.file_content as Byte Array

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
db_table_name

Foreign key to the table of the linked entity using table name. Can be article,company,contact,jobs,job_approval,project or task.Will be also filled on Get to allow Odata Filter on it

string
id_in_table

Id of the linked entity

globally unique identifier
name

Name of the file

string

Required

Max length: 100

description

Description of the file

string

Max length: 4000

file_name

File_name of the file

string

Max length: 100

image_width

In case of picture, the original width

integer
image_heigth

In case of picture, the original heigth

integer
mime_type

Mime-type of the file.Used when redirect user to the data, like application/pdf or image/jpeg

string

Max length: 100

file_content

The file content, in Byte Array. Use this field when using POST/Put

Collection of byte
db_file_folder_id

For Global Files : Foreign key to db file folder

globally unique identifier
db_file_folder_reference_back_office

Embedded entity "db_file_folder" using ERP PK when adding/updating db_file

string
db_file_folder

Embedded entity "db_file_folder" using node when adding/updating db_file

db_file_folder
sales_organization_id

In case of global files - you can specifiy if it's available for all organization or only one

globally unique identifier
sales_organization_code

Embedded entity "sales_organization" using ERP PK when adding/updating db_file

string
sales_organization

Embedded entity "sales_organization" using node when adding/updating db_file

sales_organization
file_type_name

Readonly :Constant in case of specific file. Can be JOB_APPROVAL, ORDERPDF, PURCHASE_ORDERPDF

string
file_size

Size in bytes of the file_content

integer
user_notification

For Global files - indicate if user should be informed that this file is available

boolean
is_archived

Indicate if the file has been deleted (content flushed)

boolean
date_add

Date when file has been added

date
date_update

Update date, auto filled by Now if no value received

date
modified_dateutc

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

date

Request Formats :

application/json, text/json

Sample:
{
  "id": "0d589700-f602-4928-9dea-e259a11f19ad",
  "db_table_id": "c9c1008a-8990-4192-b188-b6c14b14115c",
  "db_table_name": "sample string 3",
  "id_in_table": "6afb76e6-e3c0-42e7-b2ee-6e60bf2c6b3b",
  "name": "sample string 5",
  "description": "sample string 6",
  "file_name": "sample string 7",
  "image_width": 8,
  "image_heigth": 9,
  "mime_type": "sample string 10",
  "file_content": "QEA=",
  "db_file_folder_id": "1c93347c-ee91-4c71-b3b2-c7499491ca0f",
  "db_file_folder_reference_back_office": "sample string 12",
  "sales_organization_id": "1f620864-8435-442e-87f5-cb5235be1508",
  "sales_organization_code": "sample string 14",
  "file_type_name": "sample string 15",
  "file_size": 16,
  "user_notification": true,
  "is_archived": true,
  "date_add": "2025-07-14T20:11:31.0983906+00:00",
  "date_update": "2025-07-14T20:11:31.0983906+00:00",
  "modified_dateutc": "2025-07-14T20:11:31.0983906+00:00"
}

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
db_table_name

Foreign key to the table of the linked entity using table name. Can be article,company,contact,jobs,job_approval,project or task.Will be also filled on Get to allow Odata Filter on it

string
id_in_table

Id of the linked entity

globally unique identifier
name

Name of the file

string

Required

Max length: 100

description

Description of the file

string

Max length: 4000

file_name

File_name of the file

string

Max length: 100

image_width

In case of picture, the original width

integer
image_heigth

In case of picture, the original heigth

integer
mime_type

Mime-type of the file.Used when redirect user to the data, like application/pdf or image/jpeg

string

Max length: 100

file_content

The file content, in Byte Array. Use this field when using POST/Put

Collection of byte
db_file_folder_id

For Global Files : Foreign key to db file folder

globally unique identifier
db_file_folder_reference_back_office

Embedded entity "db_file_folder" using ERP PK when adding/updating db_file

string
db_file_folder

Embedded entity "db_file_folder" using node when adding/updating db_file

db_file_folder
sales_organization_id

In case of global files - you can specifiy if it's available for all organization or only one

globally unique identifier
sales_organization_code

Embedded entity "sales_organization" using ERP PK when adding/updating db_file

string
sales_organization

Embedded entity "sales_organization" using node when adding/updating db_file

sales_organization
file_type_name

Readonly :Constant in case of specific file. Can be JOB_APPROVAL, ORDERPDF, PURCHASE_ORDERPDF

string
file_size

Size in bytes of the file_content

integer
user_notification

For Global files - indicate if user should be informed that this file is available

boolean
is_archived

Indicate if the file has been deleted (content flushed)

boolean
date_add

Date when file has been added

date
date_update

Update date, auto filled by Now if no value received

date
modified_dateutc

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

date

Response Formats

application/json, text/json

Sample:
{
  "id": "fbb78daf-ffb0-41f0-b2d9-29e4644c09ea",
  "db_table_id": "488316a3-545c-4a30-bff8-5783e2b376cd",
  "db_table_name": "sample string 3",
  "id_in_table": "7fb02cfe-6c2c-447f-a9f8-768e9a21c29c",
  "name": "sample string 5",
  "description": "sample string 6",
  "file_name": "sample string 7",
  "image_width": 8,
  "image_heigth": 9,
  "mime_type": "sample string 10",
  "file_content": "QEA=",
  "db_file_folder_id": "7e7cec0b-7caa-45dc-a66c-4c09757aaf2a",
  "db_file_folder_reference_back_office": "sample string 12",
  "sales_organization_id": "5e9ca9f1-152b-497b-ae55-740f29e3a3fc",
  "sales_organization_code": "sample string 14",
  "file_type_name": "sample string 15",
  "file_size": 16,
  "user_notification": true,
  "is_archived": true,
  "date_add": "2025-07-14T20:11:31.0983906+00:00",
  "date_update": "2025-07-14T20:11:31.0983906+00:00",
  "modified_dateutc": "2025-07-14T20:11:31.0983906+00:00"
}