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": "e0c0d778-644e-4e3d-ad69-6f9563135573",
"db_report_type_id": "9c60b38d-f8d3-4c21-b369-e487081b0674",
"user_id": "5094d6ce-694e-41f7-b680-7c63b241cbf9",
"company_id": "4873a398-4295-4712-9cde-bf122e1281ba",
"company_code": "sample string 5",
"db_table_name": "sample string 6",
"db_table_id": "791f3143-4c16-4aa1-a8d8-ef728b7fa208",
"id_in_table": "ba17254a-6823-4dd2-b71d-37cf7c949a21",
"date_last_update": "2025-06-28T00:25:27.9504111+00:00",
"reference_back_office": "sample string 10",
"modified_dateutc": "2025-06-28T00:25:27.9504111+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": "2e834707-1fdd-4412-ade2-78cba4c8385d",
"db_report_type_id": "2daa7851-832d-4311-80a4-5b0cd29eaf6c",
"user_id": "a11a8968-2f70-4772-a9e9-2964eadf32e9",
"company_id": "5bf75764-bd6f-48b4-bb12-450bee96df93",
"company_code": "sample string 5",
"db_table_name": "sample string 6",
"db_table_id": "ee962129-6357-4c4d-94d9-f35c23b36392",
"id_in_table": "6928cfef-7214-408a-824d-59567476170f",
"date_last_update": "2025-06-28T00:25:27.9685625+00:00",
"reference_back_office": "sample string 10",
"modified_dateutc": "2025-06-28T00:25:27.9685625+00:00"
}