handling null values

[virsingh77]

Your Workflow URL

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

Your Task History ID

IjU3NjcwNTZhMDYzNzA0MzU1MjZjNTUzMCI_3D_pc#

Consent to Access & Modify

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

I am facing a problem in using null values in my workflow. I have created a step no 3 in the workflow to check if a customer has ordered for a second product at the time of placing the order. The field I have used is 'items 1 id' which is only available if there is a second item in the order. If there is no second item, this field does not appear in the response received by pabbly and the result of set no 3 should be '0'. However, insted of returning '0' step no 3 returns the value from the last succesfully run , i.e, 'multiple'
So my requirement is that if there is no second order, the result of step 3 should be '0' and if there is a second order the result should be 'multiple'
How do I solve this?

 

[Hrishabh.pabbly]

Hi @virsingh77 ,

Thank you for sharing the webhook response format.

Since your data is coming in a flattened structure (e.g., Items 0 Id, Items 1 Id, etc.), the correct way to handle this is by using a Router instead of directly checking the field in a Set step.

Please follow these steps:

1. Add a Router after the webhook trigger.
2. Create Path 1 with the condition:
   Items 1 Id → Exists
   → In this path, set the value as "multiple".
3. Keep the Default Path (no condition).
   → In this path, set the value as "0".

This way:

• If a second product exists, it will return "multiple".
• If there is only one product and Items 1 Id is not present, it will correctly return "0".

This approach prevents from reusing the previous execution value.

 

[virsingh77]

But if Items 1 Id does not exist for an order, in path 1 the 'select label' field resets to blank. Next order if Items 1 id is there, the filter doesn't work because the 'select label' field was rest to blank in the previous order.
My requirement is:
if the customer orders for more than 1 product i need to tag it as 'multiple'
the way to identify if the customer has placed order for more than 1 product is if the field 'Items 1 Id' gets created
if the field 'Items 1 Id' is not created that means its a single product order
How do I accomplish this?

My workflow url is https://connect.pabbly.com/workflow/mapping/IjU3NjcwNTZhMDYzNzA0MzU1MjZjNTUzMCI_3D_pc

 

[Preeti Paryani]

Hi @virsingh77,

You can handle this by using the Filter with the “Exists” condition, as shown in the screenshot.

Map Items 1 Id in the Select Label field and set the Filter Type → Exists. If this key exists in the response, it means the order contains multiple products. If it does not exist, it means it is a single product order.

You do not need to worry about the label appearing blank in the builder. The filter will still check whether the key exists in the incoming response.

So:

• Items 1 Id exists → Multiple product order
• Items 1 Id does not exist → Single product order

You can test this once, and it should work as expected.

 

[virsingh77]

The label does appear blank in the builder and the filter will still check whether the key exists in the incoming response. Have attached the screenshot to show thatthe label goes blank if in a previous request Items 1 Id was not populated

 

[virsingh77]

pls check task url https://connect.pabbly.com/task/his...=IjU3NjcwNTZmMDYzNzA0MzU1MjZmNTUzMDUxMzUi_pc#
This task has failed exactly because the label field has gone blank
The worklow url is https://connect.pabbly.com/workflow/mapping/IjU3NjcwNTZmMDYzNzA0MzU1MjZmNTUzMDUxMzUi_pc

 

[Preeti Paryani]

Hey @virsingh77,

I have recorded a detailed screencast explaining the working of the filter. Please refer to it for understanding the working. If you still face any issues, please let us know.

Ecwid to Sheets | Pabbly Connect

www.awesomescreenshot.com

 

[virsingh77]

The problem is once i receive a single product order, the key for the multi product order disappears and the filter does not work properly work for a multi product order. and going ahead for any multi product order the filter gives the wrong output till the time i do not go an manually update the key again. also pls ignore the errors caused by the time conversion steps, I'm not referring to them. they do not affect how the filter performs.
So to recap the issue:
1. I update the key for a multi product order using 'Items Id 1' field, it works fine
2. The moment there is a single product order, the key goes blank as now the field 'Items Id 1' doesn't exist
3. And going ahead if i receive a multi product order again, the filter will not identify it since the key has disappeared.

Similary, once the key goes blank the filter for single product order also stops working. So the problem is that the key disappears

 

[virsingh77]

There is also another issue. I have made another workflow as a fallback to capture orders that are not captured by the workflow 'Ecwid to Sheets', this worflow is called 'Clone- Ecwid to sheets' (url: https://connect.pabbly.com/workflow/mapping/IjU3NjcwNTZmMDYzNzA0MzE1MjZjNTUzMTUxMzIi_pc).
In the cloned workflow I have removed the router to filter single and multi product orders.
In that workflow an order with id ZC23X has been captured (Task History ID - IjU3NjUwNTY0MDYzMDA0MzY1MjZkNTUzMzUxMzA1MTYzNTQzNDBmMzAi_pc)
Wheras, in the original worflow, the same order has been missed. Why is that?

 

[ArshilAhmad]

The problem is once i receive a single product order, the key for the multi product order disappears and the filter does not work properly work for a multi product order. and going ahead for any multi product order the filter gives the wrong output till the time i do not go an manually update the key again. also pls ignore the errors caused by the time conversion steps, I'm not referring to them. they do not affect how the filter performs.
So to recap the issue:
1. I update the key for a multi product order using 'Items Id 1' field, it works fine
2. The moment there is a single product order, the key goes blank as now the field 'Items Id 1' doesn't exist
3. And going ahead if i receive a multi product order again, the filter will not identify it since the key has disappeared.

Similary, once the key goes blank the filter for single product order also stops working. So the problem is that the key disappears

As mentioned previously, it does not matter if the keys appear blank in the setup. During workflow execution, the filter conditions are recognized correctly.
For example, in this task, when a multi-product item was captured in your Ecwid trigger step, the Multiple Productsroute executed correctly, even though the keys currently appear blank in your workflow setup.
Task History ID - IjU3NjUwNTY0MDYzMDA0MzY1MjY4NTUzNjUxMzM1MTZhNTQzNzBmMzci_pc

In this task, a single-item order was captured in your trigger step, so the Single Product route was executed.

Task History ID - IjU3NjUwNTY0MDYzMDA0MzY1MjY4NTUzYzUxMzI1MTY0NTQzNDBmMzUi_pc

====================================================

pls check task url https://connect.pabbly.com/task/his...=IjU3NjcwNTZmMDYzNzA0MzU1MjZmNTUzMDUxMzUi_pc#
This task has failed exactly because the label field has gone blank
The worklow url is https://connect.pabbly.com/workflow/mapping/IjU3NjcwNTZmMDYzNzA0MzU1MjZmNTUzMDUxMzUi_pc

If you notice a specific task where the conditions were not met, please share the Task History ID of that particular task. In your response, you shared the URL of the complete Task History instead of the specific task.

Thanks & Regards,
Arshil Ahmad
Customer Support Associate
Pabbly.com
Rate your support

 

[ArshilAhmad]

There is also another issue. I have made another workflow as a fallback to capture orders that are not captured by the workflow 'Ecwid to Sheets', this worflow is called 'Clone- Ecwid to sheets' (url: https://connect.pabbly.com/workflow/mapping/IjU3NjcwNTZmMDYzNzA0MzE1MjZjNTUzMTUxMzIi_pc).
In the cloned workflow I have removed the router to filter single and multi product orders.
In that workflow an order with id ZC23X has been captured (Task History ID - IjU3NjUwNTY0MDYzMDA0MzY1MjZkNTUzMzUxMzA1MTYzNTQzNDBmMzAi_pc)
Wheras, in the original worflow, the same order has been missed. Why is that?

This order has triggered the original workflow as well.
Task History ID - IjU3NjUwNTY0MDYzMDA0MzY1MjZkNTUzMDUxM2I1MTY3NTQzODBmMzAi_pc

Thanks & Regards,
Arshil Ahmad
Customer Support Associate
Pabbly.com
Rate your support

 

[virsingh77]

This order has triggered the original workflow as well.
Task History ID - IjU3NjUwNTY0MDYzMDA0MzY1MjZkNTUzMDUxM2I1MTY3NTQzODBmMzAi_pc

View attachment 65686

Thanks & Regards,
Arshil Ahmad
Customer Support Associate
Pabbly.com
Rate your support

Ok I guess there was a gap between the execution of both workflows

 

[virsingh77]

Even though task ids IjU3NjUwNTY0MDYzMDA0MzY1MjZiNTUzYzUxMzE1MTYyNTQzMTBmMzci_pc and IjU3NjUwNTY0MDYzMDA0MzY1MjZiNTUzZDUxMzU1MTYzNTQzNTBmMzYi_pc are from different workflows, they belong to the same Ecwid order id FRIAB and have been executed at very different times- 00:27:48 vs 00:43:04
What is the reason for the same, because the trigger for a new Ecwid is checked every 10 minutes but the gap between both tasks is more than 15 minutes

 

[ArshilAhmad]

Even though task ids IjU3NjUwNTY0MDYzMDA0MzY1MjZiNTUzYzUxMzE1MTYyNTQzMTBmMzci_pc and IjU3NjUwNTY0MDYzMDA0MzY1MjZiNTUzZDUxMzU1MTYzNTQzNTBmMzYi_pc are from different workflows, they belong to the same Ecwid order id FRIAB and have been executed at very different times- 00:27:48 vs 00:43:04
What is the reason for the same, because the trigger for a new Ecwid is checked every 10 minutes but the gap between both tasks is more than 15 minutes

Polling-based triggers can show such discrepancies in trigger time. Even if the trigger interval is set to 10 minutes, it may take longer due to queue processing.

Our team is reviewing the current polling system to ensure that these discrepancies do not occur in the future, but it will take some time.

Thanks & Regards,
Arshil Ahmad
Customer Support Associate
Pabbly.com
Rate your support