Conditionnal Router not working when value doesn't exist

[hugohamelcom]

Hi,
I am trying to check if a customer exist in Quickbooks to then decide which "route" to take.

When the customer doesn't exist Quickbooks returns only the Time.

And I am trying to assign a field to check if the field exist or not.

First I get the data for an existing customer, then I set the field and make the filter for it to be true when it doesn't exist.

Then, I get the data for a customer that doesn't exist.

The issue is that when the customer doesn't exist, the router still indicates as FALSE when the field doesn't exist.

How can I solve this issue?

Thansks!

 

[ArshilAhmad]

Hi @hugohamelcom,

Please enter the email address which already exists in your Quickbooks Online account and use that response as Filter condition of both routes.

 

[hugohamelcom]

That's what I did, but then when I test with previous data (in the workflow history) it still doesn't go through.

 

[Fagun Shah]

That's what I did, but then when I test with previous data (in the workflow history) it still doesn't go through.
View attachment 31181
View attachment 31182

I think @ArshilAhmad meant that you need to enter the email address that already exists in QBO while setting up the workflow and then use something like Customer ID exist or doesn't exist in filter conditions.

 

[hugohamelcom]

Yes, that's exactly what I did. Then, when I re-executed the entire flow with it configured correctly, for some reason, it returned false when it should have returned true.

Could it be a logic problem in the backend of Pabbly, @Supreme ? Or is there something wrong that I did?

 

[ArshilAhmad]

Please enter an existing customer email address in "Find Customer" action step.

 

[hugohamelcom]

Yes, I already did all of that @ArshilAhmad. Here's the explanatory video: https://www.loom.com/share/7c155910e7b24247990de6940c7a9421?sid=e751d7bf-c918-48c3-8200-b3d2b189ff81 (Sorry, the audio is not that good)

 

[Fagun Shah]

Yes, I already did all of that @ArshilAhmad. Here's the explanatory video: https://www.loom.com/share/7c155910e7b24247990de6940c7a9421?sid=e751d7bf-c918-48c3-8200-b3d2b189ff81 (Sorry, the audio is not that good)

In Don't Exist router you mapped value in condition from 2nd step instead of 3rd step.

 

[hugohamelcom]

I had linked it to #3 but you're right, when I recorded the video, I linked it to #2.
Just relinked it to #3.

Yet, when I re-executed the entire workflow after fixing my mistake when I recorded the video, it still doesn't go through.

I am really confused of why it still return false...

 

[Fagun Shah]

I had linked it to #3 but you're right, when I recorded the video, I linked it to #2.
Just relinked it to #3.
View attachment 31253


Yet, when I re-executed the entire workflow after fixing my mistake when I recorded the video, it still doesn't go through.View attachment 31254

I am really confused of why it still return false...

Can we do a quick zoom call to check this in detail? DM on FB messenger.

 

[Chandan]

@hugohamelcom
This may solve your problem:

Skip missing map sources with alternate values.

The problem I have a workflow where step #2 sometimes returns errors due to invalid inputs. That leads to failures in the subsequent steps because of absence of a required key (map source, which is `Result 0` in my case). What I expect in a subsequent step Use `Result 0` from a successful...

forum.pabbly.com

 

[hugohamelcom]

@ArshilAhmad Just had a call with @Fagun Shah and he can confirm that there's an issue with the workflow itself.

We tested another workflow, with similar logic and it worked: https://connect.pabbly.com/workflow/mapping/IjU3NjUwNTZmMDYzNTA0MzY1MjY0NTUzMjUxMzci_pc

Yet, in the workflow I was referring to, the same logic doesn't work: https://connect.pabbly.com/workflow/mapping/IjU3NjUwNTZjMDYzZTA0MzM1MjZkNTUzNzUxMzUi_pc

It seems to be an issue on Pabbly's side, but I'm wondering if there's anything I could do to solve the issue faster?

Thanks!

 

[ArshilAhmad]

Please allow us some time to look into this concern. We will get back to you with an update soon.

 

[hugohamelcom]

Perfect, thank you!

 

[hugohamelcom]

@ArshilAhmad Is the any update or some progress regarding this issue? Thanks

 

[ArshilAhmad]

Our technical team is currently investigating your concern. I kindly request that you allow us some additional time. We will provide you with an update as soon as possible

 

[hugohamelcom]

@ArshilAhmad Should simply create a new workflow instead? Would it be more simple and faster? Or have you found the issue?

 

[ArshilAhmad]

Our technical team is still working on finding a solution for your issue. While you can try creating a new workflow, please note that since the issue is related to the router condition, I am not sure if that will resolve your problem.

 

[hugohamelcom]

@ArshilAhmad I cloned the workflow and it is now working. It seems to have been related to the workflow itself.

 

[ArshilAhmad]

Thank you for the update. I am glad your new workflow is functioning correctly.