Simple Query against the Seller Extension Table.
Provide table from .tables() in .source().

Code

api to get sellerId

def sellerId = ...

qapi.tables().sellerExtensionRows()

def qapi = api.queryApi()

def t1 = qapi.tables().sellerExtensionRows("SellerQuota")

def sellerId = ... // Api to get sellerId

return qapi.source(t1, [t1.sellerId().as("SellerID"),
                        t1.SalesGoalIncrease.as("Sales Goal Increase %"),
                        t1.Rule1QuotaAmount.as("Rule1 - Quota Amount "),
                        t1.Rule1CompensationPct.as("Rule1 - Compensation %"),
                        t1.Rule2QuotaPct.as("Rule2 - Quota %"),
                        t1.Rule2CompensationPct.as("Rule2 - Compensation % ")],
                        t1.sellerId().equal(sellerId))
        .stream { it.collect { it } }

Result

SellerID	Sales Goal Increase %	Rule1 - Quota Amount	Rule1 - Compensation %	Rule2 - Quota %	Rule2 - Compensation %

SellerID	Sales Goal Increase %	Rule1 - Quota Amount	Rule1 - Compensation %	Rule2 - Quota %	Rule2 - Compensation %
Angelina Phillipi	0.2	200000	0.01	0.15	0.02

Configuration Engineer Knowledge Base

Query from Seller Extensions

Code

api to get sellerId

qapi.tables().sellerExtensionRows()

Result

See Also

Related content