Retrieves the root work order (no parent) with status (Completed+Canceled)
Request Information
URI Parameters :
None.
Body Parameters :
None.
Response Information
Resource Description :
jobs_view| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier | |
| id2 |
Internal ID (numeric). Will be used if reference_back_office is empty |
integer | |
| reference_back_office |
The Id/Ref of the back office for this job |
string |
Max length: 50 |
| _parent_id |
Reference to a parent job (in case of Multi Job) |
globally unique identifier | |
| job_type_id |
Foreign key of job type for this job |
globally unique identifier | |
| job_type_name |
Type of the job (jobs.job_type_id=>job_type.name) |
string |
Max length: 50 |
| job_priority_id |
Foreign key of job priority for this job |
globally unique identifier | |
| job_priority_name |
Priority of the job (jobs.job_priority_id=>job_priority.name) |
string |
Max length: 50 |
| job_status_id |
Foreign key of job status for this job |
globally unique identifier | |
| job_status_name |
Status of the job (jobs.job_status_id=>job_status.name) |
string |
Max length: 50 |
| name |
Name of the job |
string |
Max length: 50 |
| nb_notes | integer | ||
| description |
Description of the job |
string |
Max length: 50 |
| date_closed |
Date+time job goes to completed |
date | |
| date_create |
Date create |
date | |
| date_update |
Date update |
date | |
| db_address_id |
Foreign key of db_address if the address of the job is different than the one of the project (or the main company) |
globally unique identifier | |
| contact_id |
Foreign key of contact if the main contact of the job is different than the one of the project |
globally unique identifier | |
| requested_by_contact_id |
Foreign key of contact to specify why contact of the requested_company_id makes the request |
globally unique identifier | |
| earliest_date_plannable |
If there is a minimum date for the planning (Not Before) |
date | |
| due_date |
Deadline of Max date for the planning (Not After) |
date | |
| project_shutdown_consequence |
Consequence of the installation is shut down (CEO has no air cooling anymore,..) |
string |
Max length: 50 |
| suggested_date_start |
Suggested date+time start (used for planning) |
date | |
| source_db_table_id |
Source Table of the entity that generate this jobs (like a task) |
globally unique identifier | |
| source_db_table_name |
Source Table of the entity that generate this jobs (like a task) in a string field |
string | |
| source_id_in_table |
Source ID of the entity that generate this jobs (like a task.id) |
globally unique identifier | |
| created_by_user_firstname |
User.firstname that created the job |
string |
Max length: 50 |
| created_by_user_lastname |
User.lastname that created the job |
string |
Max length: 50 |
| updated_by_user_firstname |
User.firstname that last updated the job |
string |
Max length: 50 |
| updated_by_user_lastname |
User.lastname that last updated the job |
string |
Max length: 50 |
| project_id |
Foreign key of project that owns this job |
globally unique identifier | |
| project_id2 |
Project Internal ID (numeric). Will be used if reference_back_office is empty |
integer | |
| project_parent_id |
Project Parent in case of project hierachy (child/parent) |
globally unique identifier | |
| project_location |
Additional text to describe the location |
string |
Max length: 50 |
| project_reference_back_office |
The Project Id/Ref of the back office for this project/installation |
string |
Max length: 50 |
| project_name |
Project name |
string |
Max length: 50 |
| project_serial_number |
Project Serial Number |
string |
Max length: 50 |
| project_contact_firstname |
Project main contact firstname |
string |
Max length: 50 |
| project_contact_lastname |
Project main contact lastname |
string |
Max length: 50 |
| equipment_model_id |
Foreign key of equipment model of the project |
globally unique identifier | |
| equipment_model_name |
Equipment model name (translated) of the project (jobs.equipment_model_id=>equipment_model.name) |
string |
Max length: 50 |
| equipment_family_id |
Foreign key of equipment family of the project |
globally unique identifier | |
| equipment_family_name |
Equipment family name (translated) of the project (jobs.equipment_family_id=>equipment_family.name) |
string |
Max length: 50 |
| equipment_brand_id | globally unique identifier | ||
| equipment_brand_name |
Equipment brand name (translated) of the project (equipment_model.equipment_brand_id=>equipment_brand.name) |
string |
Max length: 50 |
| company_code |
Company code that owns the project (jobs.project_id=>project.company_id=>company.code) |
string |
Max length: 50 |
| company_name |
Company name of the company that owns the project (jobs.project_id=>project.company_id=>company.name) |
string |
Max length: 50 |
| db_address_street |
Address Street of the job |
string |
Max length: 50 |
| db_address_street_number |
Address Street Number of the job |
string |
Max length: 50 |
| db_address_zip |
Address Zip code of the job |
string |
Max length: 50 |
| db_address_city |
Address City of the job |
string |
Max length: 50 |
| db_address_country_name |
Address Country Name of the job |
string |
Max length: 50 |
| db_address_country_code |
Address Country code of the job |
string |
Max length: 50 |
| db_address_phone |
Address Phone number of the job |
string |
Max length: 50 |
| db_address_email |
Address Email of the job |
string |
Max length: 50 |
| first_planning_userfullname |
Technician fullanme of the first planning |
string | |
| root_parent_id | globally unique identifier | ||
| has_child | boolean | ||
| first_planning_date |
Date+Time of the first planning |
date | |
| date_reported_by_company |
Date+time when company reported the problem |
date | |
| customer_reference |
Reference of this job for the customer |
string |
Max length: 50 |
| contact_fullname |
Contact fullname of the job |
string |
Max length: 50 |
| contact_phone |
Contact Phone number of the job |
string |
Max length: 50 |
| contact_mobile |
Contact Cellphone number of the job |
string |
Max length: 50 |
| contact_email |
Contact Email of the job |
string |
Max length: 50 |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date | |
| dateutc_create |
auto filled when task is created |
date | |
| dateutc_max_sla_resolution |
dateutc_max_sla_resolution |
date | |
| dateutc_max_sla_hands_on_machine |
dateutc_max_sla_hands_on_machine |
date | |
| dateutc_max_sla_contact |
dateutc_max_sla_contact |
date | |
| dateutc_in_progress |
auto filled as soon as the jobs receive the status "in progress |
date | |
| job_reference |
The job reference, if reference_back_office is not null, then it is used else using id2 |
string | |
| dateutc_closed |
auto filled when jobs is closed or cancelled (based on job_approval.date_generated converted in utc |
date |
Response Formats
application/json, text/json
{
"id": "c9440bfd-380b-407d-bb24-6566352089b3",
"id2": 2,
"reference_back_office": "sample string 3",
"_parent_id": "b1116657-3327-4ae5-b72b-909e85525047",
"job_type_id": "c5ab05dc-fd5e-4694-a695-3b33bf5a375b",
"job_type_name": "sample string 6",
"job_priority_id": "ef33c7e1-b338-4bb3-99b3-de6ce34a792d",
"job_priority_name": "sample string 8",
"job_status_id": "ded35b11-c3aa-4286-a663-00b83026656d",
"job_status_name": "sample string 10",
"name": "sample string 11",
"nb_notes": 12,
"description": "sample string 13",
"date_closed": "2026-06-24T04:03:43.5454251+00:00",
"date_create": "2026-06-24T04:03:43.5454251+00:00",
"date_update": "2026-06-24T04:03:43.5454251+00:00",
"db_address_id": "f3265499-a0d7-4b0b-9bf1-e40acbff40b3",
"contact_id": "b99eb6f9-a03a-4979-a254-a807b1821847",
"requested_by_contact_id": "14223b1a-813f-4b8b-92bb-26e83bdc19e3",
"earliest_date_plannable": "2026-06-24T04:03:43.5454251+00:00",
"due_date": "2026-06-24T04:03:43.5454251+00:00",
"project_shutdown_consequence": "sample string 22",
"suggested_date_start": "2026-06-24T04:03:43.5664501+00:00",
"source_db_table_id": "10882997-9636-462e-938c-f40a2524c2bc",
"source_db_table_name": "sample string 25",
"source_id_in_table": "93bf283c-a18b-4a68-ac57-7ed458a9fbc8",
"created_by_user_firstname": "sample string 27",
"created_by_user_lastname": "sample string 28",
"updated_by_user_firstname": "sample string 29",
"updated_by_user_lastname": "sample string 30",
"project_id": "a6c7a143-57f4-472a-8d8c-e89d41030088",
"project_id2": 32,
"project_parent_id": "483542aa-d533-4c78-85c9-1bb6d2eb556e",
"project_location": "sample string 34",
"project_reference_back_office": "sample string 35",
"project_name": "sample string 36",
"project_serial_number": "sample string 37",
"project_contact_firstname": "sample string 38",
"project_contact_lastname": "sample string 39",
"equipment_model_id": "0622cdf7-d0ae-4d31-a769-d546367c3a87",
"equipment_model_name": "sample string 41",
"equipment_family_id": "fed9f0be-d065-4a53-b35e-c60310c1e672",
"equipment_family_name": "sample string 43",
"equipment_brand_id": "25d67df7-a281-467f-a5f0-1367fe21a1e0",
"equipment_brand_name": "sample string 45",
"company_code": "sample string 46",
"company_name": "sample string 47",
"db_address_street": "sample string 48",
"db_address_street_number": "sample string 49",
"db_address_zip": "sample string 50",
"db_address_city": "sample string 51",
"db_address_country_name": "sample string 52",
"db_address_country_code": "sample string 53",
"db_address_phone": "sample string 54",
"db_address_email": "sample string 55",
"first_planning_userfullname": "sample string 56",
"root_parent_id": "b24438ce-2589-42cf-bf55-ebbbe717d6df",
"has_child": true,
"first_planning_date": "2026-06-24T04:03:43.5664501+00:00",
"date_reported_by_company": "2026-06-24T04:03:43.5664501+00:00",
"customer_reference": "sample string 61",
"contact_fullname": "sample string 62",
"contact_phone": "sample string 63",
"contact_mobile": "sample string 64",
"contact_email": "sample string 65",
"modified_dateutc": "2026-06-24T04:03:43.5664501+00:00",
"dateutc_create": "2026-06-24T04:03:43.5664501+00:00",
"dateutc_max_sla_resolution": "2026-06-24T04:03:43.5664501+00:00",
"dateutc_max_sla_hands_on_machine": "2026-06-24T04:03:43.5664501+00:00",
"dateutc_max_sla_contact": "2026-06-24T04:03:43.5664501+00:00",
"dateutc_in_progress": "2026-06-24T04:03:43.5664501+00:00",
"job_reference": "sample string 72",
"dateutc_closed": "2026-06-24T04:03:43.5664501+00:00",
"job_planning_count": 74
}
application/xml, text/xml
<jobs_view xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <_parent_id>b1116657-3327-4ae5-b72b-909e85525047</_parent_id> <company_code>sample string 46</company_code> <company_name>sample string 47</company_name> <contact_email>sample string 65</contact_email> <contact_fullname>sample string 62</contact_fullname> <contact_id>b99eb6f9-a03a-4979-a254-a807b1821847</contact_id> <contact_mobile>sample string 64</contact_mobile> <contact_phone>sample string 63</contact_phone> <created_by_user_firstname>sample string 27</created_by_user_firstname> <created_by_user_lastname>sample string 28</created_by_user_lastname> <customer_reference>sample string 61</customer_reference> <date_closed>2026-06-24T04:03:43.545Z</date_closed> <date_create>2026-06-24T04:03:43.545Z</date_create> <date_reported_by_company>2026-06-24T04:03:43.566Z</date_reported_by_company> <date_update>2026-06-24T04:03:43.545Z</date_update> <dateutc_closed>2026-06-24T04:03:43.566Z</dateutc_closed> <dateutc_create>2026-06-24T04:03:43.566Z</dateutc_create> <dateutc_in_progress>2026-06-24T04:03:43.566Z</dateutc_in_progress> <dateutc_max_sla_contact>2026-06-24T04:03:43.566Z</dateutc_max_sla_contact> <dateutc_max_sla_hands_on_machine>2026-06-24T04:03:43.566Z</dateutc_max_sla_hands_on_machine> <dateutc_max_sla_resolution>2026-06-24T04:03:43.566Z</dateutc_max_sla_resolution> <db_address_city>sample string 51</db_address_city> <db_address_country_code>sample string 53</db_address_country_code> <db_address_country_name>sample string 52</db_address_country_name> <db_address_email>sample string 55</db_address_email> <db_address_id>f3265499-a0d7-4b0b-9bf1-e40acbff40b3</db_address_id> <db_address_phone>sample string 54</db_address_phone> <db_address_street>sample string 48</db_address_street> <db_address_street_number>sample string 49</db_address_street_number> <db_address_zip>sample string 50</db_address_zip> <description>sample string 13</description> <due_date>2026-06-24T04:03:43.545Z</due_date> <earliest_date_plannable>2026-06-24T04:03:43.545Z</earliest_date_plannable> <equipment_brand_id>25d67df7-a281-467f-a5f0-1367fe21a1e0</equipment_brand_id> <equipment_brand_name>sample string 45</equipment_brand_name> <equipment_family_id>fed9f0be-d065-4a53-b35e-c60310c1e672</equipment_family_id> <equipment_family_name>sample string 43</equipment_family_name> <equipment_model_id>0622cdf7-d0ae-4d31-a769-d546367c3a87</equipment_model_id> <equipment_model_name>sample string 41</equipment_model_name> <first_planning_date>2026-06-24T04:03:43.566Z</first_planning_date> <first_planning_userfullname>sample string 56</first_planning_userfullname> <has_child>true</has_child> <id>c9440bfd-380b-407d-bb24-6566352089b3</id> <id2>2</id2> <job_priority_id>ef33c7e1-b338-4bb3-99b3-de6ce34a792d</job_priority_id> <job_priority_name>sample string 8</job_priority_name> <job_reference>sample string 72</job_reference> <job_status_id>ded35b11-c3aa-4286-a663-00b83026656d</job_status_id> <job_status_name>sample string 10</job_status_name> <job_type_id>c5ab05dc-fd5e-4694-a695-3b33bf5a375b</job_type_id> <job_type_name>sample string 6</job_type_name> <modified_dateutc>2026-06-24T04:03:43.566Z</modified_dateutc> <name>sample string 11</name> <nb_notes>12</nb_notes> <project_contact_firstname>sample string 38</project_contact_firstname> <project_contact_lastname>sample string 39</project_contact_lastname> <project_id>a6c7a143-57f4-472a-8d8c-e89d41030088</project_id> <project_id2>32</project_id2> <project_location>sample string 34</project_location> <project_name>sample string 36</project_name> <project_parent_id>483542aa-d533-4c78-85c9-1bb6d2eb556e</project_parent_id> <project_reference_back_office>sample string 35</project_reference_back_office> <project_serial_number>sample string 37</project_serial_number> <project_shutdown_consequence>sample string 22</project_shutdown_consequence> <reference_back_office>sample string 3</reference_back_office> <requested_by_contact_id>14223b1a-813f-4b8b-92bb-26e83bdc19e3</requested_by_contact_id> <root_parent_id>b24438ce-2589-42cf-bf55-ebbbe717d6df</root_parent_id> <source_db_table_id>10882997-9636-462e-938c-f40a2524c2bc</source_db_table_id> <source_db_table_name>sample string 25</source_db_table_name> <source_id_in_table>93bf283c-a18b-4a68-ac57-7ed458a9fbc8</source_id_in_table> <suggested_date_start>2026-06-24T04:03:43.566Z</suggested_date_start> <total_time_planned>0</total_time_planned> <updated_by_user_firstname>sample string 29</updated_by_user_firstname> <updated_by_user_lastname>sample string 30</updated_by_user_lastname> </jobs_view>