从Oracle Visual Builder的Visual App中的对象存储中下载文件。如何使用来自ATP数据库的数据以获取文件的名称
我正在尝试从Oracle Visual Builder应用程序中的Oracle Cloud中的对象存储中下载特定文件（我的Visual Builder在OIC内部，Oracle Integration Cloud）。
我想使用“文件URL”列的名称（请参见上图）作为要从对象存储下载的文件名称，但是此文件名应该不同从每个下载按钮中（在上面的图中，您都可以看到每个下载按钮都应下载具有“文件URL”列值名称的文件）。文件URL列是链接到SDP变量的业务对象的字段，数据来自Oracle Cloud Infrastructure内部的ATP数据库。列“第一个文件”包含下载按钮。在此按钮的属性中，有一个与动作链链接的ojaction事件（请参见下图）。
我关注此指南（从OCI存储部分下载）以下载一个文件，但我映射了带有固定值的“文件名”输入参数（对象存储中现有文件的名称）。现在，我想使文件名值动态，但是我不知道如何创建一个变量，该变量可以收集DB中特定列的所有值（文件URL）以及如何传递此列的单个值到文件名参数。我试图创建一个仅获取文件URL值的SDP类型变量，但没有获得文件名的值。您是否有建议，或者您看到的指南可能对解决此问题有用？
I am trying to download specific files from the Object Storage in the Oracle Cloud in my Oracle Visual Builder App (my visual builder is inside OIC, Oracle Integration Cloud).
I'd like to use the name of the "File URL" column (see the picture above) as the file name of the file to download from the Object storage, but this file name should be different from every download button (again in the picture above, you can see that every download button should download the file that has the name of the value of the "File URL" column). The File URL column is the field of a business object which is linked to the SDP variable and the data arrives from an ATP database that is inside the Oracle Cloud Infrastructure. The column "First File" contains the Download buttons. In the properties of this button there is an ojAction event which is linked to an action chain (see picture below).
I followed this guide (Download from OCI Storage section) to download one file, but I mapped the "filename" input parameter with a fixed value (the name of an existing files inside the object storage). Now, I'd like to make the filename value dynamic, but I don't know how to create a variable that gathers all the values of the specific column (File URL) in the DB and how to pass the single value of this column to the filename parameter. I have tried to create an SDP type variable that gets only the File URL values, but it's not getting the values of the file names. Do you have suggestions or have you seen a guide that is maybe useful to solve this issue?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
如果我正确理解了问题，您将无法检索链接到行按钮的特定文件URL，以便下载正确的文件。
如果是这种情况，那么您可以使用链接到表本身的“首先选择”事件，而不是使用按钮。这将把所选行的所有值作为参数传递，并允许您链接“ $ variables.rowdata.fileurl”或任何字段所谓的剩余呼叫。
If I understood the problem correctly, you can't retrive the specific file URL linked to the row button the user click in order to download the right file.
If that's the case, then instead of using a button, you could use the "first-selected-row" event linked to the table itself; that will pass all the values of the selected row as parameter, and will allow you to link "$variables.rowData.fileURL" or whatever the field is called to the REST call.
您可以访问所选行中的字段值，如下所示：
https> https：// blogs.oracle.com/vbcs/post/accessing-selected-Rows-values-in-a-tables-in-visual-builder
或如行级别的行动部分所示：
https> https：// blogs.oracle.com/vbcs/post/advanced-capabilities-foror-the-table-components-in-builder-builder-tips
You can access the values of the field in the selected row as shown here:
https://blogs.oracle.com/vbcs/post/accessing-selected-rows-values-in-a-tables-in-visual-builder
Or as shown here in the row level action section:
https://blogs.oracle.com/vbcs/post/advanced-capabilities-for-the-table-components-in-visual-builder-tips