Hexowatch event -> gsheet new row with Hexowatch monitor update values

luiginica

Member
Hello,

I watched that Hexowatch -> Clickup video and I can see that is not actual since after pasting the Hexowatch API, the webhook field do not appear anymore so we can not copy the right webhook and paste it in Hexowatch. I tried to adapt that value with the value from the URL
https://connect.pabbly.com/workflow/mapping/IjE4NjIzOSI_3D
So this will be the webhook: https://connect.pabbly.com/workflow/sendwebhookdata/IjE4NjIzOSI_3D

Still, I'm doing something wrong: https://share.getcloudapp.com/Qwu2wKoN

I get this error:
Task Error Detail:

{
"error > code": 400,
"error > message": "Invalid JSON payload received. Unknown name \"\": Root element must be a message.",
"error > status": "INVALID_ARGUMENT",
"error > details > 0 > @type": "type.googleapis.com/google.rpc.BadRequest",
"error > details > 0 > fieldViolations > 0 > description": "Invalid JSON payload received. Unknown name \"\": Root element must be a message."
}

Can someone help, please?
 

Supreme

Well-known member
Staff member
Hey @luiginica

We looked over your concern, the error is occurring due to the HTML tags are coming along with your data from your Hexowatch, which is basically causing the interruption in the format of the data which should be passed to the Google Sheets "Append Value".

2021-11-18_11h13_44.png




2021-11-18_11h17_47.png



So to remove the random HTML tags from the data, you can use the Text Formatter.

2021-11-18_11h25_12.png
 

luiginica

Member
Hello,

How do you see that Data Out? I don't see that in my interface.

I want the HTML tags to come along in the Google sheet.

In case that you can't accommodate this, how do I have to add that Text Formater? Do I have to add 15 text formaters for all the values?
Here's a video with how I implemented the text formater: https://share.getcloudapp.com/qGuR6bO0
But there is an error: "Invalid JSON payload received. Unknown name "": Root element must be a message."
 

Supreme

Well-known member
Staff member
Hey @luiginica

No, you do not require more than 1 text formatter for your concern. You can simply pass the data in double-quotes with comma-separated values.

Though we have already made the changes in your respective workflow and seems like it is working accordingly.

Moreover, the Text Formatter is not chargeable it is a free task. I hope this might help you out.

Regards


unnamed2.png
 
Top