Retrieves all jobs that linked to a specific project don't care if it is root or child job
Request Information
URI Parameters :
None.
Body Parameters :
ObjectNone.
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": "bd6dc318-28a0-49a1-83da-0e093348151d",
"id2": 2,
"reference_back_office": "sample string 3",
"_parent_id": "80fe7f41-25b7-495d-970f-cef95147cb79",
"job_type_id": "91f42325-6497-4b9d-9256-148eec7f9109",
"job_type_name": "sample string 6",
"job_priority_id": "bb0ab6da-db80-4699-8b25-aee531c38541",
"job_priority_name": "sample string 8",
"job_status_id": "fa241c74-7d6d-48f2-b4fe-7c6ccb60a8e1",
"job_status_name": "sample string 10",
"name": "sample string 11",
"nb_notes": 12,
"description": "sample string 13",
"date_closed": "2026-06-24T04:03:11.9804976+00:00",
"date_create": "2026-06-24T04:03:11.9804976+00:00",
"date_update": "2026-06-24T04:03:11.9804976+00:00",
"db_address_id": "f1bb4246-22fc-4220-a1f1-d9ebb2c69f3a",
"contact_id": "cc54697c-5682-4183-94d0-a5ae707ad491",
"requested_by_contact_id": "21811af1-e251-4af6-ae50-a65ddeec9a70",
"earliest_date_plannable": "2026-06-24T04:03:11.9804976+00:00",
"due_date": "2026-06-24T04:03:11.9804976+00:00",
"project_shutdown_consequence": "sample string 22",
"suggested_date_start": "2026-06-24T04:03:11.9804976+00:00",
"source_db_table_id": "e138f568-0108-4517-af24-68eb9f429c6b",
"source_db_table_name": "sample string 25",
"source_id_in_table": "bfbc6a9f-b8a7-465a-a428-d155fbcb60af",
"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": "01942851-e1fc-4ca1-a542-e5fb9b081ab3",
"project_id2": 32,
"project_parent_id": "63020408-7657-45ea-82fc-66dd7458d1e5",
"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": "a6ccc039-7004-4f09-8aac-c4e97dc9778e",
"equipment_model_name": "sample string 41",
"equipment_family_id": "1208e5db-ea3e-4467-9920-72221e1e6c9f",
"equipment_family_name": "sample string 43",
"equipment_brand_id": "f5a1c06a-26b9-4dc0-8835-48c88c4e6ba2",
"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": "c3008dad-004b-4190-b679-32db8714d21b",
"has_child": true,
"first_planning_date": "2026-06-24T04:03:11.9804976+00:00",
"date_reported_by_company": "2026-06-24T04:03:11.9804976+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:11.9804976+00:00",
"dateutc_create": "2026-06-24T04:03:11.9804976+00:00",
"dateutc_max_sla_resolution": "2026-06-24T04:03:11.9804976+00:00",
"dateutc_max_sla_hands_on_machine": "2026-06-24T04:03:11.9804976+00:00",
"dateutc_max_sla_contact": "2026-06-24T04:03:11.9804976+00:00",
"dateutc_in_progress": "2026-06-24T04:03:11.9804976+00:00",
"job_reference": "sample string 72",
"dateutc_closed": "2026-06-24T04:03:11.9804976+00:00",
"job_planning_count": 74
}
application/xml, text/xml
<jobs_view xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <_parent_id>80fe7f41-25b7-495d-970f-cef95147cb79</_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>cc54697c-5682-4183-94d0-a5ae707ad491</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:11.980Z</date_closed> <date_create>2026-06-24T04:03:11.980Z</date_create> <date_reported_by_company>2026-06-24T04:03:11.980Z</date_reported_by_company> <date_update>2026-06-24T04:03:11.980Z</date_update> <dateutc_closed>2026-06-24T04:03:11.980Z</dateutc_closed> <dateutc_create>2026-06-24T04:03:11.980Z</dateutc_create> <dateutc_in_progress>2026-06-24T04:03:11.980Z</dateutc_in_progress> <dateutc_max_sla_contact>2026-06-24T04:03:11.980Z</dateutc_max_sla_contact> <dateutc_max_sla_hands_on_machine>2026-06-24T04:03:11.980Z</dateutc_max_sla_hands_on_machine> <dateutc_max_sla_resolution>2026-06-24T04:03:11.980Z</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>f1bb4246-22fc-4220-a1f1-d9ebb2c69f3a</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:11.980Z</due_date> <earliest_date_plannable>2026-06-24T04:03:11.980Z</earliest_date_plannable> <equipment_brand_id>f5a1c06a-26b9-4dc0-8835-48c88c4e6ba2</equipment_brand_id> <equipment_brand_name>sample string 45</equipment_brand_name> <equipment_family_id>1208e5db-ea3e-4467-9920-72221e1e6c9f</equipment_family_id> <equipment_family_name>sample string 43</equipment_family_name> <equipment_model_id>a6ccc039-7004-4f09-8aac-c4e97dc9778e</equipment_model_id> <equipment_model_name>sample string 41</equipment_model_name> <first_planning_date>2026-06-24T04:03:11.980Z</first_planning_date> <first_planning_userfullname>sample string 56</first_planning_userfullname> <has_child>true</has_child> <id>bd6dc318-28a0-49a1-83da-0e093348151d</id> <id2>2</id2> <job_priority_id>bb0ab6da-db80-4699-8b25-aee531c38541</job_priority_id> <job_priority_name>sample string 8</job_priority_name> <job_reference>sample string 72</job_reference> <job_status_id>fa241c74-7d6d-48f2-b4fe-7c6ccb60a8e1</job_status_id> <job_status_name>sample string 10</job_status_name> <job_type_id>91f42325-6497-4b9d-9256-148eec7f9109</job_type_id> <job_type_name>sample string 6</job_type_name> <modified_dateutc>2026-06-24T04:03:11.980Z</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>01942851-e1fc-4ca1-a542-e5fb9b081ab3</project_id> <project_id2>32</project_id2> <project_location>sample string 34</project_location> <project_name>sample string 36</project_name> <project_parent_id>63020408-7657-45ea-82fc-66dd7458d1e5</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>21811af1-e251-4af6-ae50-a65ddeec9a70</requested_by_contact_id> <root_parent_id>c3008dad-004b-4190-b679-32db8714d21b</root_parent_id> <source_db_table_id>e138f568-0108-4517-af24-68eb9f429c6b</source_db_table_id> <source_db_table_name>sample string 25</source_db_table_name> <source_id_in_table>bfbc6a9f-b8a7-465a-a428-d155fbcb60af</source_id_in_table> <suggested_date_start>2026-06-24T04:03:11.980Z</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>