Creates a new db report
Request Information
URI Parameters :
None.
Body Parameters :
db_report| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier | |
| db_report_type_id |
db report type id |
globally unique identifier |
Required |
| user_id |
Created user id |
globally unique identifier | |
| company_id |
The Final company that own this report (If WO Report, the company that owns the installation/project) |
globally unique identifier |
Optionally required : company_id,company_code or node company must be provided |
| company_code |
Embedded entity "company" using ERP PK when adding/updating db_report |
string |
Optionally required : company_id, company_code or company must be provided |
| company |
Embedded entity "company" when adding/updating db_report |
company |
Optionally required : company_id, company_code or company must be provided |
| db_table_name |
TableName which db report linked to. Possible value are jobs or meeting |
string |
Optionally required : db_table_id or db_table_name must be provided |
| db_table_id |
Table ID which db report linked to. |
globally unique identifier |
Optionally required : db_table_id or db_table_name must be provided |
| id_in_table |
Item id of the table which db report linked to |
globally unique identifier | |
| date_last_update |
Date last updated |
date | |
| reference_back_office | string |
Max length: 255 |
|
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |
Request Formats :
application/json, text/json
{
"id": "d7ba7ab2-7c9a-4dac-be45-6075ae389baa",
"db_report_type_id": "be2f46ed-68b6-4e81-9969-b727eca940ed",
"user_id": "027555b2-531f-4c5d-9475-58ab2bc611e2",
"company_id": "2d3fd639-f7a5-4f11-ab8e-04d2aea7e189",
"company_code": "sample string 5",
"db_table_name": "sample string 6",
"db_table_id": "64782242-cb3c-4bb8-a5b6-01ad01106ce3",
"id_in_table": "bd3864f6-9740-47fc-a7f4-8d4bba2b039a",
"date_last_update": "2025-12-05T21:46:46.1420875+00:00",
"reference_back_office": "sample string 10",
"modified_dateutc": "2025-12-05T21:46:46.1420875+00:00"
}
Response Information
Resource Description :
IHttpActionResult
db_report| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier | |
| db_report_type_id |
db report type id |
globally unique identifier |
Required |
| user_id |
Created user id |
globally unique identifier | |
| company_id |
The Final company that own this report (If WO Report, the company that owns the installation/project) |
globally unique identifier |
Optionally required : company_id,company_code or node company must be provided |
| company_code |
Embedded entity "company" using ERP PK when adding/updating db_report |
string |
Optionally required : company_id, company_code or company must be provided |
| company |
Embedded entity "company" when adding/updating db_report |
company |
Optionally required : company_id, company_code or company must be provided |
| db_table_name |
TableName which db report linked to. Possible value are jobs or meeting |
string |
Optionally required : db_table_id or db_table_name must be provided |
| db_table_id |
Table ID which db report linked to. |
globally unique identifier |
Optionally required : db_table_id or db_table_name must be provided |
| id_in_table |
Item id of the table which db report linked to |
globally unique identifier | |
| date_last_update |
Date last updated |
date | |
| reference_back_office | string |
Max length: 255 |
|
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |
Response Formats
application/json, text/json
{
"id": "d1dc5c8b-0539-442d-8ddf-ff617456baaf",
"db_report_type_id": "5de17cf7-2d28-4da5-add5-4a383f89bab6",
"user_id": "999475c1-1573-424b-bb10-f07985476960",
"company_id": "37d3998a-d12e-4f03-9228-c67eea1d448c",
"company_code": "sample string 5",
"db_table_name": "sample string 6",
"db_table_id": "63250709-bac9-4378-9003-052efff3e782",
"id_in_table": "2329265e-5659-4975-b087-2c8617fd9110",
"date_last_update": "2025-12-05T21:46:46.1420875+00:00",
"reference_back_office": "sample string 10",
"modified_dateutc": "2025-12-05T21:46:46.1420875+00:00"
}