+1I've seen several posts on manipulating dates, but none that seem to specifically apply to Webhook JSON POST in the Message body.
By default,
{
"date": [
{
"value": "[mydate] "
}
],
exports as mm-dd-yyyy, but I need to format to yyyy-mm-dd
Is this possible to reformat in this dialogue?
Thanks, James
+9Are you querying or inserting data. The schema response for dates per the documentation is supposed to be yyyy-mm-dd but I'm not aware of a setting to be able to request or alter that in either case of inserting or querying.
If you're querying the data - you could always just ignore the date field and convert it to text in whatever format you need an include that field as opposed to querying for the actual date field.
+11If you build this in a pipeline instead of the webhook function, you can use jinja to format the date in the request.
https://helpv2.quickbase.com/hc/en-us/articles/4473004144660-Transforming-your-data
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
