Excel.LinkedEntityLoadServiceRequest interface

表示对自定义函数以 @linkedEntityLoadService 加载 LinkedEntityCellValue 对象的请求。

注解

API 集:ExcelApi 1.19

Excel Web 版不支持此界面。

示例

// Link to full sample: https://raw.githubusercontent.com/OfficeDev/office-js-snippets/prod/samples/excel/20-data-types/data-types-linked-entity-load-service.yaml

/**
 * Loads the Contoso entities used by the Data types: Linked entities sample.
 * @customfunction
 * @linkedEntityLoadService
 * @param {unknown} request JSON containing the domain and entity identities requested by Excel.
 * @returns {any} Linked entities in the same order as the request.
 */
function contosoLoadService(request: unknown) {
    // Resolve a batch of identities while preserving each requested culture and the request order.
    try {
        if (typeof request !== "string") {
            throw new Error("The linked entity load service request must be JSON text.");
        }
        const parsedRequest: Excel.LinkedEntityLoadServiceRequest = JSON.parse(request);
        if (!parsedRequest || typeof parsedRequest.domainId !== "string" || !Array.isArray(parsedRequest.entities)) {
            throw new Error("The linked entity request must contain a domain ID and an entities array.");
        }
        const response: Excel.LinkedEntityLoadServiceResult = { entities: [] };
        for (const identity of parsedRequest.entities) {
            const entityIdentity: Excel.LinkedEntityIdCulture = identity;
            if (!entityIdentity || typeof entityIdentity.entityId !== "string" ||
                typeof entityIdentity.culture !== "string") {
                throw new Error("Each linked entity identity must contain an entity ID and culture.");
            }
            response.entities.push(makeLinkedEntity(parsedRequest.domainId, entityIdentity.entityId, entityIdentity.culture));
        }
        console.log(`Loaded ${response.entities.length} linked entities from ${parsedRequest.domainId}.`);
        return response;
    } catch (error) {
        console.error("Unable to load linked entities:", error);
        throw new CustomFunctions.Error(CustomFunctions.ErrorCode.notAvailable, "Unable to load the requested Contoso entity.");
    }
}

属性

domainId

表示特定于用于创建对象的 LinkedEntityCellValue 服务的域。

entities

表示要加载的 LinkedEntityCellValue 对象的实体 ID 和区域性。

属性详细信息

domainId

表示特定于用于创建对象的 LinkedEntityCellValue 服务的域。

domainId: string;

属性值

string

注解

API 集:ExcelApi 1.19

Excel web 版不支持此属性。

entities

表示要加载的 LinkedEntityCellValue 对象的实体 ID 和区域性。

entities: LinkedEntityIdCulture[];

属性值

注解

API 集:ExcelApi 1.19

Excel web 版不支持此属性。