Lookups in xslt mapper

prashanth suranani 6 Reputation points
2021-06-09T06:45:56.317+00:00

Hi All,

We are developing integrations in logic apps. We have the requirement to convert from XML to Flatfile. We need to do lookups in the azure blob table based on the fields in XML request at runtime.

Currently, we are using VS 2015 update2 biztalk mapper to convert from XML to Flatfile.

Could you suggest what are the ways we can achieve to get the values from the blob table?

Any way we can call the HTTP GET method in Functiods to retrieve the values from the blob table?

Any sample codes or possible patterns are much appreciated.

Thanks
Prashanth

Microsoft BizTalk Server
Microsoft BizTalk Server
A family of Microsoft server products that support large-scale implementation management of enterprise application integration processes.
349 questions
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,321 questions
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,873 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. MayankBargali-MSFT 68,746 Reputation points
    2021-06-09T09:58:27.943+00:00

    Hi @prashanth suranani

    As you are using logic app you can leverage Azure table storage connector to retrieves the value from storage table. In case if it is blob the you can leverage Azure blob storage connector.
    Alternativity as you have mentioned you can call the Azure function from logic app and Azure function will have the logic to retrieve the data from storage table. You can use storage table/storage SDK in the azure function to communicate with the storage services.
    You can find the sample for table services here.

    0 comments