I am having a Json like below and I need to update the "A_PLANNEDEFFORT" and "A_REMAININGUNITS" properties and round up the values in them to 1 significant digit. As there are multiple properties in PLM_P6_ACTIVITY object, I am trying to do this in a for Each loop to round off all occurrences of "A_PLANNEDEFFORT" and "A_REMAININGUNITS" but I am not able to implement these changes. I tried parsing these into jobject and tried a few things but it didn't work. Can you please suggest a way?
{
"PLM_P6_PROJECT": {
"P_PROJECTID": "P0065293",
"P_STARTDATE": "2022-06-23T08:00:00",
"P_FINISHDATE": "2022-08-08T11:00:00",
"P_STATE": "Active",
"P_ACTUALSTARTDATE": "2022-07-12T08:00:00",
"P_ACTUALFINISHDATE": null,
"P_OPERATION": "DELTA",
"P_RESOURCE_UPDATE": true
},
"PLM_P6_USER": {
"PLM_USER_SSO": "plmgtccp6dq"
},
"PLM_P6_ACTIVITY": [
{
"A_PARENTACTIVITYID": "P0065293",
"A_PROJECTID": "P0065293",
"A_TYPE": "Task Dependent",
"A_ACTIVITYID": "A1000",
"A_NAME": "New Activity",
"A_PLANNEDFINISHDATE": "2022-08-08T11:00:00",
"A_PLANNEDSTARTDATE": "2022-08-01T11:00:00",
"A_ACTUALFINISHDATE": null,
"A_ACTUALSTARTDATE": "2022-07-13T08:00:00",
"A_CRITICALPATH": "Y",
"A_INITIALBASELINESTARTDATE": "2022-06-23T08:00:00",
"A_INITIALBASELINEFINISHDATE": "2022-06-29T17:00:00",
"A_EARLYFINISHDATE": "2022-08-08T11:00:00",
"A_EARLYSTARTDATE": "2022-08-01T11:00:00",
"A_FREEFLOAT": "0",
"A_LATEFINISHDATE": "2022-08-08T11:00:00",
"A_LATESTARTDATE": "2022-08-01T11:00:00",
"A_TOTALFLOAT": "0",
"A_CUSTOMERNEEDDATE": null,
"A_MANUFACTURINGNEEDDATE": null,
"A_TASKRESPONSIBILITY": "204052404.CTRA",
"A_PRODUCTLINE": "",
"A_VOUCHERFUNDINGCODE": "RTS",
"A_MANUFACTURINGDELIVERY": "",
"A_TITLE": "New Activity",
"A_DESCRIPTION": null,
"A_PLMLYFECICLESTATE": "Active",
"A_DURATION": 5.0,
"A_ACTUALDURATION": 47.0,
"A_PERCENTCOMPLETE": 90.0,
"A_PRIMARYOWNER": "502805993",
***"A_PLANNEDEFFORT": 80.0,
"A_REMAININGUNITS": 40.0,***
"A_PRIMARYCONSTRAINTTYPE": null,
"A_PRIMARYCONSTRAINTDATE": null,
"A_FOREFINISHDATE": null,
"A_BFEEDBACK": null,
"A_LDFLAG": "No",
"A_OPERATION": "UPDATE",
"A_ACTUALHOURS": "0",
"A_ADD_REP_REQUIRED": ""
},
{
"A_PARENTACTIVITYID": "STM.LPA.NZL.STK",
"A_PROJECTID": "1511771E",
"A_TYPE": "Task Dependent",
"A_ACTIVITYID": "YE10",
"A_NAME": "LPA MARGIN NOZZLE DEFINITION LP11 L1 (STM.LPA.NZL.STK)",
"A_PLANNEDFINISHDATE": "2025-11-21T17:00:00",
"A_PLANNEDSTARTDATE": "2025-11-21T17:00:00",
"A_ACTUALFINISHDATE": "2021-02-03T17:00:00",
"A_ACTUALSTARTDATE": "2021-02-03T08:00:00",
"A_CRITICALPATH": "N",
"A_INITIALBASELINESTARTDATE": "2021-02-09T08:00:00",
"A_INITIALBASELINEFINISHDATE": "2021-02-15T17:00:00",
"A_EARLYFINISHDATE": "2022-09-02T17:00:00",
"A_EARLYSTARTDATE": "2022-09-02T17:00:00",
"A_FREEFLOAT": "0",
"A_LATEFINISHDATE": "2025-11-21T17:00:00",
"A_LATESTARTDATE": "2025-11-21T17:00:00",
"A_TOTALFLOAT": "0",
"A_CUSTOMERNEEDDATE": null,
"A_MANUFACTURINGNEEDDATE": "2022-04-26T17:00:00",
"A_TASKRESPONSIBILITY": "204027303.SNJD",
"A_PRODUCTLINE": "STM",
"A_VOUCHERFUNDINGCODE": "RST",
"A_MANUFACTURINGDELIVERY": "Y",
"A_TITLE": "LPA MARGIN NOZZLE DEFINITION LP11 L1 (STM.LPA.NZL.STK)",
"A_DESCRIPTION": null,
"A_PLMLYFECICLESTATE": "Complete",
"A_DURATION": 5.0,
"A_ACTUALDURATION": 1.0,
"A_PERCENTCOMPLETE": 100.0,
"A_PRIMARYOWNER": "204027303",
"A_PLANNEDEFFORT": 30.60,
"A_REMAININGUNITS": 0.0,
"A_PRIMARYCONSTRAINTTYPE": "Finish On or Before",
"A_PRIMARYCONSTRAINTDATE": "2021-09-09T21:00:00",
"A_FOREFINISHDATE": null,
"A_BFEEDBACK": "204040824 @ 03-Feb-21 06 PM: Task closed as part of reconiling schedule with final BOM (released part identified during PBOM reviews)",
"A_LDFLAG": "No",
"A_OPERATION": "UPDATE",
"A_ACTUALHOURS": "0",
"A_ADD_REP_REQUIRED": ""
},
{
"A_PARENTACTIVITYID": "STM.LPA.NZL.STK",
"A_PROJECTID": "1511771E",
"A_TYPE": "Task Dependent",
"A_ACTIVITYID": "YG00",
"A_NAME": "LPA MARGIN NOZZLE DEFINITION LP12 L0 (STM.LPA.NZL.STK)",
"A_PLANNEDFINISHDATE": "2025-11-21T17:00:00",
"A_PLANNEDSTARTDATE": "2025-11-21T17:00:00",
"A_ACTUALFINISHDATE": "2021-02-03T17:00:00",
"A_ACTUALSTARTDATE": "2021-02-03T08:00:00",
"A_CRITICALPATH": "N",
"A_INITIALBASELINESTARTDATE": "2021-02-09T08:00:00",
"A_INITIALBASELINEFINISHDATE": "2021-02-15T17:00:00",
"A_EARLYFINISHDATE": "2022-09-02T17:00:00",
"A_EARLYSTARTDATE": "2022-09-02T17:00:00",
"A_FREEFLOAT": "0",
"A_LATEFINISHDATE": "2025-11-21T17:00:00",
"A_LATESTARTDATE": "2025-11-21T17:00:00",
"A_TOTALFLOAT": "0",
"A_CUSTOMERNEEDDATE": null,
"A_MANUFACTURINGNEEDDATE": "2022-04-26T17:00:00",
"A_TASKRESPONSIBILITY": "204027303.SNJD",
"A_PRODUCTLINE": "STM",
"A_VOUCHERFUNDINGCODE": "RST",
"A_MANUFACTURINGDELIVERY": "Y",
"A_TITLE": "LPA MARGIN NOZZLE DEFINITION LP12 L0 (STM.LPA.NZL.STK)",
"A_DESCRIPTION": null,
"A_PLMLYFECICLESTATE": "Complete",
"A_DURATION": 5.0,
"A_ACTUALDURATION": 1.0,
"A_PERCENTCOMPLETE": 100.0,
"A_PRIMARYOWNER": "204027303",
"A_PLANNEDEFFORT": 30.60,
"A_REMAININGUNITS": 0.0,
"A_PRIMARYCONSTRAINTTYPE": "Finish On or Before",
"A_PRIMARYCONSTRAINTDATE": "2021-09-09T21:00:00",
"A_FOREFINISHDATE": null,
"A_BFEEDBACK": "204040824 @ 03-Feb-21 06 PM: Task closed as part of reconiling schedule with final BOM (released part identified during PBOM reviews)",
"A_LDFLAG": "No",
"A_OPERATION": "UPDATE",
"A_ACTUALHOURS": "0",
"A_ADD_REP_REQUIRED": ""
}
],
"PLM_P6_RELATIONSHIP": [],
"PLM_P6_RESOURCEASSIGNMENT": [],
"PLM_P6_DELETE_Activity": [],
"PLM_P6_DELETE_Resource": [],
"PLM_P6_DELETE_Relationship": [],
"PLM_P6_TOTAL_ACTIVITIES": [],
"PLM_P6_TOTAL_ASSIGNMENTS": {},
"PLM_P6_TOTAL_RELATIONSHIPS": {}
}