Latest Contributions by COSPNWGuy

‎07-16-2020

For disaster or emergency management situations, personnel need to be able to know where UAV's are flying in real time. Staff many times are manning a EOC and viewing webmaps\dashboards up on a screen and need as much situational awareness as possible. Also, being able to track and display a UAV's position is also helpful in the field to equip visual observers with additional intel on the drone's position on a mobile device. Obviously, it would be nice for not only drone position to be "beamed back" to headquarters, but the actual video or pictures being captured too. This obviously requires strong internet connection (and more than likely video compression), but if present, is completely possible in this day and age.

‎07-16-2020

Organizations need to be able to readily and easily answer the questions who, what, where, when, and why for each UAV flight. The best way to accomplish this is for flight history to be graphically displayed. This makes compliance reporting, audits, public information requests, legal inquiries, etc easy to respond to (And maybe even add the ability to export this out to PDF, for the lawyers ).

‎07-15-2020

It just makes natural sense that Workflow Manager should be able to send out webhooks for integration into other systems as well as receive webhooks so GIS workflows can be triggered. Many workflows spill over into other systems, and webhooks is an ideal and uncomplicated way to address this continuity challenge without having to implement a full-on integration project. The news during UC 2020 that Workflow Manager will be becoming all services based makes this an ideal platform for webhook integration.

‎07-14-2020

Allowing AGO and Enterprise to also receive webhooks (in addition to generating), greatly enhances the ability to fully build out automation solutions and allows much easier integrations. The GIS when receiving a webhook could trigger a GP tasks or a notebook as an example. This overall could be a more accessible way to customise and complete advanced integration or workflows without having to have full developer skills or need to understand the APIs. Here is just one workflow example (but the sky's the limit!). An organization has a call-center system. It is not a geo-enabled database, but call takers do take in the caller's address. It could be configured, that when this new record is created to send the caller's address in the payload of the webhook back to the GIS. Upon receipt, the GIS could geocode the address, then create a open work order in Workforce for the organization to follow up. Upon following up, the field worker completes the work order in Workforce which then triggers a webhook out of the GIS back to the call-center system so that the record there can show action was completed. The key to this workflow example is that it must be bi-directional. Being able to integrate systems together via webhooks is far more efficient and simpler than trying to programatically develop a interface between systems and does not necessarily require developer skills (but a power user probably could).

‎07-14-2020

Allowing AGO and Enterprise to also receive webhooks (in addition to generating), greatly enhances the ability to fully build out automation solutions and allows much easier integrations. The GIS when receiving a webhook could trigger a GP tasks or a notebook as an example. This overall could be a more accessible way to customise and complete advanced integration or workflows without having to have full developer skills or need to understand the APIs. Here is just one workflow example (but the sky's the limit!). An organization has a call-center system. It is not a geo-enabled database, but call takers do take in the caller's address. It could be configured, that when this new record is created to send the caller's address in the payload of the webhook back to the GIS. Upon receipt, the GIS could geocode the address, then create a open work order in Workforce for the organization to follow up. Upon following up, the field worker completes the work order in Workforce which then triggers a webhook out of the GIS back to the call-center system so that the record there can show action was completed. The key to this workflow example is that it must be bi-directional. Being able to integrate systems together via webhooks is far more efficient and simpler than trying to programatically develop a interface between systems and does not necessarily require developer skills (but a power user probably could).

‎02-27-2020

Is anyone aware of any tools\apps\techniques to report on how data\maps\apps are interconnected for a ago org or portal? What I mean is, can I easily find out what maps consume a layer I own? What apps use maps I own, etc? This would be really important Intel in understanding the repercussions say if an item were deleted.

‎02-14-2020

Hi David Wright. I'm sure ESRI is right, but difficult things are worth doing, and if there is will, there is a way. Geoprocessing tasks might be a good fit for Azure functions or AWS Lambda as they are designed for incredibly variable loads and are trigger based serverless compute instances.

‎02-13-2020

It would be nice to be able to publish geoprocessing services to ArcGIS Online in the same way you can publish them to Server. Not everyone has a on-premise solution, but many do have access to AGO. Also, depending on the situation, utilizing the cloud to host these geoprocessing services can be preferable to an on-premise solution. Hosted geoprocessing services could use credits in the same way other published content does. I'm surprised with how far AGO has come this isn't a capability yet.

‎12-06-2019

Hi Pavel, Not sure I am quite following. Are you asking how to export the Flow as a XML, then have Postman run it?

‎07-12-2019

All, I finally got this working. This link ended up giving me the clue on how to reformat the request. So for oauth2, here is how you would format your MS Flow HTTP request:

‎07-12-2019

Hi Paul Sweeney, That requires a little work with the smartsheets api first. Use the Get Row api for one of your smartsheets records. The response will contain an array of your data and it will identify the "columnID". Document the columnIDs that you will want to push back to AGO. You will have to figure out how you want to trigger your flow when a new smartsheet row is added. You can create a webhook in Smartsheets than can send a response to your flow, however I didn't really have the patience for this. It's probably cleaner, but will take longer to properly set up. I found it easier to just have Smartsheets send a email to my outlook account (making sure the email contained my feature GUID [make sure you pass the GUID and ObjectID of you feature from Survey123/GIS into smartsheets]). My flow triggers when I receive this email. Flow parses through the text body of the email to find the GUID. Flow then searches for the smartsheet row with this GUID (the row I was just notified about) using the search api. Then create an array variable that you can store your smartsheet data in. Next, loop (apply to each) through the json items, testing each (use a switch) with the ColumnIds of interest and store in your array. Be sure you pay attention to the order of your data in your array. You then create single variables of your data by composing expressions specifying the data location in the array [0,1,2,3,etc]. Now each data you extracted from the array is segmented individually and you can then plop them into the HTTP request to the ArcGIS REST api. Hope this is helpful.

‎07-12-2019

Hi Paul Sweeney, I expect it is because when Flow autogenerated the schema when you uploaded a sample json, it takes a guess at the type of data (many times erroneously). All you need to do in your schema is delete the type or change it to integer.

‎07-05-2019

How do I properly format my HTTP Post in MS Flow to acquire a token? The following returns "client_id not specified", but I do include it....

‎06-26-2019

All, I finally got this working and I want to share the solution and some things I have learned about MS Flow and testing the ArcGIS REST API using Postman. Maybe you seasoned programmers know this stuff, but I sure didn't. Ultimately, and most importantly it is possible to use the MS Flow HTTP trigger with the ArcGIS REST API to edit features, but it is a little tricky. The most annoying thing I found (and I'm not sure if MS Flow is at fault or the ArcGIS REST API) is almost always the response from the API will be 200 (Success), even though it is not successful. Below is a malformed request, but you can see we get a 200 back. It should respond back as a 400: For awhile, I thought that my Flow was working properly, until I realized my features were not updating. Lesson learned, do not trust or rely upon feedback from MS flow. This little green box is deceptive. I also learned some valuable info about Postman. I assumed that pasting in the raw sent request from the Postman Console into the body of the Flow HTTP trigger would work. (Because hey, the request works great in Postman - everything updated as it should). But even in "raw" mode, the console doesn't actually show the true request that was sent to the API. However, the "Generate Code Snippet" tool in HTTP mode does. This ultimately helped me figure out what to paste into the header and body portion of Flow. Ultimately, pictured below is how you would format your header and body (configure your token for authentication under the "Show advanced options" at the bottom) to successfully POST to a feature using the ArcGIS REST API to update attribute features. The main trick is defining your boundary (unique string of characters which separates your different forms in the body) in the header (in my case I just used what Postman auto-generated, but it could be anything). I hope this saves you some time if you want to use MS Flow and the ArcGIS Rest API.

‎06-24-2019

I have set up a Microsoft flow to trigger when rows in my Smartsheet are updated. I followed this tutorial on how to update values using the ArcGIS REST API. Everything works as it should using Postman. I noticed however that the ArcGIS Rest API is expecting multipart/form-data including key value pairs for f:json, a valid token, and then the updates. Postman handles this natively by selecting the form/data option for the body and automatically creates boundaries. MS flow apparently does not handle multipart/form-data natively. How do I structure my body to pass a valid POST request to the API to update my feature service? Screenshot of MS Flow HTTP Post below. Also below is the successful POST from Postman using the exact same data. I should note that this feature service is shared with editing enabled, which explains my missing token key value pair. From Postman Console. This successfully posts: Request Header: User-Agent:"PostmanRuntime/7.15.0" Accept:"*/*" Cache-Control:"no-cache" Postman-Token:"8988b891-ad8f-4e9f-8be0-965ad2711ecc" Host:"services.arcgis.com" accept-encoding:"gzip, deflate" content-type:"multipart/form-data; boundary=--------------------------113767685070943500397041" content-length:467 Connection:"keep-alive" Request Body: f:"json" updates:"[ { "attributes" : { "objectId": 3, "MissionDate" : "2019-06-27T07:00:00.0000000", "MissionName" : "Waste Transfer Facility Promo Shots", "Status" : "pending_review" } } ]"‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Online Status	Offline
Date Last Visited	Wednesday

My Ideas

Latest Contributions by COSPNWGuy

Site Scan - Display UAV position (and content) on Map in Real Time

Site Scan - Flight History Report

Workflow Manager - Send and Receive Webhooks

Allow AGO and Enterprise to be a Webhook Receiver

Allow AGO and Enterprise to be a Webhook Receiver

AGO tool to report on data\map\app interconnections?

Re: Publish Geoprocessing Services to ArcGIS Online

Publish Geoprocessing Services to ArcGIS Online

Re: MS Flow HTTP POST to update Feature Service??

Re: Request Token with MS Flow?

Re: MS Flow HTTP POST to update Feature Service??

Re: ArcGIS Rest API – Webhooks - Microsoft flow Survey123

Request Token with MS Flow?

Re: MS Flow HTTP POST to update Feature Service??

MS Flow HTTP POST to update Feature Service??

Best Workflow for Importing HEC-RAS Results into ....

Oriented imagery "Widget" in Site Scan

Re: Optimal Image Collection Settings to Create Di...

2025 Virtual UC Slide Availability?

Re: Prepare your data for the National Spatial Ref...