Hello
I am working on a Knack app that involves two connected objects, “Orders” & “Customers.” I would like to automatically update a field in the “Customers” object whenever a new “Order” is created specifically by pulling data from an external API (like updating loyalty points from a third-party system).
I have tried using Knack’s native Zapier integration but it doesn’t offer the level of control I need for conditional logic & connected field updates.
What I am aiming for is something like; when a new order is submitted; my external script (hosted via Integromat/Make or custom webhook) should fetch current loyalty points from a third-party API & push that value back into the connected “Customer” record in Knack.
I am able to POST and GET to Knack using the API; but updating connected records from an external trigger seems tricky.
Does anyone have a recommended structure for this kind of workflow / best practices for securely authenticating & updating these fields?
I have gone through the Knack API docs and played around with PUT
requests on record IDs, but I am unsure how to traverse and update a connected object (Customer) using the Order’s record_id
alone. Checked Connecting Records Together related to this and found it quite informative. I also came across discussions on what is Power Apps and wondered if it could be used similarly to update Knack records through external workflows.
Any guidance or example scripts would be much appreciated!
Thank you !!