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_fileName | Description | Type | Additional 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
{ "id": "64341112-47cf-439b-9d46-620b9c0e3d92", "db_table_id": "0b2523a8-a78e-457a-b291-f2d4585c7a73", "db_table_name": "sample string 3", "id_in_table": "37e0a701-8649-4b01-ad9f-b0306059bdc9", "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": "c68bbecb-afb6-4ac4-8833-6a1e8d1e4440", "db_file_folder_reference_back_office": "sample string 12", "sales_organization_id": "faa960cb-6209-4c5f-98e3-e24e4c9d8f29", "sales_organization_code": "sample string 14", "file_type_name": "sample string 15", "file_size": 16, "user_notification": true, "is_archived": true, "date_add": "2025-06-07T22:23:32.1610554+00:00", "date_update": "2025-06-07T22:23:32.1610554+00:00", "modified_dateutc": "2025-06-07T22:23:32.1610554+00:00" }
Response Information
Resource Description :
db_fileName | Description | Type | Additional 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
{ "id": "6fbed613-c75a-4559-94fa-1f197e7d8353", "db_table_id": "7a369fb7-0690-465a-a912-f4b1299b4373", "db_table_name": "sample string 3", "id_in_table": "502468aa-1e94-463f-9e05-08573e2eace1", "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": "6df04df8-6dd1-46d4-8f20-9a974b874fdc", "db_file_folder_reference_back_office": "sample string 12", "sales_organization_id": "a48cdb9e-609e-4dd0-becb-1528d86759f4", "sales_organization_code": "sample string 14", "file_type_name": "sample string 15", "file_size": 16, "user_notification": true, "is_archived": true, "date_add": "2025-06-07T22:23:32.1610554+00:00", "date_update": "2025-06-07T22:23:32.1610554+00:00", "modified_dateutc": "2025-06-07T22:23:32.1610554+00:00" }