Power Platform Community Forum Thread Details

Hi,

Hope you all doing good. I have 2 JSON Array, I am trying to copy a few values from one JSON array to another JSON with fewer columns.

JSON 1:

{
"d": {
"results": [
{
"FieldValuesForEdit": {
"__deferred": {
"uri": "https://aaaaaaaaa.sharepoint.com/sites/1234/_api/Web/Lists(guid'1234-430a-8eca-cfee567f3618')/Items(1)/FieldValuesForEdit"
}
},
"File": {
"__deferred": {
"uri": "https://XXXXXXXXXXXXX.sharepoint.com/sites/1234/_api/Web/Lists(guid'1234-430a-8eca-cfee567f3618')/Items(1)/File"
}
},
"Folder": {
"__deferred": {
"uri": "https://XXXXXXXXXXXXX.sharepoint.com/sites/1234/_api/Web/Lists(guid'1234-430a-8eca-cfee567f3618')/Items(1)/Folder"
}
},

"Versions": {
"__deferred": {
"uri": "https://XXXXXXXXXXXXX.sharepoint.com/sites/1234/_api/Web/Lists(guid'xxxxx-a4cc-430a-8eca-cfee567f3618')/Items(1)/Versions"
}
},
"FileSystemObjectType": 0,
"Id": 1,
"ServerRedirectedEmbedUri": null,
"ServerRedirectedEmbedUrl": "",
"ID": 1,
"ContentTypeId": "0x0100D698A5AB9FCB8C45A52CD705C96FECF5",
"Title": "Risk Assessment",
"Modified": "2022-05-26T14:49:56Z",
"Created": "2022-05-26T14:49:56Z",
"AuthorId": 17,
"EditorId": 17,
"OData__UIVersionString": "1.0",
"Workpapers_x003a_": null,
"Testing_x0020_Conclusion_x003a_": null,
"Complete": false,
"Issue": null,
"Manager_x0020_Detail_x0020_Revie": false,
"Manager_x0020_Review_x0020_Notes": null,
"Issues_x0020_Log_x0020_Finding_x": null
}
]
}

JSON 2 :

{
"Title": "",
"Modified": "",
"Created": "",
"AuthorId": ,
"EditorId": ,
"OData__UIVersionString": "",
"Workpapers_x003a_": ,
"Testing_x0020_Conclusion_x003a_": "",
"Complete": ,
"Issue": ,
"Manager_x0020_Detail_x0020_Revie": ,
"Manager_x0020_Review_x0020_Notes": ,
"Issues_x0020_Log_x0020_Finding_x":
}

Here I need to copy values from JSON 1 to JSON 2 if it matches the Key. (Ex: Copy the Complete field value ' false' in JSON 1 to JSON 2 , highlighted ) Any idea on this

Categories:

General topics