Your guidance please. After a frustrating few hours I admit defeat and turn to the community for help.
Table 1 logs a request and writes the request to Table 2.
Table 2 automatically sends the request to an external API and receives the response.
Table 2 should automatically pass the response (Pass / Fail) back to the requesting row in Table 1.
I am trying to achieve this with Bots/automations.
Everything works well EXCEPT I can not get Table 2 to pass the API response back to Table 1.
Both tables have [member_id] as a common key.
I hit a wall when trying to trigger passing the response back from Table 2 to Table 1. My BOT doesn't trigger on the API response update in Table 2. The Audit Log doesn't show any activity.
Advice welcome on either fixing the current approach, or adopting a different way of handling this.
In the screenshots:
adminTask is Table 2, API response is in [executionStatus].
OSM_DATA_TRACKER is Table 1, request status is in [jtaAction_status].
User | Count |
---|---|
36 | |
8 | |
3 | |
2 | |
2 |