api.customerExtension()

The method api.customerExtension() has been deprecated in 14.0 version.

Deprecated Usage

Retrieves a list of all customer extentions records (CX) from a CX table named extensionName. The Customer must be defined in the context.

Groovy

def customerExtensionSalesOrgData = api.customerExtension("SalesOrgData")

return customerExtensionSalesOrgData

Result

version	typedId	name	customerId	createDate	createdBy	lastUpdateDate	lastUpdateBy	attribute1	attribute2	attribute3	attribute4	attribute5	attribute6	attribute7	attribute9
0	5827.CX10	SalesOrgData	CID-0003	2021-08-26T08:26:01	348	2021-08-26T08:26:01	348	AMER	US02	Darius Jakubik	USD	EN	Corporate Buying Group	CTP	Darius Duch

QueryApi Usage

Groovy

def qapi = api.queryApi()

def t1 = qapi.tables().customerExtensionRows("SalesOrgData")

return qapi.source(t1, [t1.customerId(),
                        t1.SalesTerritory,
                        t1.SalesOrg,
                        t1.AccountManager,
                        t1.Currency,
                        t1.Language,
                        t1.BuyingGroup,
                        t1.Incoterm,
                        t1.PaymentTerms,
                        t1.SalesManager,
                        t1.createDate(),
                        t1.createdBy(),
                        t1.id(),
                        t1.lastUpdateBy(),
                        t1.lastUpdateDate(),
                        t1.version()],
                        t1.customerId().equal("CID-0003"))
        .stream { it.collect { it } }

Result

customerId	SalesTerritory	SalesOrg	AccountManager	Currency	Language	BuyingGroup	Incoterm	SalesManager	createDate	createdBy	id	lastUpdateBy	lastUpdateDate	version
CID-0003	AMER	US02	Darius Jakubik	USD	EN	Corporate Buying Group	CTP	Darius Duch	2021-08-26T08:26:01	348	5827	348	2021-08-26T08:26:01	0

See Also