Error Adding Timetable to Work Hours: Data Type Mismatch Issue

I have this table and I’m writing the response to another table but I can’t add “timetable” under “work_hours” - the error I get is that the data (which says object) doesn’t fit with the type of the cell (which is text), but I don’t have “object” as a type so I’m not sure how that can be solved. Or how can I get that data out of there?

🎫1

9 comments

Channeled
APP
·
·
It seems you're encountering a data type mismatch when using our "write to table" feature. The "timetable" data you're trying to add is likely an object, but the destination column is set to accept text. To resolve this: 1. Change the column data type: • Right-click the "work_hours" column • Select "Edit Column" > "Select Data Type" • Choose a suitable data type (possibly "Text" if you want to store the object as a string) • Click "Save Settings" 2. If the data is a list, try adding it through the "Other data from this table" section. You can find a video tutorial here: https://cln.sh/DpHTlNt0 If you need more assistance, please request human support by clicking on "Talk to a person".
Source: Table columns | Documentation | Clay University
Channeled
APP
·
·
Channeled
APP
·
·
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
Andrei B.
·
·
Nope, can’t get it to work, I get “object object”, you can see in this table at the very end. What are the solutions to get that data out of there?
LuisArturo
·
·
Hey there Andrei thanks for reaching out, sorry for the delay here, taking a look at this, I see that the time table value that is causing this error is occurring due to it being stored as a JSON, which the Write to table cannot write over. Taking a look to see if we have a workaround for Write to table.
🙏1
🤞1
Andrei B.
·
·
LuisArturo do you have a workaround for this? 🤞
LuisArturo
·
·
Hey there Andrei, sorry for the delay here, after some testing on my end this currently is not possible in this current data format from the webhook. The data itself is too embedded with the Webhook column to be able to be pulled out into a single column. This would work if it were possible to have each Webhook only returned a individual restaurant instead of 25, as there would be less digging for the system o have to perform
LuisArturo
·
·
Hey there Andrei sorry for the delay here, got a solution for you, made a loom explaining it: https://www.loom.com/share/8fe88393255f44cd84de937ed72f8217?sid=d00057a5-e3b1-4d3d-91f2-eee48a989b84
Channeled
APP
·
·

Error Adding Timetable to Work Hours: Data Type Mismatch Issue | Clay