About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Parsing Responses from Delighted

  • 20 August 2020
  • 3 replies
  • 113 views
W
Userlevel 1

I have an automation set up so that when a new survey response from Delighted is submitted, a new record is sent to our Airtable with that response, and other automations take over.

Previously, we had it set up such that Zapier’s Utility tool and Text Formatter tool would parse responses from the open ended text questions on our survey and pipe them into specific fields on our Airtable. Since Delighted sends the data payload over as one long text string for these responses, we used a combination of string.split and util.lineitem_to_string_v2 to parse the responses and separate the output into two different text fields on Airtable, `Feedback` and `Thank You`. Even if one response was null, the automation would still assign the correct output to the appropriate field. As of yesterday though, we came across instances where if `Feedback` was answered, but `Thank You` wasn’t, the text for feedback was being input into `Thank You` which was then sent via another automation to an email address of a user. 

Wondering if there was something that changed or if someone can help me set it up so that it can work again properly? Thank you! 

icon

Best answer by andywingrave 26 August 2020, 20:49

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

andywingrave
Userlevel 7
Badge +9

Hey! This is normal behaviour. You will need to handle this with a code-step, because Zapier is skipping the blank value, which you need to handle yourself.

 

Here’s how I did this in a previous zap (sending so you can see the logic - But this code is very specific to the JSON response I got)

 

const content = await rawResponse.json().then((data) => {
	function ColumnPair(columnName, columnValue) {
		(this.columnName = columnName), (this.columnValue = columnValue);
	}
	let combined = [];

	var columns = data.Result.Customfields;

	for (var i = 0; i < columns.length; i++) {
		if (columns[i].ColumnValue.length < 1) {
			columns[i].ColumnValue = 'n/a';
		} else {
			columns[i].ColumnValue;
		}
	}

 

W
Userlevel 1

Thanks! I was actually trying to avoid coding as I’m not familiar with JSON. However, I was able to get this working again by testing with a full record and now all partially filled responses are mapping to the correct fields. 

andywingrave
Userlevel 7
Badge +9

Great! Thanks for the update

Terms & Conditions