Unable to nullify a non-system attribute from DateTime value to null or empty value using Storage service
To support a business use case, a user would need to update an existing attribute (with data type as date time) residing under data { } section of a work-product-component schema from a valid DateTime value (e.g.- 2023-08-10T00:00:00+0000) to "null" or an empty string (""). But when this transaction is attempted and executed via STORAGE service, the value of the attribute remains unchanged even after a successful execution (HTTP status code - 200). STORAGE service should allow users to register an empty/null value for DateTime attribute. Please note that the attribute "DateSubmitted" does not belong to the list of System Properties like "createTime" or "modifyTime" and might not be used for auditing purposes.
-
"kind": "shell:wks:work-product-component--LQCWebSheet:1.0.0"
-
Example record: { "data": {
"ApprovalStatusTypeID": "osdu:reference-data--LQCApprovalStatusType:Submitted:",
"Source": "shell",
"Name": null, "IsBonus": false,
"LoggingInterpreter": null, "FinalDeliveryDuration": 1.0, "WebSheetName": "Test_LWD_Websheet_Edit_Approver_Request_v2", "LastUpdatedPPEmail": null, "ApproverEmail": "NewApprover1.Nayak@shell.com",
"WellboreID": "osdu:master-data--Wellbore:BDLQCGOM2_1_WB2:", " "OperationalComment": "Test_LWD_Websheet_Edit_Approver_v2_Operational_Comments",
"ApproverComment": null,
"SourceApplication": "Created in LQC WebSheets", "SubmitterName": "Sujith.Submitter@shell.com",
"IsApprovalStatusReset": true, "DateSubmitted": "2023-06-05T07:56:19.914485+0000" }, "kind": "shell:wks:work-product-component--LQCWebSheet:1.0.0", "source": "wks", "acl": { "viewers": [ "data.default.viewers@osdu.shell.com" ], "owners": [ "data.default.owners@osdu.shell.com" ] }, "type": "work-product-component--LQCWebSheet", "version": 1686283555925808, "tags": { "normalizedKind": "shell:wks:work-product-component--LQCWebSheet:1" }, "modifyUser": "Monalisa.Mohapatra@shell.com", "modifyTime": "2023-06-09T04:05:56.083Z", "createTime": "2022-12-15T11:26:58.940Z", "authority": "shell", "namespace": "shell:wks", "legal": { "legaltags": [ "osdu-shell-lqc-dataset-testing" ], "otherRelevantDataCountries": [ "US" ], "status": "compliant" }, "createUser": "Labanyendu.Nayak@shell.com", "id": "osdu:work-product-component--LQCWebSheet:62008" } -
Target attribute - "data.DateSubmitted"