topic Re: Accessing webhook payload using Power Automate in ArcGIS Online Questions

Accessing webhook payload using Power Automate

JulieK — Fri, 30 Jul 2021 14:48:51 GMT

Anybody successfully able to access the WebHooks payload in Power Automate?

With all the help from existing threads on Geonet and @PhilLarkin1, I have the resultUrl with the .json file. However, I am unable to access the feature attributes, instead it moves the data to https://arcgisazureprod.blob.core.windows.net/replicafiles and it doesn't have public access from PA.

How do I go about it? Any thoughts anybody...thanks so much. - Julie

Re: Accessing webhook payload using Power Automate

PhilLarkin1 — Fri, 30 Jul 2021 15:14:33 GMT

Can you share the azure URL you use to get the edits? I'm assuming you make a GET request to retrieve the JSON at the azure URL.

Re: Accessing webhook payload using Power Automate

JulieK — Fri, 30 Jul 2021 19:49:57 GMT

Hey Phil,

The url itself doesnt have public access. Below is how it looks: https://arcgisazureprod.blob.core.windows.net/replicafiles/

With your flow, how do you access the data after the redirect? As you suggested, I added 'Do Until' so the flow runs after the error. I am able to extract the above url but unable to access the json. I want to access the edited attributes, make a few calculations and send it back to the same Feature service. Long way to go 🙂

Thanks and you have a great weekend!!

Re: Accessing webhook payload using Power Automate

PhilLarkin1 — Fri, 30 Jul 2021 20:17:23 GMT

The url should look something like below. You might want to replicate the call to /changeFiles in Postman or in the broswer at the REST endpoint. If you can't get the file information to come back you might need to log a support request with ESRI.

https://arcgisazureprod1.blob.core.windows.net/replicafiles/0cf6418sss4b4461b166b47d8b0b07c4.json?se=2021-07-30T19%3A57%3A58Z&sr=b&sp=r&sig=iTpgmTC4JwVzX%2F%2FG3s2343yGfWviUB7QrLjGR%2FfNnKZL23%3D

I grab the url from the header of the reply. You can turn around and make a GET request to the full url.

The content returned will need to be decoded as it it sent in in base64:

Cheers!

Re: Accessing webhook payload using Power Automate

JulieK — Mon, 02 Aug 2021 17:53:05 GMT

Hey Phil,

That actually worked for me. I have access to edited attribute values now. Grateful to you for your time and effort, I would have never guessed this workflow. Thanks so much.