Retrieves all db reports, optionally filtered via OData query options.

Request Information

URI Parameters :

None.

Body Parameters :

None.

Response Information

Resource Description :

IHttpActionResult containing the list of db reports.

db_report
NameDescriptionTypeAdditional information
id

Primary Key

 globally unique identifier
db_report_type_id

db report type id

 globally unique identifier
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
db_table_id

Table ID which db report linked to.

 globally unique identifier
id_in_table

Item id of the table which db report linked to

 globally unique identifier
date_start

Date start

 date
modified_dateutc

Readonly system field managed by database, filled with GetUtcDate when adding,updating

 date
is_completed

is_completed flag

 boolean

Response Formats

application/json, text/json

Sample: 
{
  "id": "3135ce71-9c30-4a2b-8ec1-8a48b85fc5a9",
  "db_report_type_id": "5b408c6e-e764-4475-8057-a6ab6290e4c6",
  "user_id": "c42e0526-f3e1-474d-b284-86ed600aa483",
  "company_id": "aa6b3e3d-748f-4b2a-8b80-99e8f0527a5e",
  "db_table_id": "ad26d121-cc21-4071-8974-73ecad41bdc8",
  "id_in_table": "03a47a17-21f9-46f2-a550-3cb2d63e83b6",
  "date_start": "2026-09-16T08:34:32.5361161+00:00",
  "modified_dateutc": "2026-09-16T08:34:32.5361161+00:00",
  "is_completed": true
}

application/xml, text/xml

Sample: 
<db_report xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
  <company_id>aa6b3e3d-748f-4b2a-8b80-99e8f0527a5e</company_id>
  <date_start>2026-09-16T08:34:32.536Z</date_start>
  <db_report_type_id>5b408c6e-e764-4475-8057-a6ab6290e4c6</db_report_type_id>
  <db_table_id>ad26d121-cc21-4071-8974-73ecad41bdc8</db_table_id>
  <id>3135ce71-9c30-4a2b-8ec1-8a48b85fc5a9</id>
  <id_in_table>03a47a17-21f9-46f2-a550-3cb2d63e83b6</id_in_table>
  <is_completed>true</is_completed>
  <modified_dateutc>2026-09-16T08:34:32.536Z</modified_dateutc>
  <user_id>c42e0526-f3e1-474d-b284-86ed600aa483</user_id>
</db_report>