Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Issue in automation Collect Data / steps.n.success fails #13460

Open
esellier opened this issue Apr 11, 2024 · 3 comments
Open

Issue in automation Collect Data / steps.n.success fails #13460

esellier opened this issue Apr 11, 2024 · 3 comments
Labels
bb-automations Budibase Automations related work bug Something isn't working firestorm Data/Infra/Revenue Team

Comments

@esellier
Copy link

The Collect Data "fails" when trying to get the result of a previous step.
The handle bar is ok I think {{ steps.6.success }}, and it runs fine in the builder when I test the automation, but fails in published app. All other previous steps before 6 are also OK.

I serialiized steps in backend log.
And there are two null values between step 5 and 6. So the steps.6 resolves to null.
So far I guess it is probably because in step 4 there is Delete Row, inside a loop, but if the loop has no iteration (empty array) as the previous query in Step 4 returns [], so there maybe null values for the loop and another null for the delete?? (just a guess...).

see: https://discord.com/channels/733030666647765003/1227913272838328320

Screenshot of Google Chrome at 11 Apr 2024 at 14_32_56

Serialization of steps :
[ {}, {
"success": true,
"result": true,
"refValue": 14,
"comparisonValue": 0
}, {
"success": true,
"result": true,
"refValue": 83080682,
"comparisonValue": 1
}, {
"success": true,
"result": true,
"refValue": "[{"_id":"ro_ta_07c7df53dc90433c99fa16cb6d7f98fc_f868970973fc49c7a168566e4ceedc72","primaryDisplay":"83080682"}]",
"comparisonValue": "0"
}, {
"rows": [],
"success": true
}, null, null, {
"row": {
"tableId": "ta_81016989d5da4fe792db0b92e7e98d88",
...
"_id": "ro_ta_81016989d5da4fe792db0b92e7e98d88_e3f373f6a2734ca6933ba201e455b8cb"
},
"response": {
"tableId": "ta_81016989d5da4fe792db0b92e7e98d88",
...
},
"id": "ro_ta_81016989d5da4fe792db0b92e7e98d88_e3f373f6a2734ca6933ba201e455b8cb",
"revision": "1-bcd7f204821ef1a8f24a49f265c7efc9",
"success": true
} ];

@esellier esellier added the bug Something isn't working label Apr 11, 2024
Copy link

linear bot commented Apr 11, 2024

@mike12345567
Copy link
Collaborator

Hi @esellier - this is likely due to the empty loop.

Have you tried renaming your steps and referencing them directly using the new step format, {{ stepName.property }}

@esellier
Copy link
Author

esellier commented Apr 11, 2024

Tried to rename steps.
The steps after the loop do not appear in the Bindings list (see screenshot).
And step 5 does not have the correct name in list.

Screenshot of Google Chrome at 11 Apr 2024 at 14_39_40
Screenshot of Google Chrome at 11 Apr 2024 at 14_38_51

@linear linear bot added firestorm Data/Infra/Revenue Team bb-automations Budibase Automations related work labels Apr 11, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bb-automations Budibase Automations related work bug Something isn't working firestorm Data/Infra/Revenue Team
Projects
None yet
Development

No branches or pull requests

2 participants