Hello friends!
I want to send an API request and need to include date in the DateTime format. I am not sure what does that mean, but let me know if Zapier formatter can convert a date into this format? Or is there any alternative?
Best answer
How to convert Date from Airtable field to be added to a JSON data in Zapier Webhook?
- Beginner
Best answer by colbyhemond
YYYY-MM-DDThh:mm:ss.SSSZ
Here is an example I found from a different page of the SnipCart docs:
2016-05-25T21:21:27.213Z
It doesn’t appear that Zapier offers this format as one of their predefined options, so you can just click on the “Custom” tab and paste YYYY-MM-DDThh:mm:ss.SSSZ in order to use that format.
Hope this helps!
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
It looks like there’s a handful of DateTime formats that Zapier’s formatter can translate the date into:
https://zapier.com/help/create/format/modify-date-formats-in-zaps#customize-date-time-options
Does the API you’re trying to use have documentation that explains which format it is expecting?
Colby Hemond
- Beginner
Thanks
I’m sending a JSON payload in this format.
curl https://app.snipcart.com/api/discounts \
-H "Content-Type: application/json" \
-H "Accept: application/json" \
-u {YOUR_API_KEY}: \
-d "{ name: 'Free shipping',
trigger: 'Total',
totalToReach: 150,
type: 'Shipping',
shippingDescription: 'Free shipping',
shippingCost: 0,
shippingGuaranteedDaysToDelivery: 10 }"YYYY-MM-DDThh:mm:ss.SSSZ
Here is an example I found from a different page of the SnipCart docs:
2016-05-25T21:21:27.213Z
It doesn’t appear that Zapier offers this format as one of their predefined options, so you can just click on the “Custom” tab and paste YYYY-MM-DDThh:mm:ss.SSSZ in order to use that format.
Hope this helps!
Colby Hemond
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.