Issue with Clay webhook causing errors with punctuation in words | Clay

Issue with Clay webhook causing errors with punctuation in words

Guys, urgent request. When I make a webhook to Clay with words that have pontuation in them (F.e: á, à, etc..) clay is giving some errors in them. Example: This is very bad because we sent bulk emails with wrong formats.. Can this be fixed asap?

✅2

102 comments

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Kareem Amin
·
·
Roger T. can you take a look
Roger T.
·
·
Sure, taking a look now
Roger T.
·
·
Hi Pedro, sorry that you're experiencing this issue. I just tried to send data to a webhook with the 2 accents that you listed (á, à), and they were inserted in my table properly.
Roger T.
·
·
To troubleshoot this further, can you:
1.
find an example that you can replicate (i.e. if you send the webhook yourself, that it appears incorrectly in the table)
2.
double check that the application sending the webhook is sending the data properly?
Roger T.
·
·
If you can share the table URL, I'll also double check on our end what we received from your application
Pedro A.
·
·
found the issue
Pedro A.
·
·
this ocurs when clay sends info in headers
Roger T.
·
·
can you elaborate? I'm not clear, I thought this was an issue with data sent to Clay, not Clay sending data
Roger T.
·
·
okay, thanks for the clarification. Let me take a look, but I don't think that the data is supposed to live the in HTTP headers, that's likely the issue. data is supposed to live in the HTTP body.
Pedro A.
·
·
yeah, but because I'm sending an array, thats the only way I found to send data that I already had
Roger T.
·
·
you can do this inside of the http body, I can take a look
Pedro A.
·
·
https://app.clay.com/workspaces/47853/tables/t_0EHcxVWa6l3Y/views/gv_tqYiufWgInFT
Pedro A.
·
·
can you pls input an example in the http body and then I can make the rest?
Roger T.
·
·
sure, let me first double check on my end that everything works properly with the body (that the accent goes through properly), then we'll fix your table
:thumbsup_all:1
Pedro A.
·
·
I also have another flows that can be sending accents in the headers, so if that could be fixed it would be great. I'm not sure if it's easy tho
Roger T.
·
·
okay, I just double checked in one of my tables and the accents went through properly, it must be because of your use of the headers
Roger T.
·
·
what you need to do is write the following formula for the body:
JSON.stringify({"field1:":your_data_point,"field2":your_data_point})
etc...
Roger T.
·
·
Do you want to give it a try? you'll need to move over all the headers and remove them

Roger T.

for e.g.

JSON.stringify({"testing:":{{Webhook}}?.name})

Pedro A.
·
·
Ok, but can't the headers be changed to use the accents? That would save us a lot of work
Roger T.
·
·
no, this is not how HTTP requests work - this is an internet standard, this is not a Clay decision
Pedro A.
·
·
ok. So, how can I input individual fields and the people data array at the same time?
Roger T.
·
·
can you explain what you need? with the example above, you add whatever data point you want

Roger T.

e.g.

JSON.stringify({"field1:":your_data_point,"field2":your_people_array})

Pedro A.
·
·
I want to add everything inside people, but also individual variables
Pedro A.
·
·
people is not a field.. is an array.
Pedro A.
·
·
will it work?
Roger T.
·
·
yes
Pedro A.
·
·
ok, will try it, thanks
Roger T.
·
·
try it with 2 fields just to make sure that it works, and let me know. I'll fix your column settings if it doesn't work
Roger T.
·
·
and then you can add the rest
Pedro A.
·
·
Roger T.
Roger T.
·
·
okay, I'll modify your config - one sec
Roger T.
·
·
just made the modification, can you fix this error on your end?
Roger T.
·
·
cc Eric E. regarding this whole thread - we should add some instructions on the use of the headers, and the UX for populating the body still seems difficult (key-value pairs seem a better alternative here)
Pedro A.
·
·
It worked, but I didn't received the people
Roger T.
·
·
it might be the way your receiving app deals with arrays, let me convert the array to a string
Roger T.
·
·
can you try again?
Pedro A.
·
·
didn't received the array
Roger T.
·
·
okay, let me check
Pedro A.
·
·
I'm afraid this will not be possible...
Pedro A.
·
·
I already tried to do it in the past, that's why I made it with the headers thing
Roger T.
·
·
yeah, I tried a few things and am not getting the array to go through. We should be able to make it work though. Eric E. - how do you usually build body payloads? I just tried to put an array as a value and it wasn't passed properly. Stringifying it also didn't work. Can you take a look? https://app.clay.com/workspaces/47853/tables/t_0EHcxVWa6l3Y/views/gv_tqYiufWgInFT column "HTTP API"
Pedro A.
·
·
We really need to get this going 😞 Could this be solved asap?
Roger T.
·
·
Sure, I'll circle back with my colleague and let you know
Eric E.
·
·
Hey Pedro A. — I am taking a look at this now — Can I safely trigger some tests on your end, without breaking anything?
:thumbsup_all:1
Pedro A.
·
·
yes, the webhook is for testing
Pedro A.
·
·
remove the -test if you want to have always a 200
Pedro A.
·
·
Eric E.
Eric E.
·
·
were you able to receive the array just now?
Pedro A.
·
·
yes, received one!
Eric E.
·
·
i just tried a second one
Eric E.
·
·
can you confirm?
Pedro A.
·
·
yes
Eric E.
·
·
awesome
Pedro A.
·
·
only received the array. Now the next step is how can I also send individual variables
Eric E.
·
·
Where do you need to send individual variables?
Eric E.
·
·
I.e. in which column?
Pedro A.
·
·
thats the thing we were talking about in this thread
Eric E.
·
·
right — but how do you want it structured?
Eric E.
·
·
what should the payload look like?
Eric E.
·
·
okay — i just tried another one adding company name as well
Eric E.
·
·
did that work? people should be its own array and company_name should be there
Pedro A.
·
·
ok, that actually worked!
Eric E.
·
·
❤️
Pedro A.
·
·
forget my video lol
Pedro A.
·
·
can I add as many variables as I need? (They are a lot ahaha)
Eric E.
·
·
When using tokens, we json.stringify on the backend automatically. So the structure is: {“field_1”: <Token with no quotes>, “field_2": <Token 2 with no quotes>} etc
Eric E.
·
·
Yes
Eric E.
·
·
you can add as many as you need
❤️1
Pedro A.
·
·
ok eric, will give this a shot, how are the best man, many thanks!
Pedro A.
·
·
I'm getting a failed to parse, can you pls help? Eric E. https://app.clay.com/workspaces/47853/tables/t_0EHcxVWa6l3Y/views/gv_tqYiufWgInFT
Pedro A.
·
·
HTTP API Column
Eric E.
·
·
ah — i see what’s happening here — when you mark things as “optional”, it’s disappearing from the body instead of showing a null value
Eric E.
·
·
what would be your preferred payload here, wherever your sending the data to?
Eric E.
·
·
Would it be that you send null for each field that doesn’t have a value, or would the null value break things?
Pedro A.
·
·
if the value doesn't exist, I don't want to receive nothing
Pedro A.
·
·
for that value
Pedro A.
·
·
But I still want the column to run
Eric E.
·
·
if you receive null for that column, meaning empty value, would it break things? Just so there’s a consistent payload structure?
Pedro A.
·
·
I'm not getting what you are tring to say. Lets imagine I don't have nothing in "job_posted" It's cool to receive the payload without it OR if the value doesn't exist in the output
Pedro A.
·
·
Either option is good for me
Eric E.
·
·
okay — let me see if I can work something up here
Pedro A.
·
·
thanks
Pedro A.
·
·
pls let me know once you have something
Eric E.
·
·
it’s going to take me a bit to solve this, but I am working on it right now
:thumbsup_all:1
Pedro A.
·
·
Ok Eric E. thanks, pls let me know if this is doable 🙂 I really hope so
Eric E.
·
·
Hey Pedro A. — i was able to fix it using _.fromPairs to generate the object on our backend, and using a conditional statement that people must exist
Eric E.
·
·
you should be good to go now
👀1
✨1
Pedro A.
·
·
you are a magician
Pedro A.
·
·
now I need to apply this to my other flows
Pedro A.
·
·
How can I do it? Do I need to always use the _.fromPairs([?
Eric E.
·
·
if you’re going to want optional inputs for now, then i would. It just covers you from weirdness
Pedro A.
·
·
ok thanks. This works in any table, right?
Eric E.
·
·
Yessir
Eric E.
·
·
😄
Pedro A.
·
·
And this will work always? I'm afraid that someone can turn the thing you did off and then it will break our flows
Pedro A.
·
·
just double checking ahah
Pedro A.
·
·
btw Eric E. just duplicated everything and it's working like a charm, you are the best!
Eric E.
·
·
❤️
Eric E.
·
·
this should always work
❤️1