topic Re: Esri Webhooks for ArcGIS Online - Payload schema for tracking changes in a Hosted Feature Service? in ArcGIS Online Questions

Esri Webhooks for ArcGIS Online - Payload schema for tracking changes in a Hosted Feature Service?

Henry_PeleshBW — Thu, 15 Oct 2020 14:24:19 GMT

Hello all,

I am working to create a Webhook for a Hosted Feature Service in ArcGIS Online that will use Microsoft Power Automate to send emails when a HTTP request is received. I want to receive emails when a feature service is edited, but I am having trouble with my payload schema for the HTTP request (receiving a "BadRequest" error). I am wondering if anyone has done this and can share what their JSON payload schema consisted of.

Thanks,

Henry

Re: Esri Webhooks for ArcGIS Online - Payload schema for tracking changes in a Hosted Feature Service?

Anonymous User — Thu, 15 Oct 2020 15:05:12 GMT

Hi Henry Pelesh‌, there are some example payloads shown on this blog: Create a hosted feature service webhook

Hope this helps,

-Peter

Re: Esri Webhooks for ArcGIS Online - Payload schema for tracking changes in a Hosted Feature Service?

Henry_PeleshBW — Thu, 15 Oct 2020 15:26:26 GMT

Peter Klingman‌,

Thank you for reaching out. I have gone through the blog post and have been using the example payloads given. My Webhook is looking for when Features are created, so I used the example payload below.

Using this payload schema is still giving me a "BadRequest" error in Microsoft power automate when testing my Flow.

Thanks,

Henry

Re: Esri Webhooks for ArcGIS Online - Payload schema for tracking changes in a Hosted Feature Service?

Anonymous User — Sun, 12 Dec 2021 03:07:04 GMT

Thanks Henry Pelesh‌ - when I test my flow to generate schema it returns a few more properties, then returns the payload within the formdata property. Are you able to test the flow to generate schema or try the syntax that I've pasted below?

{
  "$content-type": "application/x-www-form-urlencoded; charset=utf-8",
  "$content": "cGF5bG9hZD1beyJuYW1lIjoiUGV0ZXIgVGVzdCBTZXB0ZW1iZXIgV2ViaG9vayIsImxheWVySWQiOjAsIm9yZ0lkIjoiV2w3WTFtOTJQYmp0SnM1biIsInNlcnZpY2VOYW1lIjoiV2ViaG9va19GZWF0dXJlX0xheWVyX0RlbW8iLCJsYXN0VXBkYXRlZFRpbWUiOjE2MDAwMzIzMzcyNzIsImNoYW5nZXNVcmwiOiJodHRwcyUzYSUyZiUyZnNlcnZpY2VzLmFyY2dpcy5jb20lMmZXbDdZMW05MlBianRKczVuJTJmYXJjZ2lzJTJmcmVzdCUyZnNlcnZpY2VzJTJmV2ViaG9va19GZWF0dXJlX0xheWVyX0RlbW8lMmZGZWF0dXJlU2VydmVyJTJmZXh0cmFjdENoYW5nZXMlM2ZzZXJ2ZXJHZW5zJTNkJTViNTAzMzI3NzElMmM1MTY3Mzk3MSU1ZCUyNmFzeW5jJTNkdHJ1ZSUyNnJldHVyblVwZGF0ZXMlM2RmYWxzZSUyNnJldHVybkRlbGV0ZXMlM2RmYWxzZSUyNnJldHVybkF0dGFjaG1lbnRzJTNkZmFsc2UiLCJldmVudHMiOlsiRmVhdHVyZXNDcmVhdGVkIl19XQ==",
  "$formdata": [
    {
      "key": "payload",
      "value": "[{\"name\":\"Peter Test September Webhook\",\"layerId\":0,\"orgId\":\"<myOrgName>\",\"serviceName\":\"Webhook_Feature_Layer_Demo\",\"lastUpdatedTime\":1600032337272,\"changesUrl\":\"https://services.arcgis.com/myOrgName/arcgis/rest/services/Webhook_Feature_Layer_Demo/FeatureServer/extractChanges?serverGens=[50332771,51673971]&async=true&returnUpdates=false&returnDeletes=false&returnAttachments=false\",\"events\":[\"FeaturesCreated\"]}]"
    }
  ]
}‍‍‍‍‍‍‍‍‍‍

I hope this helps,

-Peter

Re: Esri Webhooks for ArcGIS Online - Payload schema for tracking changes in a Hosted Feature Service?

hgaignard — Sun, 12 Dec 2021 03:07:07 GMT

Hi Henry Pelesh,

The webhook request sent by ArcGIS Online does not appear to contain a Content-Type : application/json in the header. This is why Power Automate considers it by default as application/x-www-form-urlencoded.

1- You can use this Request Body JSON Schema for your module When a HTTP request is received or generate schema from payload sample provided by Peter Klingman :

{
  "type": "object",
  "properties": {
    "$content-type": {
      "type": "string"
    },
    "$content": {
      "type": "string"
    },
    "$formdata": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "key": {
            "type": "string"
          },
          "value": {
            "type": "string"
          }
        },
        "required": [
          "key",
          "value"
        ]
      }
    }
  }
}‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

After running a test, you should get this $formdata output :

[
  {
    "key": "payload",
    "value": "[{\"name\":\"Power Automate\",\"layerId\":0,\"orgId\":\"<myOrgID>\",\"serviceName\":\"demoWebhook\",\"lastUpdatedTime\":1603875450774,\"changesUrl\":\"https://services.arcgis.com/<myOrgID>/ArcGIS/rest/services/demoWebhook/FeatureServer/extractChanges?serverGens=[24014837,24187488]&async=true&returnInserts=false&returnDeletes=false&returnAttachments=false\",\"events\":[\"FeaturesUpdated\"]}]"
  }
]‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Example :

2- To extract and parse the payload value, you can use Parse JSON module with this content as input (return the first element for the payload value in formdata) :

first(json(triggerFormDataValue('payload')))

or if your prefer :

first(json(triggerBody()?['$formdata'][0]?['value']))

or that

json(triggerBody()?['$formdata'][0]?['value'])[0]

And use this schema to parse the payload :

{
"type": "object",
"properties": {
"name": {
"type": "string"
},
"layerId": {
"type": "integer"
},
"orgId": {
"type": "string"
},
"serviceName": {
"type": "string"
},
"lastUpdatedTime": {
"type": "integer"
},
"changesUrl": {
"type": "string"
},
"events": {
"type": "array",
"items": {
"type": "string"
}
}
}
}‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Example :

After running a test, you should get this output :

{
  "name": "Power Automate",
  "layerId": 0,
  "orgId": "<myOrgID>",
  "serviceName": "demoWebhook",
  "lastUpdatedTime": 1603875450774,
  "changesUrl": "https://services.arcgis.com/<myOrgID>/ArcGIS/rest/services/demoWebhook/FeatureServer/extractChanges?serverGens=[24014837,24187488]&async=true&returnInserts=false&returnDeletes=false&returnAttachments=false",
  "events": [
    "FeaturesUpdated"
  ]
}‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Now, you can use informations contained in the payload as dynamic content to request changesUrl, ... like this blog: Create a hosted feature service webhook

Re: Esri Webhooks for ArcGIS Online - Payload schema for tracking changes in a Hosted Feature Service?

Henry_PeleshBW — Tue, 03 Nov 2020 13:39:42 GMT

This was very helpful. Thank you.

-Henry

Re: Esri Webhooks for ArcGIS Online - Payload schema for tracking changes in a Hosted Feature Service?

Henry_PeleshBW — Tue, 03 Nov 2020 13:43:53 GMT

Juliano Kersting,

Thank you very much for this information and the detailed response. This was very helpful and I appreciate you taking the time to provide this information.

I am hoping you can expand a bit on how to "have another flow handling only the alert/message piece"? Sending alerts as a part of our flow is ultimately the goal for our WebHook work flow. I am wondering how a separate flow that handles the alerts will be able to communicate with the other flow that handles the HTTP request and parsing the json?

Thank you again,

-Henry

Re: Esri Webhooks for ArcGIS Online - Payload schema for tracking changes in a Hosted Feature Service?

Anonymous User — Sun, 12 Dec 2021 03:07:12 GMT

I wanted to add to the great information already provided here.

To avoid Bad Requests, try removing any actions that sends alerts or messages or otherwise connects to Microsoft Office or teams, mail etc.

Due to a bug (wrong content-type) I have found that these actions can cause Bad Requests when getting requests from a live Feature service WebHook trigger. This can be deceiving as it usually works well in test mode (when using a previous successful test request).

If you have a need to have alerts as par of your workflows, maybe a workaround would be to have another flow handling only the alert/message piece.

I was able to create a working Flow package (with no alerts) that completes the following workflow:

- handles request with Payload

- gets token

- query URL returning final JSON with feature changes.

The actions json are below. Just export/change/import into new Flow and change credentials within.

Hopefully it will help those interested handling feature service changes with Power Automate.

{         "actions": {
            "Parse_JSON": {
               "runAfter": {
                  "Initialize_variable_-_STATUS": [
                     "Succeeded"
                  ]
               },
               "type": "ParseJson",
               "inputs": {
                  "content": "@triggerBody()?['$formdata']",
                  "schema": {
                     "type": "array",
                     "items": {
                        "type": "object",
                        "properties": {
                           "key": {
                              "type": "string"
                           },
                           "value": {
                              "type": "string"
                           }
                        },
                        "required": [
                           "key",
                           "value"
                        ]
                     }
                  }
               }
            },
            "Apply_to_each": {
               "foreach": "@body('Parse_JSON')",
               "actions": {
                  "Parse_JSON_2": {
                     "runAfter": {},
                     "type": "ParseJson",
                     "inputs": {
                        "content": "@items('Apply_to_each')['value']",
                        "schema": {
                           "type": "array",
                           "items": {
                              "type": "object",
                              "properties": {
                                 "name": {
                                    "type": "string"
                                 },
                                 "layerId": {
                                    "type": "integer"
                                 },
                                 "orgId": {
                                    "type": "string"
                                 },
                                 "serviceName": {
                                    "type": "string"
                                 },
                                 "lastUpdatedTime": {
                                    "type": "integer"
                                 },
                                 "changesUrl": {
                                    "type": "string"
                                 },
                                 "events": {
                                    "type": "array",
                                    "items": {
                                       "type": "string"
                                    }
                                 }
                              },
                              "required": [
                                 "name",
                                 "layerId",
                                 "orgId",
                                 "serviceName",
                                 "lastUpdatedTime",
                                 "changesUrl",
                                 "events"
                              ]
                           }
                        }
                     }
                  },
                  "HTTP": {
                     "runAfter": {
                        "Parse_JSON_2": [
                           "Succeeded"
                        ]
                     },
                     "type": "Http",
                     "inputs": {
                        "method": "POST",
                        "uri": "https://www.arcgis.com/sharing/rest/generateToken",
                        "headers": {
                           "Content-Type": "application/x-www-form-urlencoded"
                        },
                        "body": "username=@{variables('Username')}&password=@{variables('Password')}&f=json&referer=http://arcgis.com"
                     }
                  },
                  "Parse_JSON_3": {
                     "runAfter": {
                        "HTTP": [
                           "Succeeded"
                        ]
                     },
                     "type": "ParseJson",
                     "inputs": {
                        "content": "@body('HTTP')",
                        "schema": {
                           "properties": {
                              "expires": {
                                 "type": "integer"
                              },
                              "ssl": {
                                 "type": "boolean"
                              },
                              "token": {
                                 "type": "string"
                              }
                           },
                           "type": "object"
                        }
                     }
                  },
                  "Apply_to_each_2": {
                     "foreach": "@body('Parse_JSON_2')",
                     "actions": {
                        "HTTP_2": {
                           "runAfter": {},
                           "type": "Http",
                           "inputs": {
                              "method": "POST",
                              "uri": "@{items('Apply_to_each_2')['changesUrl']}&token=@{body('Parse_JSON_3')?['token']}&f=json",
                              "headers": {
                                 "Content-Type": "application/x-www-form-urlencoded"
                              }
                           }
                        },
                        "Parse_JSON_4": {
                           "runAfter": {
                              "HTTP_2": [
                                 "Succeeded"
                              ]
                           },
                           "type": "ParseJson",
                           "inputs": {
                              "content": "@body('HTTP_2')",
                              "schema": {
                                 "type": "object",
                                 "properties": {
                                    "statusUrl": {
                                       "type": "string"
                                    }
                                 }
                              }
                           }
                        },
                        "Do_until": {
                           "actions": {
                              "HTTP_3": {
                                 "runAfter": {},
                                 "type": "Http",
                                 "inputs": {
                                    "method": "POST",
                                    "uri": "@{body('Parse_JSON_4')?['statusUrl']}?token=@{body('Parse_JSON_3')?['token']}&f=json",
                                    "headers": {
                                       "Content-Type": "application/x-www-form-urlencoded"
                                    }
                                 }
                              },
                              "Parse_JSON_5": {
                                 "runAfter": {
                                    "HTTP_3": [
                                       "Succeeded"
                                    ]
                                 },
                                 "type": "ParseJson",
                                 "inputs": {
                                    "content": "@body('HTTP_3')",
                                    "schema": {
                                       "type": "object",
                                       "properties": {
                                          "submissionTime": {
                                             "type": "integer"
                                          },
                                          "lastUpdatedTime": {
                                             "type": "integer"
                                          },
                                          "status": {
                                             "type": "string"
                                          },
                                          "responseType": {
                                             "type": "string"
                                          },
                                          "resultUrl": {
                                             "type": "string"
                                          }
                                       }
                                    }
                                 }
                              },
                              "Set_variable": {
                                 "runAfter": {
                                    "Parse_JSON_5": [
                                       "Succeeded"
                                    ]
                                 },
                                 "type": "SetVariable",
                                 "inputs": {
                                    "name": "Status",
                                    "value": "@body('Parse_JSON_5')?['status']"
                                 }
                              },
                              "Condition": {
                                 "actions": {
                                    "HTTP_4": {
                                       "runAfter": {},
                                       "type": "Http",
                                       "inputs": {
                                          "method": "POST",
                                          "uri": "@{body('Parse_JSON_5')?['resultUrl']}?token=@{body('Parse_JSON_3')?['token']}&f=json",
                                          "headers": {
                                             "Content-Type": "application/x-www-form-urlencoded"
                                          }
                                       }
                                    },
                                    "Parse_JSON_6": {
                                       "runAfter": {
                                          "HTTP_4": [
                                             "Succeeded",
                                             "Failed"
                                          ]
                                       },
                                       "type": "ParseJson",
                                       "inputs": {
                                          "content": "@outputs('HTTP_4')['headers']",
                                          "schema": {
                                             "type": "object",
                                             "properties": {
                                                "location": {
                                                   "type": "string"
                                                }
                                             }
                                          }
                                       }
                                    },
                                    "HTTP_5": {
                                       "runAfter": {
                                          "Parse_JSON_6": [
                                             "Succeeded"
                                          ]
                                       },
                                       "type": "Http",
                                       "inputs": {
                                          "method": "GET",
                                          "uri": "@body('Parse_JSON_6')?['location']"
                                       }
                                    },
                                    "Compose": {
                                       "runAfter": {
                                          "HTTP_5": [
                                             "Succeeded"
                                          ]
                                       },
                                       "type": "Compose",
                                       "inputs": "@base64ToString(body('HTTP_5')?['$content'])"
                                    },
                                    "Parse_JSON_7": {
                                       "runAfter": {
                                          "Compose": [
                                             "Succeeded"
                                          ]
                                       },
                                       "type": "ParseJson",
                                       "inputs": {
                                          "content": "@outputs('Compose')",
                                          "schema": {
                                             "type": "object",
                                             "properties": {
                                                "layerServerGens": {
                                                   "type": "array",
                                                   "items": {
                                                      "type": "object",
                                                      "properties": {
                                                         "id": {
                                                            "type": "integer"
                                                         },
                                                         "serverGen": {
                                                            "type": "integer"
                                                         }
                                                      },
                                                      "required": [
                                                         "id",
                                                         "serverGen"
                                                      ]
                                                   }
                                                },
                                                "transportType": {
                                                   "type": "string"
                                                },
                                                "responseType": {
                                                   "type": "string"
                                                },
                                                "edits": {
                                                   "type": "array",
                                                   "items": {
                                                      "type": "object",
                                                      "properties": {
                                                         "id": {
                                                            "type": "integer"
                                                         },
                                                         "features": {
                                                            "type": "object",
                                                            "properties": {
                                                               "adds": {
                                                                  "type": "array",
                                                                  "items": {
                                                                     "type": "object",
                                                                     "properties": {
                                                                        "geometry": {
                                                                           "type": "object",
                                                                           "properties": {
                                                                              "x": {
                                                                                 "type": "number"
                                                                              },
                                                                              "y": {
                                                                                 "type": "number"
                                                                              }
                                                                           }
                                                                        },
                                                                        "attributes": {
                                                                           "type": "object",
                                                                           "properties": {
                                                                              "OBJECTID": {
                                                                                 "type": "integer"
                                                                              },
                                                                              "GlobalID": {
                                                                                 "type": "string"
                                                                              },
                                                                              "REQUESTID": {},
                                                                              "PROBLEM": {},
                                                                              "COMMENTS": {},
                                                                              "NAME": {},
                                                                              "PHONE": {},
                                                                              "EMAIL": {},
                                                                              "REQUESTDATE": {},
                                                                              "STATUS": {},
                                                                              "FACILITYKEY": {},
                                                                              "CreationDate": {
                                                                                 "type": "integer"
                                                                              },
                                                                              "Creator": {
                                                                                 "type": "string"
                                                                              },
                                                                              "EditDate": {
                                                                                 "type": "integer"
                                                                              },
                                                                              "Editor": {
                                                                                 "type": "string"
                                                                              }
                                                                           }
                                                                        }
                                                                     },
                                                                     "required": [
                                                                        "geometry",
                                                                        "attributes"
                                                                     ]
                                                                  }
                                                               },
                                                               "updates": {
                                                                  "type": "array"
                                                               },
                                                               "deleteIds": {
                                                                  "type": "array"
                                                               }
                                                            }
                                                         },
                                                         "attachments": {
                                                            "type": "object",
                                                            "properties": {
                                                               "adds": {
                                                                  "type": "array"
                                                               },
                                                               "updates": {
                                                                  "type": "array"
                                                               },
                                                               "deleteIds": {
                                                                  "type": "array"
                                                               }
                                                            }
                                                         }
                                                      },
                                                      "required": [
                                                         "id",
                                                         "features",
                                                         "attachments"
                                                      ]
                                                   }
                                                }
                                             }
                                          }
                                       }
                                    },
                                    "Set_variable_2": {
                                       "runAfter": {
                                          "Parse_JSON_7": [
                                             "Succeeded"
                                          ]
                                       },
                                       "type": "SetVariable",
                                       "inputs": {
                                          "name": "Status",
                                          "value": "\"Completed\""
                                       }
                                    }
                                 },
                                 "runAfter": {
                                    "Set_variable": [
                                       "Succeeded"
                                    ]
                                 },
                                 "expression": {
                                    "not": {
                                       "equals": [
                                          "@body('Parse_JSON_5')?['resultUrl']",
                                          ""
                                       ]
                                    }
                                 },
                                 "type": "If"
                              }
                           },
                           "runAfter": {
                              "Parse_JSON_4": [
                                 "Succeeded"
                              ]
                           },
                           "expression": "@equals(variables('Status'), '\"Completed\"')",
                           "limit": {
                              "count": 60,
                              "timeout": "PT1H"
                           },
                           "type": "Until"
                        }
                     },
                     "runAfter": {
                        "Parse_JSON_3": [
                           "Succeeded"
                        ]
                     },
                     "type": "Foreach"
                  }
               },
               "runAfter": {
                  "Parse_JSON": [
                     "Succeeded"
                  ]
               },
               "type": "Foreach"
            },
            "Initialize_variable_-_STATUS": {
               "runAfter": {
                  "Password": [
                     "Succeeded"
                  ]
               },
               "type": "InitializeVariable",
               "inputs": {
                  "variables": [
                     {
                        "name": "Status",
                        "type": "string",
                        "value": "Pending"
                     }
                  ]
               }
            },
            "Password": {
               "runAfter": {
                  "Username": [
                     "Succeeded"
                  ]
               },
               "type": "InitializeVariable",
               "inputs": {
                  "variables": [
                     {
                        "name": "Password",
                        "type": "string",
                        "value": "Password_Goes_Here!"
                     }
                  ]
               }
            },
            "Username": {
               "runAfter": {},
               "type": "InitializeVariable",
               "inputs": {
                  "variables": [
                     {
                        "name": "Username",
                        "type": "string",
                        "value": "Username_Goes_Here!"
                     }
                  ]
               }
            }
         }
}

Re: Esri Webhooks for ArcGIS Online - Payload schema for tracking changes in a Hosted Feature Service?

PhilLarkin1 — Wed, 17 Feb 2021 22:53:58 GMT

This is beautiful. Thank you.

Re: Esri Webhooks for ArcGIS Online - Payload schema for tracking changes in a Hosted Feature Service?

Danielle_Journey — Tue, 23 Feb 2021 16:00:45 GMT

Hi @hgaignard

I'm trying to follow your example, but I am having trouble running the test. I cannot do the "Automatically" test option because I do not have a recently used trigger. And when I try to test "Manually" by creating an update to the hosted feature service... nothing happens. Is there a different way to run a test in order to get the output that you are showing above? I've set up my flow similar to yours. I do not understand how you test just the "When a HTTP request is received". Even if I try to save at this point I get an error message. Any help would be much appreciated!! Thanks

Re: Esri Webhooks for ArcGIS Online - Payload schema for tracking changes in a Hosted Feature Service?

PhilLarkin1 — Tue, 23 Feb 2021 16:05:36 GMT

Hi @Danielle_Journey

Your Request Body JSON Schema appears to be incorrect. I struggled with this piece of the puzzle for quite some time! Copy the example @hgaignard gave in the first code window of his post into the Request Body window you show in your screenshot. Notice the '$content-type' key in his example.

Re: Esri Webhooks for ArcGIS Online - Payload schema for tracking changes in a Hosted Feature Service?

Danielle_Journey — Tue, 23 Feb 2021 16:23:05 GMT

Thank you @PhilLarkin for catching that! I pasted his sample payload directly into the request body, I had pasted it in the "generate schema" window earlier. Now to test... I selected test manually in Power Automate, then I went into AGO in a new window and created two updates to the hosted feature service (Web hook is enabled with correct hookurl). It's been several minutes and I'm still getting the spinning donut in Power Automate. Any other ideas? Thank you!

Re: Esri Webhooks for ArcGIS Online - Payload schema for tracking changes in a Hosted Feature Service?

PhilLarkin1 — Tue, 23 Feb 2021 19:11:11 GMT

Instead of using the payload option, just copy/paste directly into the Request Body JSON Schema window.

An Example:

Re: Esri Webhooks for ArcGIS Online - Payload schema for tracking changes in a Hosted Feature Service?

Danielle_Journey — Tue, 23 Feb 2021 19:35:53 GMT

@PhilLarkin1 That's what I did. Still nothing when I test it:

Re: Esri Webhooks for ArcGIS Online - Payload schema for tracking changes in a Hosted Feature Service?

PhilLarkin1 — Tue, 23 Feb 2021 21:36:56 GMT

You might want to edit your Change Types to call out the subscriptions directly. I'd also double check that the HookUrl is the same on AGOL as in your flow.

Re: Esri Webhooks for ArcGIS Online - Payload schema for tracking changes in a Hosted Feature Service?

Danielle_Journey — Tue, 23 Feb 2021 22:13:32 GMT

I made the update to the Change Types and re-copy/pasted the Hook Url. Still no test results after making a change to the feature service. I am so stumped on what I am doing wrong!

Re: Esri Webhooks for ArcGIS Online - Payload schema for tracking changes in a Hosted Feature Service?

hgaignard — Mon, 01 Mar 2021 10:08:27 GMT

For the past few days, I have encountered an error on the first module When a HTTP request is received : BadRequest.

This issue seems to come from the JSON schema of the request body predefined during my configuration. @Anonymous User, would Esri have recently modified the request sent by the webhook (e.g Content-Type header)?

I solved this issue by removing the JSON schema of the request body (leave blank) in my first module.

Re: Esri Webhooks for ArcGIS Online - Payload schema for tracking changes in a Hosted Feature Service?

Anonymous User — Tue, 02 Mar 2021 17:43:53 GMT

Hi @hgaignard I was not able to repro this with JSON schema in the HTTP module:

{ "type": "object", "properties": { "$content-type": { "type": "string" }, "$content": { "type": "string" }, "$formdata": { "type": "array", "items": { "type": "object", "properties": { "key": { "type": "string" }, "value": { "type": "string" } }, "required": [ "key", "value" ] } } } }

I tried a couple of different change types with no issues. Are you still seeing the issue?

Thanks,

-Peter

Re: Esri Webhooks for ArcGIS Online - Payload schema for tracking changes in a Hosted Feature Service?

PhilLarkin1 — Tue, 02 Mar 2021 17:51:26 GMT

I just reproduced the error with the schema you provided.

The issue stems from flows which also include connectors like Teams, Outlook, etc.

Re: Esri Webhooks for ArcGIS Online - Payload schema for tracking changes in a Hosted Feature Service?

hgaignard — Wed, 03 Mar 2021 11:04:09 GMT

@PhilLarkin1, I confirm, if I delete my last Outlook module, I no longer have the "BadRequest" error for the first HTTP module with a predefined JSON schema.

To keep the Outlook module, I need to remove the JSON schema from the first HTTP module.

But it worked before...