APIs & Integrations

josh1
Member

Unique ID maximum values

SOLVE

Hi, we are looking to store contact ids (and owner ids) in our database for syncing.

Two questions;

  1. Will these ids always be integers or will they ever by alphanumeric?

  2. If they are integers, what is the maximum value?
    OR
    If they are alphanumeric, what is the maximum string length?

Thanks!

0 Upvotes
1 Accepted solution
Derek_Gervais
Solution
HubSpot Alumni
HubSpot Alumni

Unique ID maximum values

SOLVE

Hi @josh,

Contact vid values are integers, so you won’t see any alphanumeric strings. In theory, vids can be as large as needed; they’re currently stored as unsigned 64-bit integers, but could be scaled up to be arbitrarily large. In practice, you likely won’t see vids larger than 7-8 digits. Can I ask why you’re interested in the maximum size of vids?

View solution in original post

0 Upvotes
2 Replies 2
Derek_Gervais
Solution
HubSpot Alumni
HubSpot Alumni

Unique ID maximum values

SOLVE

Hi @josh,

Contact vid values are integers, so you won’t see any alphanumeric strings. In theory, vids can be as large as needed; they’re currently stored as unsigned 64-bit integers, but could be scaled up to be arbitrarily large. In practice, you likely won’t see vids larger than 7-8 digits. Can I ask why you’re interested in the maximum size of vids?

0 Upvotes
josh1
Member

Unique ID maximum values

SOLVE

Hi @Derek_Gervais ,

Thanks for your helpful answer!
To facilitate syncing we are looking to store vids in our database and I just wanted to make sure I was using the correct data types for the fields.