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": "7cc4b911-a35e-4ddf-9715-e555c41f769d",
"db_report_type_id": "8b25028f-1510-454c-9ef7-7e996c65b133",
"user_id": "50fceac8-7ce4-44b6-9db0-2dfbe21557ac",
"company_id": "69b07b65-6d6a-4714-9c82-bdda0723e69c",
"company_code": "sample string 5",
"db_table_name": "sample string 6",
"db_table_id": "a67036b6-4a3b-4362-86f5-61c2369ff017",
"id_in_table": "fe694892-b92c-45a7-a7b9-c6e9241ace59",
"date_last_update": "2025-12-24T15:13:43.8806888+00:00",
"reference_back_office": "sample string 10",
"modified_dateutc": "2025-12-24T15:13:43.8961737+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": "b3b64c1c-9d87-4db2-ae12-cd5c3a016217",
"db_report_type_id": "d89b095a-85ae-4a20-a0b2-b651546c80d9",
"user_id": "b7e76722-62b3-490a-8972-31409b20a031",
"company_id": "34a1a8b7-7406-491c-abd5-91388b10ddac",
"company_code": "sample string 5",
"db_table_name": "sample string 6",
"db_table_id": "475eb0ef-2af0-41c9-b2a9-8420397f5294",
"id_in_table": "aa1779f4-c8e0-466d-9fbf-c828db868878",
"date_last_update": "2025-12-24T15:13:44.0680472+00:00",
"reference_back_office": "sample string 10",
"modified_dateutc": "2025-12-24T15:13:44.0680472+00:00"
}