topic Update hosted feature service using Integromat (Make)/webhooks in ArcGIS Online Questions

Update hosted feature service using Integromat (Make)/webhooks

NataliyaLys — Tue, 16 May 2023 21:34:55 GMT

Hello,

I am building an Integromat (Make) scenario, and cannot get it to work.

Here are details of my scenario:

I have a hosted feature service with a related table
The data is secured, so I am getting a token
The end goal is to update some fields in the related table
So every time a new related record is added to the feature, I would like to grab some attribute values and from the parent feature, and add those attribute values to the related (child) record.

The first issue I am running into is that I cannot seem to query the 'parent feature' in the HTTP 'make a request' module. I cannot get the 'where' query to work, unless I hard code the value. It seems like I am missing something simple over here, but cannot figure out what?

If I hard code the value for 'GlobalID' then the 'where' query in 'Make a request' module works as expected. However, when I try to update feature using POST method, I am getting the following error:

I would very much appreciate any suggestions/ideas.

Thank you,

Nataliya

Re: Update hosted feature service using Integromat (Make)/webhooks

jcarlson — Wed, 17 May 2023 02:48:34 GMT

Can you see the value represented by the ID that Make is trying to supply to the where parameter? Maybe it's formatting it differently in some way?

What's your POST look like in the scenario? Can you share how that portion is configured? We have a few scenarios that edit features using POST requests, and they work fine.

Re: Update hosted feature service using Integromat (Make)/webhooks

NataliyaLys — Wed, 17 May 2023 14:00:31 GMT

@jcarlson

If I hard code the Globalid this is what query looks like, and the output returns just that record, as expected

If my 'where' statement is 1=1, it return all records, as expected

But if I add a variable for my 'where' statement, GlobalId = 'global id from related table' (I tried double quotes, single quotes, no quote), the query shows nothing for global id, and I am getting error in output

This is what I have for my POST configuration

Thank you,

Re: Update hosted feature service using Integromat (Make)/webhooks

Andrew-Bowne — Thu, 27 Jun 2024 19:16:57 GMT

Were you ever able to get this figured out? I'm running into the same issue where Make (Integromat) doesn't seem to recognize my WHERE clause.