Hi, in the well data by pulling through API, I see two different columns - Id and InptID. Can you please tell me which is the actual unique identifier of a well? Additionally, what is the difference between the two id fields?
Hi Poli,
Both inptID and id are unique identifier for the well. From the APIs’ perspective, many endpoints require id so it is the identifier that is most commonly used. The difference between the two are that the id is a 24-character hexadecimal number (ex: 685d85e2a63e8024579bea39), whereas the inptID following follows the format of combining a fixed prefix INPT + 10 character string (ex: INPTEcildAuaxF).
You may also use the chosenID + dataSource + scope(project or company) as a unique identifier.
Hope that helps!