Select to view content in your preferred language

Update hosted feature service using Integromat (Make)/webhooks

551
2
05-16-2023 02:34 PM
Labels (1)
NataliyaLys
Occasional Contributor III

Hello,

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

Here are details of my scenario: 

  1. I have a hosted feature service with a related table 
  2. The data is secured, so I am getting a token
  3. The end goal is to update some fields in the related table
  4. 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? 

NataliyaLys_0-1684272036319.png

NataliyaLys_1-1684272334798.png

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:

NataliyaLys_2-1684272583763.png

 

I would very much appreciate any suggestions/ideas. 

Thank you,

Nataliya

 

 

 

 

 

0 Kudos
2 Replies
jcarlson
MVP Esteemed Contributor

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.

- Josh Carlson
Kendall County GIS
0 Kudos
NataliyaLys
Occasional Contributor III

@jcarlson 

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

NataliyaLys_0-1684329292354.png

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

NataliyaLys_1-1684330119334.png

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

NataliyaLys_2-1684330313139.png

NataliyaLys_3-1684330415352.png

This is what I have for my POST configuration

NataliyaLys_4-1684331840853.png

 

Thank you,

 

 

 

0 Kudos