API UpdateNewsletterEmailAddresses: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledání
(Založena nová stránka s textem „==== Description ==== Method allows You to update newsletter email addresses in system. ==== Exact name ==== <code>API_UpdateNewsletterEmailAddresses</cod…“)
 
Řádka 21: Řádka 21:
 
|Internal system id
 
|Internal system id
 
|
 
|
 
+
|-
 
+
|@CustomerID
 +
|int
 +
|
 +
|ID of customer from customer list (see relation)
 +
|API_GetCustomers.ID
 +
|-
 +
|@Email
 +
|text
 +
|
 +
|Email
 +
|
 
|}
 
|}
  

Verze z 2. 8. 2017, 13:44

Description

Method allows You to update newsletter email addresses in system.

Exact name

API_UpdateNewsletterEmailAddresses

Type

Standard executable stored procedure.

Specification

Parameter Data type Value range Description Relation
@ID int Internal system id
@CustomerID int ID of customer from customer list (see relation) API_GetCustomers.ID
@Email text Email


Example

 DECLARE @ID INT 
 DECLARE @WorkshopID INT 
 
 SELECT @ID = id, 
       @CustomerID= [CustomerID], 
       @Email = 'info@nextis.cz' 
 FROM   [API_GetNewsletterEmailAddresses] 
 WHERE  id = 3
 
 EXECUTE [API_UpdateNewsletterEmailAddresses] 
  @ID, 
  @CustomerID, 
  @Email

Notices

None.