Power Automate - cannot update attributes based on Intesect relationship

334
0
03-08-2021 10:41 PM
KerryKang
Occasional Contributor II

Hello all, 

I am trying to use Power Automate to make pulldata Javascript function work for offline collection by setting up an HTTP request.

In my survey, the x, y values of geo-point are passed to the js function that gets the attribute values of the overlapping polygon. 

For offline use, this is the url that I used in the HTTP action to search the intersect polygon, and get its attributes. (x and y are from the survey, token is from another HTTP action requesting token).

https://services1.arcgis.com/.../FeatureServer/0/query?f=json&geometry=x,y&geometryType=esriGeometryPoint&inSR=4326&spatialRel=esriSpatialRelIntersects&outFields=*&returnGeometry=false&returnCount=1&token=token

In Parse Json output, I see the results (overlapping polygon's attributes) that I expected, but I eventually got the error message in the HTTP input to push the data to the feature layer but nothing happened.

 

Parse Json output

KerryKang_0-1615271386840.png

 

HTTP Input. The values I want to get are empty, and show 400 error message.

==> I don't see the error anymore but the attributes are not updated although it says 'success'.

 

KerryKang_0-1615272940657.png

 

{"error":{"code":400,"message":"Cannot perform operation. Invalid operation parameters.","details":["'features' parameter is invalid","Invalid JSON primitive: ."]}}

 I just added email notification after Parse Json to check if I can get the values directly in the email body, and it seems empty.

Did I miss any steps after Parse Json? Maybe that's why I see nothing in HTTP input?

KerryKang_0-1615273957108.png

 

 

@IsmaelChivite , @JamesTedrick Is there any limitation in Power Automate to get the feature service query result in Json?  I used the almost the same approach in Integromat and it worked out.

Thank you.

Kerry

0 Kudos
0 Replies