CreateCustomerProfileFromTransaction
Use this procedure to create a customer profile, payment profile, and shipping profile from an existing successful transaction.
Stored Procedure-Specific Information
To execute this stored procedure, enter:EXEC CreateCustomerProfileFromTransaction TransId='1234567890'
Input
| Name | Type | Required | Description |
| RefId | String | False | Merchant-assigned reference ID for the request. If included, this value is returned in the response. |
| TransId | String | True | The payment gateway assigned identification number of the transaction to create the customer profile from. |
| MerchantCustomerId | String | False | Merchant-assigned identifier for the customer. Used when creating a new customer profile; do not specify together with CustomerProfileId, which adds to an existing profile instead. |
| Description | String | False | Description of the customer profile. Used when creating a new customer profile; do not specify together with CustomerProfileId, which adds to an existing profile instead. |
| String | False | The customer's email address. Used when creating a new customer profile; do not specify together with CustomerProfileId, which adds to an existing profile instead. | |
| CustomerProfileId | String | False | An existing customer profile ID to add the payment and shipping profiles from the transaction to. When specified, a new customer profile is not created and the MerchantCustomerId, Description, and Email fields are ignored. |
| DefaultPaymentProfile | Boolean | False | Whether the payment profile created from the transaction should be marked as the default payment profile. Allowed values are true and false. |
| DefaultShippingAddress | Boolean | False | Whether the shipping address created from the transaction should be marked as the default shipping address. Allowed values are true and false. |
| ProfileType | String | False | The type of customer profile to create. Possible values are regular and guest. |
Result Set Columns
| Name | Type | Description |
| RefId | String | Merchant-assigned reference ID for the request. |
| ResultCode | String | Overall status of the request. Possible values are Ok and Error. |
| Code | String | Response code that represents the status. |
| Message | String | Text description of the status. |
| CustomerProfileId | String | The identifier of the customer profile that was created or updated. |
| CustomerPaymentProfileIdList | String | The identifiers of the payment profiles created from the transaction. |
| CustomerShippingAddressIdList | String | The identifiers of the shipping address profiles created from the transaction. |
| ValidationDirectResponseList | String | The raw gateway validation responses returned when the created payment profiles are validated. |