Hello,
I am trying to retrieve ID values from a JSON output (target system) that has multiple objects and compare it with SQL data (source) with an ID column, then update the target system if both source and target ID match. I was successful in doing this update when I had only one object in the JSON output, but now that I have multiple objects in the output, how can I retrieve the ID of each object and compare it with the SQL ID?
I tried moving the filter array to apply to each, but the output is coming in as blank. What is the best way to achieve this? Thank you in advance!
sample JSON output : [ {
"workspaceId": "21b184a3-f-dcf7fb6c792d",
"globalId": "21b184a3-5411-4db6c792d:112523",
"id": "112523",
"objectTypeAttributeId": "124",
"objectAttributeValues": [
{
"value": "2024-06-05T20:24:58.299Z",
"displayValue": "05/Jun/24 8:24 PM",
"searchValue": "2024-06-05T20:24:58.299Z",
"referencedType": false
}
],
"objectId": "1834"
},
{
"workspaceId": "21b184a3-4d4c-a9af-dcf7fb6c792d",
"globalId": "21b184a3-5411-7fb6c792d:112529",
"id": "112529",
"objectTypeAttributeId": "926",
"objectAttributeValues": [
{
"value": "65",
"displayValue": "65",
"searchValue": "65",
"referencedType": false
}
],
"objectId": "1834"
}
],
"_links": {
"self": "https://api.atlassian.com/"
},
"name": "eStatement"
}
],
{
"workspaceId": "21b184a3-541-dcf7fb6c792d",
"globalId": "21b184a3-5411-4d4c2507",
"id": "112507",
"objectTypeAttributeId": "124",
"objectAttributeValues": [
{
"value": "2024-05-09T23:02:51.620Z",
"displayValue": "09/May/24 11:02 PM",
"searchValue": "2024-05-09T23:02:51.620Z",
"referencedType": false
}
],
"objectId": "1833"
},
{
"workspaceId": "21b184a3-5411-4d4c-a9af-dcf7fb6c792d",
"globalId": "21b184a3-5411-4d4c-a9af-dcf7fb6c792d:112513",
"id": "112513",
"objectTypeAttributeId": "926",
"objectAttributeValues": [
{
"value": "85",
"displayValue": "85",
"searchValue": "85",
"referencedType": false
}
],
"objectId": "1833"
}
],
"_links": {
"self": "https://api.atlassian.com/"
},
"name": "FIS - Direct Branch (Branch Capture)"
}
]
