Extract Values from Text – BigCommerce Product Options

Question

I’m trying to extract 3 values from BigCommerce custom product options. Each product will have these 3 options:

Learner First Name
Learner Last Name
Learner Email Address

I was able to use the “Extract Email Address” function in the Zapier Formatter, and that is working well. I’m having trouble extracting the other two values, though. The data is coming through like this:

item_1:
display_name: Learner First Name
display_name_customer: Learner First Name
display_name_merchant: Learner First Name
display_style:
display_value: Jonathan
display_value_customer: Jonathan
display_value_merchant: Jonathan
id: 16
name: Learner First Name
option_id: 33
order_product_id: 17
product_option_id: 155
type: Text field
value: Jonathan
display_name: Learner Last Name
display_name_customer: Learner Last Name
display_name_merchant: Learner Last Name
display_style:
display_value: May
display_value_customer: May
display_value_merchant: May
id: 17
name: Learner Last Name
option_id: 34
order_product_id: 17
product_option_id: 156
type: Text field
value: May

I just need the 2 “value” fields, but I need to know which option the value is associated with - Learner First Name or Learner Last Name.

icon

Best answer by Troy Tessalone 4 December 2022, 22:01

View original

Troy Tessalone · Accepted Answer

@jonathanisaacTry this JavaScript Code step...InputCodelet Learner = inputData.Learner;Learner = Learner.split("
");Learner = Learner.filter(i => i.includes("display_value:"));let LearnerNameFirst = Learner[0].split(": ")[1];let LearnerNameLast = Learner[1].split(": ")[1];output = [{LearnerNameFirst, LearnerNameLast, Learner}];Output

Troy Tessalone · Answer

Hi @jonathanisaacGood question.Can you post a screenshot with how the returned data is structured for clarity?Looks like there are 2 sets of data related to each field.You can try using Formatter > Text > options to isolate the desired value.Otherwise, a custom Code step can be used.First NameLast Name