ExcelOnline连接器，如何动态绑定到文件？ [英] ExcelOnline connector, how do I dynamically bind to file?

问题描述

您好，

我正在使用Excel Online连接器和"文件"参数仅允许在Sharepoint中获取现有文件。我需要动态创建文件并将其绑定到新创建的文件。我试图从创建步骤使用FileName属性，但它似乎不是
工作。下面是动态提供的文件名与静态引用的比较。看起来不是实际文件的路径，而是在连接器中使用某种散列。

I'm using Excel Online connector and "File" parameter only allows to pick up existing files in Sharepoint. I need to create file on a fly and bind it to newly created file. I tried to use FileName property from create steps but it does not seem to work. Below is comparison of what dynamically provided file name looks in comparision with static reference. Looks like instead of path to the actual file some sort of hash is used in connector.

生成的文件参考

{
    "host": {
        "connection": {
            "name": "/subscriptions/24ba3c-45e3-4d55-8132-6731cf25547f/resourceGroups/greg/providers/Microsoft.Web/connections/excelonlinebusiness"
        }
    },
    "method": "get",
    "path": "/drives/b%21v1sKMGa4pUqMukYSogTYYg6zJVZo5DhiQP_H0CDjjy64E7uqyOR5-AN0rHVYw-/files/%2Fgeneral%2Ftemplate1.xlsx/tables/VMs/items",
    "queries": {
        "source": "groups/0f5dfa-d861-4efc-a7fc-2f002a531767"
    }
}

硬编码路径参考 

Hardcode path reference 

{
    "host": {
        "connection": {
            "name": "/subscriptions/24ba4c-45e3-4d55-8132-6731cf25547f/resourceGroups/greg/providers/Microsoft.Web/connections/excelonlinebusiness"
        }
    },
    "method": "get",
    "path": "/drives/b%21v1sKMGa4pukYSogT99YYg6zJVZo5DhiQP_H0CDjjy64E7uqyOR5-AN0rHVYw-/files/01KDEY6ASBUIZCLRKKOZ4B4CABVE7VQP/tables/1/items",
    "queries": {
        "source": "groups/0f5d04fa-61-4efc-a7fc-2f002a531767"
    }
}

推荐答案

嗨  artisticcheese

我有点不清楚你的意思是动态创建一个文件并将其绑定到新创建的文件。你能分享现有洛杉矶工作流程的截图吗？如果您打算创建一个工作流程：


a）在指定的Sharepoint站点中创建一个Excel文件（
b）运行一个操作（用内容填充它）在上一步中新创建的Excel文件中删除或删除行等，我相信你可以通过一些ETL步骤以及Excel和Sharepoint连接器轻松实现这一点。你能否详细说明
情景多一点？

I'm a little unclear on what you mean by creating a file on the fly and binding it to newly created file. Could you share a screenshot of your existing LA workflow? If you've meant to create a workflow that:
a) creates an Excel file in your specified Sharepoint site
b) runs an operation (populate it with content or remove rows etc) on the newly created Excel file from previous step, i'm sure you can achieve this pretty easily with a few ETL steps as well as both Excel and Sharepoint connectors. Could you elaborate on your scenario bit more pls?

这篇关于ExcelOnline连接器，如何动态绑定到文件？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！