hi there,
I am using formatter to itemise my list but when i try an import it into a webhook, it’s stringing it together.
hi there,
I am using formatter to itemise my list but when i try an import it into a webhook, it’s stringing it together.
Hi
We might need some extra information/context to help you with this one. When you say that you’re trying to itemise your list, do you mean that you are using the text to line items action?
And could you please share a screenshot of the output of the formatter step ie what you see when you test the step? Don’t forget to remove or obscure any personal or private information in any screenshot you share in the community (eg full name, email address, etc).
Thanks!
Hi
Thanks for your reply. Please see below more detail of my issue.
I am having an issue with my CSV file I am trying to import into webhook.
When I use formatted to read my file, it seems to output correctly however, when I try and use the output, it is incorrect.
see below:
I have approx 3 heading (code, name, points) and each row under that represents a different person e.g:
when I look at the output of my test, each row seems to be looking correct.
1.
code-12345
name- Jane Doe
points- 50
2.
Code-16535
name- Sam Test
points-100
3.
code- 17546
name- John Doe
points- 4000
unfortunately though, when I go and
use that information in other apps (such as webhook, it seems to be grouping the columns together in one string. Eg:
Code: 12345,16535,17546
Name: Jane Doe, Sam Test, John Doe
points: 50,100,4000
With this, it’s causing an error as it’s not importing the single item. Also, I tried importing into a database to confirm how it would import into, say, a spreadsheet and it imports the entire string
I have tried each of the settings in formatter, tried to play around with the format of the spreadsheet etc but nothing
Wondering if anyone has a solution OR even if there is a way for Zapier to read a file, csv or text without having to use formatter
Thanks in advance
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.