How to "catch" data from new rows in the child Tab...

raketa · 07-02-2021 10:12 AM

Hello everyone!
I have not asked questions for a long time, but the following task has appeared and I ask for help from the community.

Input data:

There is a TABLE 1 (with a parent entry);
There is TABLE 2 (with child records);
There is BOT 1, which starts from the state (EVENT) of the parent record in TABLE 1. This BOT 1 creates several records in the child TABLE 2 using the Webhook call (Add row);
There is BOT 2, which is triggered by a manual action, changing the state (EVENT) of the parent record in TABLE 1, but only after creating records in the child TABLE 2. BOT 2 creates an email with PDF attachment based on the data in TABLE 1 and TABLE 2.

A task:
How to put all this sequence of actions inside BOT 1?
How to configure the PROCESS in BOT 1 so that it waits for the creation of child records, and then generates an email with an attachment?

Results of my attempts:
All my attempts led either to letters with PDF attachments, inside which there was not enough data from the child records TABLE 2, or using the “Wait for a Condition” step, letters with the necessary data from TABLE 2 were received, but this is again an action from the user side.

Dan_Bahir

Why is Bot 1 using a webhook to create the child records on Table 2? Why not create then with one or more Data Actions ?

Is the Webhook Synchronous ? If so when it returns it the rows should have been added to Table2 and if you have another step to create the PDF after the webhook it should have all the data.

The suggested sequence would be to have a bot that

Creates several records in Table 2 with a data action event
Has an email task with the PDF attachment.

raketa

This is done to iterate over all the selected items in the EnumList (Ref type) column. As far as I understand, you cannot do this with actions (except for creating a group of identical actions with a limited number to create new posts or an action on the user side that creates new posts with recalculating the remainder to start / stop creating a new (next) post).
Or I don’t know something new)?

I tried with both sychronous and asynchronous, got the same result - PDF without child records.

Now I tried again to add the creation of an e-mail with PDF attachment to the process.
Here is the PDF result:

raketa

Is the following situation possible with the response after the Webhook call?
In the “Preset” field, you can select only one “Custom” value.
Previously, it was possible to explicitly specify “Add Row”.
Perhaps the process does not expect any data in response to a call, except for “everything is fine, the call is accepted”)?
Therefore, it does not return the id of new records.

Dan_Bahir

If you are iterating over an Enum list can you use the “Run Action On Rows” action to create a loop and then reference an action that adds the built row to Table2.

If you cannot see this data action, it has not rolled out to your user yet. PM your UserId and I will have you added early.

raketa

My ID: 1152015

raketa

Thanks @Dan_Bahir !

Dan_Bahir

That is strange you should be able to select add.

raketa

Dan_Bahir

Added you to the list, unfortunately it will only take affect this coming Wednesday. I am trying to understand why you only have the custom preset showing up.

Dan_Bahir

Found the issue that caused the other presets not to show up, the fix will be deployed on Wednesday as well.

raketa

@Dan_Bahir, thank you! Glad to hear that the issue will be resolved.

Dan_Bahir

Fix has been deployed, in addition you should now see the new data actions.

How to "catch" data from new rows in the child Table, which was not there before the start of the Bot?