API property character limits

Ben Regier

Seems like this is probably right in front of my nose, but I can't find it.


We're syncing some data from the API to a backup database.  I'm building the database and need to know which data types to use for the columns. Is there documentation that shows that the character limit would be for the various properties in each entity?


For instance, I was surprised to see a phone number returned that was 57 characters long.  A mistake, of course - someone put a URL in there somehow instead of a number, but still, I would not have expected the phone number property to return a value that long.  I had allowed 50 characters for that column, so of course it complained when the 57-character string came through.