Inconsistent Data leads to BundleValidationError

Hi,

i am trying to create google contacts from clickup tasks. i use custom fields for phone number, email and relationship fields for company and referrals … this works great IF all the fields are filled out.

if i dont fill out a few fields than they do not exist in the transmitted data from clickup. they are not “NULL” or “EMPTY” … the key:value does not exist at all.

so i always get BundleValidationError on these fields and i dont know how to handle this properly. i did activate the settings for Allow storing of Incomplete Executions to “yes” but that also did not help.

how can i simply tell make to ignore these fields or put “” whenever there is the array field missing?

thanks

Hi,

To resolve your problem, please attempt using the ifempty function with either the ignore or null value. In the value field, kindly utilize the field data when using {{ifempty(“value”; ignore)}}.

Thanks & Regards

MSquare Support
Visit us here
Youtube Channel

2 Likes

I have a similiar problem. I am using google sheets as a database and want to transfer the data to close crm to create a new lead. But the data is inconsistent. Some leads have 1 and other 2 email adresses or phone numbers. So the field for the second Mail is not always filled out. And that´s when the error happens.
Unfortunately the ifempty function was not working.

Hi @Simon_Wolf

Please provide more information about the workflow. Providing a clear explanation, preferably accompanied by a loom, would make it easier for me to grasp.

MSquare Support
Visit us here
Youtube Channel