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": "9ec5bffc-239e-4590-979f-7172f8439fa5",
"db_report_type_id": "319a311c-4eeb-4d45-ad85-b8839f327c8b",
"user_id": "3f1dde90-68e1-48ee-921b-ddb8808f1e1e",
"company_id": "5a4f0e4a-e314-4e8d-b036-ef143535e688",
"company_code": "sample string 5",
"db_table_name": "sample string 6",
"db_table_id": "1ac8bfdd-1413-43c4-b81b-62c0efe0e994",
"id_in_table": "3ba4c471-0636-489b-8da4-607f91cc2749",
"date_last_update": "2026-10-21T21:23:18.3125426+00:00",
"reference_back_office": "sample string 10",
"modified_dateutc": "2026-10-21T21:23:18.3125426+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": "8b8dc074-cf8b-465e-a497-747a99341ae7",
"db_report_type_id": "300107a5-9895-41e9-b511-43efcc608596",
"user_id": "581a69cc-afa9-4d76-86f5-7ba3a482267d",
"company_id": "1907182d-e043-4cca-9de5-76f9cd93da73",
"company_code": "sample string 5",
"db_table_name": "sample string 6",
"db_table_id": "ac378eb1-9a6e-457e-918a-4609908a7954",
"id_in_table": "6ce80e32-ca8b-4585-8b3d-77207428bef8",
"date_last_update": "2026-10-21T21:23:18.3125426+00:00",
"reference_back_office": "sample string 10",
"modified_dateutc": "2026-10-21T21:23:18.3125426+00:00"
}