Due to data format change the flows are getting failed or diverting to wrong path.

[vivekpathak2025]

Your Workflow URL

https://connect.pabbly.com/workflow/mapping/IjU3NjYwNTY0MDYzNjA0MzU1MjY4NTUzMTUxMzYi_pc

Consent to Access & Modify

I authorize Pabbly Support to log in to my account and make changes to the specified workflow for troubleshooting.

Recently, a new update has been implemented on your side regarding the MySQL – Get Rows action in Pabbly Connect.

Earlier, the Get Rows function was returning data in a single row format. With that structure, our workflow was running perfectly without any issues.

However, after the recent update, the same function is now returning data in an array format instead of a row.

Because of this change:

We had to add an Array Formatter step in between to handle the new structure.

After adding the Array Formatter, the workflow is not behaving correctly.

Inside the Router, we have created two routes.

Now the workflow is getting completed in the first route itself, and the second route is not executing as expected.

Earlier, when the response was in row format, both routes were working properly based on conditions.

It seems that due to the structural change (row → array), the router conditions are not evaluating correctly.

We request you to please:

Analyze the workflow from your end

Check whether this issue is due to the recent update

Suggest the correct handling method for the array response

Guide us on how to make the router evaluate conditions properly

For your reference, here is the workflow URL:

Pabbly

connect.pabbly.com

If there is any type of change in future which you are doing please let us know in one week prior at least so that we can manage our flows accordingly. this time this change caused a big loss to us please reply as soon as possible and let us know the solution for this.
Account Id: [email protected]

 

[Preeti Paryani]

Hi @vivekpathak2025,

Thank you for sharing the workflow details.

Upon checking the workflow, it appears that the MySQL – Get Rows action is currently capturing the response in Advanced format, which is why the data is being returned in an array structure.

To resolve this, please try the following steps:

1. Clear your browser cache.
2. Open the MySQL – Get Rows action in your workflow.
3. Under Response Format, select Simple instead of Advanced.
4. Click Save & Send Test Request, then save the step.

This should return the response in the earlier row format, allowing your router conditions to work as expected.

Please try this and let us know if the issue persists.