I use an external data collector written in C#. I send the data via the WIX POST http-function into a WIX Collection. There are two fields, one is a date field the other is a numeric field. The external JSON array looks like this: { "dateTime": "2020-12-18T08:00:00Z", "mbPercentagePerforma…

//... .then(body => { let toInsert = JSON.parse(body); toInsert.dateTime = new Date(toInsert.dateTime); return wixData.insert("Collection-Name", toInsert); } ) //...

External JSON DateTime into Collection

Ask the community

affoltes December 23, 2020, 11:41am 3

Thanks!
That worked out perfectly.
Is there a reference article showing, how to convert different data types in the backend, before the wixData.insert call?

Topic		Replies	Views
wixdata insert() expected formats? Ask the community code , question	1	510	April 11, 2018
Import DateTime to Collection from JSON: does not match the field type Ask the community code , question	6	433	November 25, 2020
Convert PHP Date to Wix Database Date Ask the community code , question	1	83	March 7, 2021
Create JavaScript Date object from collection Ask the community code , question	3	243	June 17, 2019
Regarding Date conversion in database during JSON Upload Ask the community code , question	0	238	May 3, 2018

External JSON DateTime into Collection

Related topics