Update hosted feature service using Integromat (Make)/webhooks
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
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,
