Best answer

Extract Text from Raw Webhook

  • 11 January 2023
  • 3 replies
  • 212 views

Userlevel 1

I’m receving a webhook with the JSON string:

{

"row": [{

"offline_conversion_date": "12/27/2022",

"gclid_value_first": "CjwKCAiA-dCcBhBQEiwAeWidtSTLlONJz_5fYxxgTKO-7M8dqKk7oadad5XwQl_1RysOBH7C7MtAkhoC6icQAvD_BwE",

}]

}

 

I want to extract “offline_conversion_date” and “gclid_value_first” separately.

 

I’ve tried a few JS and Extract Pattern options based on other posts but couldn’t quite crack it. 

 

Any help is appreciated!

icon

Best answer by Troy Tessalone 11 January 2023, 21:11

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

Userlevel 7
Badge +14

Hi @carnegiehighered 

Good question.

Have you tried using a regular Catch Hook trigger instead of a Catch RAW Hook?

 

Some options:

  1. Use multiple Formatter > Text > Split steps in the Zap
  2. Use 1 Code step
  3. Try using OpenAI Send Prompt to do the parsing followed by a Formatter step to separate the results
Userlevel 7
Badge +14

@carnegiehighered 

Give this JavaScript Code a try.

 

CONFIG

 

CODE

let Set = JSON.parse(inputData.Set.replace(/\n/g,"").replace('",}]','"}]'));

output = [{Set}];

 

RESULTS

 

Userlevel 1

Thanks Troy - that JS worked great!