Maximum field lengths

[dmw]

Continuing the discussion from Data Returned - Limits:

@mfairhurst Please can you post an updated list of maximum field lengths? We have just found someone with a 60-character forename, which is more than the 50-character limit suggested below. The person is at this link:

Pannala Senanayake Mudiyanse Ralahamilage Janaka Krishanth WATOWITA personal...

@mfairhurst

@edith_manyumwa

The data dictionary for the API is published for each endpoint within the documentation: - Developer Hub Home

For each resource returned we provide the following: -

Parameter Name: The name of the field
Type: The data type
Description: A brief description
Additional: Details if its optional

We haven’t published field lengths as we are discussing if todo so and the most appropriate method. The reasoning behind being so reserved is we do not want to restrict ourselves and others with specific field lengths as changing in the future could be classed as a breaking change to the API and we want to limit breaking changes.

However to provide some information, the following details the maximum field lengths, at present, for the specific fields requested, but this may change in the future, so use for guidance, so maybe use double these values This should not be treated as official documentation as we have stated we are currently in the process of evaluating.

address" : {
       "address_line_1" : "string", 64 characters
       "address_line_2" : "string", 64 characters
       "care_of" : "string",  100 characters
       "country" : "string", 50 characters
       "locality" : "string", 50 characters
       "po_box" : "string", 10 characters
       "postal_code" : "string", 15 characters
       "premises" : "string", 50 characters
       "region" : "string" 50 characters

"name_elements" : {
        "forename" : "string", 50 characters
        "honours" : "string", 50 characters
        "other_forenames" : "string", 50 characters
        "surname" : "string", 160 characters
        "title" : "string" 50 characters

Hope this is of help

Thanks

@mfairhurst

[dmw]

I meant 58 characters, not 60. And by the way, this person was appointed as a director on 1-Sep-2012 with that name, so it seems that your 50-character maximum field length in 2016 was wrong. You could find out the current maximum existing name by running a query, something like: SELECT MAX(LENGTH(forename) FROM people.