suardim
#1
Hello to everyone!
I’m trying to separate the values coming from a webhook (form submission) into fields to export to sheets and other apps.
But the data comes all in an entry inside the query.
How can I propper separate it into fields?
I saw another post saying about split function, but I think it didn’t apply to my case.
I now that the data coming as mf-nome will be the name, and the mf-telephone will be a phone number… but how to separate it into columns?
BramKn
#2
Hi @suardim
Could you provide the data?
It of course depends on what is coming in.
suardim
#4
Sure
That’s the query:
“entries”:
“{“mf-nome”:“name”,“mf-telephone”:“phone999”}”,
BramKn
#5
The item lists node should do what you need I think.
Uhh no scratch that should have looked properly. Will give you an example this afternoon.
BramKn
#6
@suardim
There is a few examples on the forum. This is one of them. the important bit is the Object.keys() function you can use this in the code node.
1 Like
suardim
#7
Thank you @BramKn .
How can I use the entry data that I have in the code?
BramKn
#8
yes, something like: Object.keys(query.entries)
suardim
#9
My code skills are not developed yet 
Is there another way to do that? Or can anyone show the way to do it with coding?
suardim
#10
Hello.
Did find a simple way to do that researching trough the forum using the function JSON PARSE.
Utilizing a SET node with a value of {{ JSON.parse($json[“query”][“entries”])}}
2 Likes
system
closed
#11
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.