Creates a new db report

Request Information

URI Parameters :

None.

Body Parameters :

db_report
NameDescriptionTypeAdditional 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

Sample:
{
  "id": "7890843a-6f9f-4c6c-a86f-291717b88c4e",
  "db_report_type_id": "fc3406ce-83a2-41ed-9581-c94a80c6cd2d",
  "user_id": "01022407-c374-4a77-8cfb-ca480c3fefd8",
  "company_id": "4d4e80c7-3c9c-403f-b8ab-c45f65f8fff5",
  "company_code": "sample string 5",
  "db_table_name": "sample string 6",
  "db_table_id": "9df9109c-8f69-4caf-b370-d936fcd87c26",
  "id_in_table": "b30d45ec-d38f-45fd-bd19-df18bc2140c3",
  "date_last_update": "2024-02-20T03:23:23.4323643+00:00",
  "reference_back_office": "sample string 10",
  "modified_dateutc": "2024-02-20T03:23:23.4323643+00:00"
}

Response Information

Resource Description :

IHttpActionResult

db_report
NameDescriptionTypeAdditional 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

Sample:
{
  "id": "e2e5d639-e4c8-4f6a-ac5a-302f5dcf3e9e",
  "db_report_type_id": "2c39fcc5-a49d-4a2e-85b9-c0bd2edc06b9",
  "user_id": "c25163f0-7c8d-45fa-b6d0-74046a4acf50",
  "company_id": "2807862b-01f3-40fa-818b-c4b04d0d0f1c",
  "company_code": "sample string 5",
  "db_table_name": "sample string 6",
  "db_table_id": "3d1dc2d5-43ea-46a1-869c-bf7c38cd5598",
  "id_in_table": "d08e8b7e-8a6b-42f2-9f10-3c8408174b3c",
  "date_last_update": "2024-02-20T03:23:23.4323643+00:00",
  "reference_back_office": "sample string 10",
  "modified_dateutc": "2024-02-20T03:23:23.4323643+00:00"
}