I currently am using an app called GoCanvas, where Zap is the middle to talk to QB online. The current problem is that OB Online adds “’:’’ to customers. This is caused from my understanding, when the parent company has smaller entites under them. Example if Parent billed to is called Targa , I would have Plant 1 , 2 , 3 and so on under them which creates the :
The error message i am recieving is this :
The error you're encountering with the QuickBooks step is due to the presence of unsupported or illegal characters in the string being passed to QuickBooks. Specifically, the field General Information: Customer : contains the value Targa Resources LLC:Greenwood #1, which includes a colon (:) and possibly other characters that QuickBooks might not accept in certain fields. QuickBooks has specific requirements for the format of strings, especially for fields like names and addresses, and certain special characters can cause issues.
How do i address this in Zap? I belive i have to use the Zapier's Formatter tool to clean up the data before it reaches QuickBooks. If so how do i implement this step?
Hi there
Welcome to the Community! 
You can use Text in Formatter - Replace action to remove the colon in the data. Here’s how it looks like:
Kindly give it a try and let me know how it goes? I'll keep an eye out for your response!
Also thank you for welcoming me to the community!
This is my current setup below
Where would the new action be at?
This Zap as well pulls an entire QB customer listing. Would I just use : and # in the input value section?
Hi
Thanks for the update.
Since you’re pulling the information from the trigger, we would need to add the formatter step after the trigger step. Additionally, we would need to create another Text in Formatter - Replace action to remove the # sign in the data.
Hopefully, this helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.