--- title: "JobCombinedValues" slug: "safran-project-integration-api-job-combined-values" updated: 2024-11-22T08:27:06Z published: 2024-11-22T08:27:06Z canonical: "docs.safran.com/safran-project-integration-api-job-combined-values" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.safran.com/llms.txt > Use this file to discover all available pages before exploring further. # JobCombinedValues ## Job Combined Values ### /v1/dru/jobcombinedvalues/ The Data Reporting Utility enables users to define aggregation jobs and generate aggregated results. The job definitions and results are stored in your database and can be accessed through this API List Of Dataset Values aggregated from a Data Reporting Utility [Job](/v1/docs/jobs). The [Jobs](/v1/docs/jobs), [JobDatasetValues](/v1/docs/jobdatasetvalues), [JobGroupValues](/v1/docs/jobgroupvalues) and [JobPeriodValues](/v1/docs/jobperiodvalues) retrives individual values, this endpoint combines them into one result set. ### Example for calling: http://server/v1/dru/jobcombinedvalues?id=2 – retrieves values from the job with id 2 ### Allowed Methods: [GET] API Controller: **dru_jobresult** ### Description: 1. Retrieves combined aggregated results of a Job and details of the job it selves. **Parameters:** | **Name** | **Type** | **Description** | **Notes** | | --- | --- | --- | --- | | id | integer | The ID of the Job | Mandatory | ### Response Fields: | **Name** | **Type** | **Description** | **Notes** | | --- | --- | --- | --- | | jobdetails | jobdetails[] | Details of the Job, used when calculating the result, see [jobdetails](/v1/docs/jobcombinedvalues#jobdetails) | | | datagroup | datagroup[] | The details of the grouping on the Job, see [Jobs.DataGroup](/v1/docs/jobs#job-datagroup-table) | | | period | period[] | The periods of the calculated aggregated values, see [JobPeriodValues](/v1/docs/jobperiodvalues) | | | result | result[] | The calculated aggregation values, see [Result](/v1/docs/jobcombinedvalues#result) | | #### jobdetails ##### Jobdetails table | **Name** | **Type** | **Description** | **Notes** | | --- | --- | --- | --- | | jobid | integer | The ID of the Job | | | jobname | string | The name of the Job | | | project | project[] | The project linked to the Job, see [Jobs.Project](/v1/docs/jobs#job-project-table) | | | interval | interval[] | The Job interval, see [Jobs.Interval](/v1/docs/jobs#job-interval-table) | | #### result ##### Result table | **Name** | **Type** | **Description** | **Notes** | | --- | --- | --- | --- | | jobdatafield_id | integer | The ID of the Dataset | | | group | group[] | The group of the dataset result, see [JobDatasetValues.Group](/v1/docs/jobdatasetvalues#job-group-table) | | | period | period[] | Periods found in the Dataset result [JobDatasetValues.Period](/v1/docs/jobdatasetvalues#job-period-table) | | | value | value[] | Aggregated values found in the Dataset result, see [JobDatasetValues.Value](/v1/docs/jobdatasetvalues#job-value-table) | | **Show JSON Response** json result ``` [ { "jobdetails": { "jobId": 1, "jobName": "Test Minutes Sundays (Produces 40 records)", "project": { "network_id": 1280, "network_name": "DRU Minutes Sundays(91)", "project_id": 1237 }, "interval": { "interval": 1, "unit": "Week" } }, "datagroup": [ { "number": 1, "field": "an", "oc_level": 1, "label": "" }, { "number": 2, "field": "r1", "oc_level": 2, "label": "Reference 1" }, { "number": 3, "field": "l55", "oc_level": 3, "label": "Flag 55" }, { "number": 4, "field": "r46", "oc_level": 4, "label": "Reference 46" }, { "number": 5, "field": "t", "oc_level": 5, "label": "" } ], "period": [ { "start": "2024-01-01T00:00:00", "finish": "2024-06-02T00:00:00" }, { "start": "2024-06-02T00:00:00", "finish": "2024-06-03T00:00:00" }, { "start": "2024-06-17T00:00:00", "finish": "2024-06-18T00:00:00" } ], "result": [ { "jobdatafield_id": 1, "group": { "short1": "00010", "short2": "0", "short3": "No", "short4": "0", "short5": "" }, "period": { "start": "2024-08-05T00:00:00", "finish": "2024-08-12T00:00:00" }, "value": { "period": 50, "cumulative": 50, "manpower": 0.297619 } }, { "jobdatafield_id": 1, "group": { "short1": "00010", "short2": "0", "short3": "No", "short4": "0", "short5": "" }, "period": { "start": "2024-08-12T00:00:00", "finish": "2024-08-19T00:00:00" }, "value": { "period": 0, "cumulative": 50, "manpower": 0 } }, { "jobdatafield_id": 4, "group": { "short1": "00010", "short2": "0", "short3": "No", "short4": "0", "short5": "" }, "period": { "start": "2024-09-09T00:00:00", "finish": "2051-01-01T00:00:00" }, "value": { "period": 0, "cumulative": 50, "manpower": 0 } } ] } ] ```