Answered

Is there a way to extract the "Attributes" data from this JSON?

(0) Share

Report

Posted on by AustinWolf

Hi All,

I'm currently trying to create a flow that tracks the updates to an ArcGIS online feature layer. I was wondering if there was a way to extract the Attribute data from the following code so I can reformat it into a more user friendly appearance in an email.

I'm a JSON and Power Automate newbie, so any and all suggestions would be great. Thanks in advance!

{
 "layerServerGens": [
 {
 "id": 0,
 "serverGen": 458189
 }
 ],
 "transportType": "esriTransportTypeUrl",
 "responseType": "esriDataChangesResponseTypeEdits",
 "edits": [
 {
 "id": 0,
 "features": {
 "adds": [],
 "updates": [
 {
 "geometry": {
 "rings": [
 [
 [
 2556265.90578417,
 482548.2758253
 ],
 [
 2561942.66804101,
 482305.347848049
 ],
 [
 2562932.3081841,
 476869.569885384
 ],
 [
 2555554.10480682,
 476454.314157847
 ],
 [
 2556265.90578417,
 482548.2758253
 ]
 ]
 ]
 },
 "attributes": {
 "OBJECTID": 45,
 "GlobalID": "F35B148D-1294-4CAC-8203-CA190FE96EF8",
 "OutageType": null,
 "AlertType": "BW",
 "AlertDetails": null,
 "ScheduledOutage": null,
 "ScheduledServiceRestoration": null,
 "AdditionalResources": null,
 "Status": "A",
 "CustomersAffected": null,
 "InternalComments": null,
 "OutageDetails": null,
 "Division": "SO",
 "Submitter_Name": "Austin Test"
 }
 }
 ],
 "deleteIds": []
 }
 }
 ]
}

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (1)

Report
Here is the high-level flow:
Here are the details. Your data was pasted into a Compose action:
Then we use an expression to select the attributes:
You can copy the expression below:

outputs('Compose_Data')?['edits'][0]['features/updates'][0]['attributes']

To get the ObjectID or any other property we can use the following expressions:
Here are the expressions to get the other properties:

outputs('Compose_Attributes')?['OBJECTID'] outputs('Compose_Attributes')?['GlobalID'] outputs('Compose_Attributes')?['OutageType'] outputs('Compose_Attributes')?['AlertType'] outputs('Compose_Attributes')?['AlertDetails'] outputs('Compose_Attributes')?['ScheduledOutage'] outputs('Compose_Attributes')?['ScheduledServiceRestoration'] outputs('Compose_Attributes')?['AdditionalResources'] outputs('Compose_Attributes')?['Status'] outputs('Compose_Attributes')?['CustomersAffected'] outputs('Compose_Attributes')?['InternalComments'] outputs('Compose_Attributes')?['OutageDetails'] outputs('Compose_Attributes')?['Division'] outputs('Compose_Attributes')?['Submitter_Name']

Sample output after run time:
Hope this helps.

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
AustinWolf 12 on at

Like (0)

Report

That worked beautifully! Thank you so much for your help

Was this reply helpful? Yes No