I've set up an endpoint via http-functions that receives a POST request with a JSON body and inserts the body into a collection. It's nearly identical to the POST request with JSON body example here: https://www.wix.com/code/reference/wix-http-functions.html#post
The data is getting inserted in to the database but it is not being parsed in to valid data types. Everything that isn't being inserted in to a string field is being captured as a string and the collection indicates the data wasn't captured as the relevant type. I'm not having any luck finding any sort of expected formatting for values.
The three non-text fields I'm trying to insert are:
A date and time into a date and time field
An integer in to a reference field referencing a table whose Title field is only integers
A number with decimals into a number field
How should I be formatting these so that the data is inserted as the expected data type? Thanks.