topic Re: CIM createCustomerPaymentProfileResponse, need clarification on customerPaymentProfileId format in Integration and Testing

CIM createCustomerPaymentProfileResponse, need clarification on customerPaymentProfileId format

codasaurus — Thu, 27 Dec 2012 18:03:52 GMT

Using CIM, PHP SDK, MySQL

Documentation states:

customerPaymentProfileId

Format: Numeric

Numeric can mean many different things. How should this value be stored? Unless we have more details on what exactly this value can contain, it seems the only safe way to store it is as a string.

Re: CIM createCustomerPaymentProfileResponse, need clarification on customerPaymentProfileId format

RaynorC1emen7 — Thu, 27 Dec 2012 20:23:44 GMT

it a whole number, it 8 digit for now, but could grow to 9 digit then 10, etc

Re: CIM createCustomerPaymentProfileResponse, need clarification on customerPaymentProfileId format

codasaurus — Fri, 18 Jan 2013 22:43:48 GMT

Thank you for the clarification. Our original developer set the mysql data type as decimal(10,1), and I was trying to figure out if he knew something I didn't know. As long as the value will always be a whole, positive number, it seems the best approach would be int(11) unsigned