Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Bot not triggering on change

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].

gcor71_0-1706099573797.png

gcor71_1-1706099598377.png

gcor71_2-1706100291116.png

 

 

0 4 460
4 REPLIES 4
Top Labels in this Space