question

prashanthsuranani-4204 avatar image
0 Votes"
prashanthsuranani-4204 asked ·

Lookups in xslt mapper

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

azure-functionsazure-logic-appsbiztalk-server-all
10 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

MayankBargali-MSFT avatar image
0 Votes"
MayankBargali-MSFT answered ·

Hi @prashanthsuranani-4204

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.

10 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.