How to make data validation?

General
1

hello

I’m sending some strings to some servers via url connection, and i would like to check is this is correct formatted data before sending it to servers/database.

one example is timestamp strings to be store in sql databases
or if a string is a valid json, xml, html string.

or i have to check everything one by one

thanks

2

You need to check them. Only you know the dependencies between items that could cause your valid values to differ.

1 Like
3

yes but I supose i’m not the first one to bump into date time validation for SQL data validation, especially the complete time stamp string like
2022-07-25T13:24:00+00:00
is hard to validate since many version of this string is acceptable

2022-07-25T13:24:00+00
2022-07-25T13:24:00
2022-07-25
ect…