Skip to main content
Best answer

Text to Line-Item not working as expected

  • Jan 30, 2024 10:25 PM UTC
  • 3 replies
  • 169 views

Forum|alt.badge.img

I’m trying to parse out a “raw body” response to line items from a catch raw webhook step. 


In the “test” view it looks like the output is correct (I’m looking for the 9 -“pulseid”):

 

However, when I go to the next step the output is still formatted as the “raw body”:

Would appreciate any help!

Best answer by Troy Tessalone

Hi @erusso 

Perhaps try these options:

 

Formatter > Text > Split

Use 2 to isolate the desired value.

 

Formatter > Text > Extract Pattern

Ask ChatGPT for help configuring the regex.

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Answer
  • Jan 30, 2024 10:32 PM UTC

Hi @erusso 

Perhaps try these options:

 

Formatter > Text > Split

Use 2 to isolate the desired value.

 

Formatter > Text > Extract Pattern

Ask ChatGPT for help configuring the regex.


Forum|alt.badge.img
  • Author
  • Beginner
  • Jan 31, 2024 4:07 PM UTC

Thanks, Troy! That worked :) 


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • Feb 1, 2024 9:26 AM UTC

That’s awesome @erusso! Big thanks to Troy for pointing you in the right direction!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗