Webhook Not Pulling Data from Multiple Tables (REQUEST & CUSTOMERCALL)
Issue:
I have a webhook that fires when a service request is deleted, and I'm trying to capture all related fields. The webhook correctly pulls data from the azteca.REQUEST table, but it does not populate fields from the azteca.CUSTOMERCALL table.
Setup Details:
- The webhook triggers on service request deletion.
- It successfully retrieves data from azteca.REQUEST.
- Fields related to customer call details (azteca.CUSTOMERCALL) output with the tag, not the value i was expecting, example: "{{CallerType}}" instead of "Busines".
Questions:
- Does the webhook support pulling data from multiple related tables?
- If so, how do I need to join the tables in a specific way or configure something in Cityworks to ensure both sets of data are available?
- Are there limitations when using dynamic tags from multiple tables in a webhook?
Any guidance on resolving this would be greatly appreciated!
