Hi there!
I’m making a Zap that adds a row to gsheets when a private note is added to a Freshdesk ticket. It works great when I put it live but the problem is that I can’t pull in my own data to test with, the only option is the Zapier dummy data. I want to use the Zapier formatter to split the comment field but I can’t test this with the dummy data. I’ve tried making it a public note but that doesn’t change anything. Can anyone help? :)
Best answer by shalgrim
View original
+14
Hi
Good question.
After creating a new Note in Freshdesk, have you tried pulling thru new examples in the Zap trigger?
Hey, thanks for your response! Yeah I’ve tried multiple times, I’ve added new notes as tests and pulled again and still nothing
+8
Hi
Sorry you’re running into this. Looking at this integration, it looks like the Test step is configured to always return the generic sample data.
I’ve gone ahead and created a Feature Request for this to pull back actual data. I don’t have an estimate on when that will be addressed, but the good news is that the developers at Freshdesk who maintain this integration have access to our Feature Request system, so they will see it immediately. And since you’re registered as an interested user you’ll be kept up to date whenever there is a fix.
In the meantime, can I help you split the comment field even though you won’t be able to test it in the editor?
Hi
Yes, if you could help me split the comment field that would be amazing. The comment will be structured like this in freshdesk:
SP Closed
SP ID: 123456
Booking ID: 123456
Customer comment: “some comment”
I would like to send each row into it’s own gsheets column.
Thanks!
+8
Right, I think we can do this pretty much entirely with Formatter
First, in the step after Freshdesk, choose Formatter and the Text action
Then when you click on Continue, set up your action like so:
This should output each line as a separate field that, if you’re using something like the Google Sheets Create Row action, will let you map each to one of that sheet’s columns.
Like I say with that Separator field, it’s hard to know just how Freshdesk is formatting the text without playing with it (since it’s whitespace), but you can start with [:newline:] and go from there. If you click on the “more” link there, you’ll find a link to this help desk on other ways to split by special characters.
If everything fails there we can try with a Code step
Let me know how that goes!
Hey
+8
@meganvrw
I’m confused as to why you’re only getting one output. What do you have as your Segment Index selection in the Formatter step?
+8
Okay,
This may take some fiddling to get just right, but you can map fields that aren’t even in your test data by “faking a pill.”
The think you’ll want to enter into the column fields is of this format:
{{123456789__output__Item 3}}
The breakdown of that is as follows:
123456789 is the Node ID of the formatter step. You can get it by selecting the Formatter step in the editor then copying the last big number in the URL that shows. E.g., https://zapier.com/editor/999999999/published/123456789
Then, notice that when we have underscores there they are actually double underscores: __ not _
And then the “Item N” refers to each line in your formatted note. I think, based on what you shared above, that the first line is going to be “Item 1,” the second line will be “Item 3,” and so on, since the blank lines will be the even numbers.
Do you want to give that a try and let me know how it goes?
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
