I’m new to working with Zapier webhooks and running into an issue with data formatting. When I receive data from my third-party service, some fields aren’t coming through as simple text values but instead as complex array structures.
The incoming webhook data looks something like this:
totally get it! Just rerun the data through a filter, and then regex is ur best bud for picking out those bits. it’s a pain initially, but trust me, it pays off big time!
I ran into this same issue integrating a property management system with webhooks. Skip the regex headache - use Zapier’s text parsing tools instead. The “Extract Pattern” action in Formatter by Zapier is way easier to work with. Set up a pattern that finds “category: EmailAddress” then “content:” and grabs whatever follows. Do the same thing for CellPhone and note fields. I’d create separate formatter steps for each field you’re extracting - makes it super easy to map everything to your CRM later. Your webhook data looks consistent, so this should work every time.
I dealt with this exact problem integrating webhook data into Salesforce last year. Zapier’s Code by Zapier step saved me - just use JavaScript to parse everything properly. Split the data by lines, then loop through to find field types and grab the content. For your setup, write a script that hunts for ‘category: EmailAddress’ or ‘category: CellPhone’ lines, then pulls the content from the next line. Save each piece as its own output variable so you can map them easily later. Way cleaner than regex patterns that’ll break when the format shifts.