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": "9036d5de-6ace-4101-8e8c-37462ef45add",
  "db_report_type_id": "7802ff87-b9da-4aab-baf4-3346cba76b13",
  "user_id": "c9d32ba4-ec81-4eff-9320-d32310c48974",
  "company_id": "ff8cddf7-6756-4fc0-9269-7597c29aeba6",
  "db_table_id": "9d05a4a9-3f08-438f-803b-8d95ee8776d6",
  "id_in_table": "dc33b472-ddc3-4dc5-8d3b-0cd059d86d68",
  "date_start": "2026-11-12T14:27:38.1810378+00:00",
  "modified_dateutc": "2026-11-12T14:27:38.1810378+00:00",
  "is_completed": true
}

application/xml, text/xml

Sample: 
<db_report xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
  <company_id>ff8cddf7-6756-4fc0-9269-7597c29aeba6</company_id>
  <date_start>2026-11-12T14:27:38.181Z</date_start>
  <db_report_type_id>7802ff87-b9da-4aab-baf4-3346cba76b13</db_report_type_id>
  <db_table_id>9d05a4a9-3f08-438f-803b-8d95ee8776d6</db_table_id>
  <id>9036d5de-6ace-4101-8e8c-37462ef45add</id>
  <id_in_table>dc33b472-ddc3-4dc5-8d3b-0cd059d86d68</id_in_table>
  <is_completed>true</is_completed>
  <modified_dateutc>2026-11-12T14:27:38.181Z</modified_dateutc>
  <user_id>c9d32ba4-ec81-4eff-9320-d32310c48974</user_id>
</db_report>