Give Empty field when no data found

[Lucas.]

Hi,

I'm creating a quite complex flow and have a question about it.
My data input can be diffrent many times.

Sometimes, I only have one row input, sometimes, two or three.
Now, I need to map all these inputs and use the data that is available.
This issues is, that once I map 3 lines, and only one line comes in, I get an error of missing data for the other two.

Now, It should just skip or leave empty if no data is found.
Is there any way to do this other than use the Router many times for each combination? (that would mean endlessly routering and copying flows)
Hoping for a nice solution

Thanks
Lucas

Do ask if it's not clear. I can record a video.

 

[PabblyMember4]

Hey @Lucas.

Could you please let us know about the 3rd party app that you want to integrate with Pabbly?

Also, please record a short video of the issue to get a better understanding of it.

 

[Lucas.]

Hi,

Please watch:

ClickUp

sharing.clickup.com

 

[Lucas.]

I'm connecting Prestashop trough MYSQL and I want to generate an XML file.
This is done trough Google Drive.

I'm mapping the order lines to the xml.
So each order line shoud be added to the xml.
For example:

Rows Order Row 0: QTY: 1
Rows Order Row 0: Price: 50
Rows Order Row 0: Name: Product test name
Rows Order Row 1: QTY: 4
Rows Order Row 1: Price: 60
Rows Order Row 1: Name: Product test name 2
Rows Order Row 2: QTY: 6
Rows Order Row 2: Price: 24
Rows Order Row 2: Name: Product test name 5
Rows Order Row 3: QTY: 6
Rows Order Row 3: Price: 24
Rows Order Row 3: Name: Product test name 6

I want to extraxt these fields and map them in a new step.
But, It should also work when there is only one order row.

Now it gives an error and gets stuck
What I need I think is one way to ignore "no data" messages and just leave it empty.

 

[PabblyMember4]

We are checking the details with the technical team and we will keep you updated on the status of this conversation.

 

[Lucas.]

Okay. Thanks. Right now the only possible solution can be using the router.
I'm trying this right now. This would only mean lots of copy pasting to get almost the same result.

One router for one order line, one router for 2 oder lines, ....

 

[Lucas.]

Hi, any news on this?
I'm stil waiting for a good solution or feature in Pabbly that ignore's the "No Data" error.
For example Zapier has this option to Ignore when empty. Or give an specific value when not found..
Could this be done?

 

[PabblyMember4]

Hey @Lucas.

We are still checking the solution with the team. We will keep you updated on the status of this conversation.

 

[Lucas.]

Okay. hope you have a solution to fix this soon.
Thanks

 

[PabblyMember4]

Hey @Lucas.

We checked with the team and got a response that we are not supporting the scenario that you mentioned. Whenever you are getting no data in the mapping we don't have a mechanism to ignore the No data scenario.

You should get the data to show properly in the mappings. Please let me know if you have any questions or comments.

 

[deoverbuurman]

@kunal,

We have a similar problem,

We want to map tasks for each team member that they are planning to complete tomorrow, which they all enter into a form. However, they can map up to 5 tasks but not all 5 will be used each day.

How could we have them enter 3 and have 2 tasks empty and map the first 3 only?

Or is this not possible?

 

[PabblyMember4]

Hey @deoverbuurman

Could you please share the workflow name where you have tried this scenario? We will check the details and let you know the solution to your concern. Also if possible could you please create another thread for this concern.

 

[deoverbuurman]

I have already fixed it!

Somehow got it to work the way I wanted to, cheers!