Hi ​@Knometa,

Welcome to the Community.

Unusually, HTML tags appear in your Wave invoices, especially since the test data from Paymo doesn’t show any. Your current Zap setup, including using the Formatter to strip HTML tags, appears correct and is a solid troubleshooting approach. However, the issue might persist due to hidden formatting in the live data from Paymo, so it’s worth reviewing recent invoice entries to check for any embedded HTML. Additionally, test the Formatter step to ensure it’s functioning properly with sample data that includes HTML tags. It’s also possible that recent updates to Wave’s API could be contributing to the problem, so checking for any changes there may be helpful. If these steps don’t resolve the issue, contacting Zapier support is recommended for a more in-depth investigation.

I hope this helps. Let us know if you have any other concerns. Thank you.

You can try adding a Coding step as well to remove the html as Formatter by zapier sometimes miss the edge cases. You can pass description to the coding step and used the clean data afterwards.

const cleaned = inputData.description.replace(/(<([^>]+)>)/gi, "");
return { cleaned };

 

Hi ​@Knometa,
 
We just wanted to see how everything is going with your Zap. Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
 
We're looking forward to your response.

Thank you ​@JammerS and ​@Mohammad_Shahzaib_Nawaz.

Here are the troubleshooting steps I’ve tried based on your responses:

1. Tried manually adding html tags to the item descriptions in Paymo, but I was unable to actually test this because it appears that the Paymo app does not allow html tags in the description because they were automatically removed each time.
2. Tried adding a Run Javascript step with the code provided by Mohammad. This did not make a difference.

Attached are two images. “Paymo clip.png” shows the description for an item on the Paymo invoice. You can see that there is html styling of gray color and italics added to the elapsed time recorded for the item. “Wave clip.png” shows that it is these styling tags that are slipping past the steps in the Zap.

​@JammerS, in your first reply you mentioned checking for any potential updates to the Wave API. It’s not clear to me how to do this. Can you guide me?

Hi ​@Knometa,

You might be encountering a bug here. I’d recommend reaching out to our Support Team to create a bug report on your behalf.

You can reach our Support Team here: https://zapier.com/app/get-help

Hopefully, this helps.

Working with Zapier support it was determined that the problem was not due to a bug, but to an error in my code. The problem: When I added the Remove HTML step, I failed to update the Create Invoice step that came after it to actually use the data output from that step. In other words, my Create Invoice step was still pulling data for the Item Description field from the trigger step instead of the formatted data step.

Hi ​@Knometa,

You've correctly identified the issue with your Zap. After adding a step like "Remove HTML" to format data, you need to update any of the following steps to use the output from that new step. To fix it, go to the "Create Invoice" step, update the relevant fields (like Item Description) to pull data from the "Remove HTML" step, and test your Zap to ensure it's working correctly. Also, check other steps that may rely on the formatted data, then save and turn your Zap back on.

Feel free to ask for further assistance if you have any questions or issues.