How to use Biztalk Rule in Logic App

Question

I am trying to automate a process to read from a table from SQL server and pass the data to Biztalk Rules Engine and react based on the result. However I can’t pass the data over from SQL Server to Biztalk. I hope you can share with me some sample apps that doing the similar things.

Answer 1

Greetings,

Please refer Working With BizTalk Adapter for SQL Server

Also below are the good reads,

Best Practices for the SQL Adapter , Building a Scalable Business Process Automation Engine Using BizTalk Server 2002 and Visual Studio .NET

Hope this helps.

Regards,
Somashekar

Answer 2

What is the issue that you are running into. The Rules documentation is at - https://azure.microsoft.com/en-us/documentation/articles/app-service-logic-use-biztalk-rules/

Let us know if there are specific issues that you are running into.

Answer 3

This is my xml input

<Badge xmlns=\"http://tempuri.org/XMLSchema.xsd\">
    <Header><ReqID>1</ReqID><Date>2015-07-03</Date></Header>
    <Item><AchievementCode>A1</AchievementCode><YearsOfService>2</YearsOfService></Item>
    <Point></Point>
</Badge>

The Biztalk rule should return the point value.

How can I get the result from 

postResponse = httpClient.PostAsync("api/Policies/RewardPolicy?comp=Execute", httpContent).Result;

I would like to get the point value.

Answer 4

Hi Somashekar,

Thanks for your reply. I am referring to Biztalk rule service in Azure (Logic Apps) instead of the Biztalk Server. Do you have experience creating Logic App which uses Biztalk Rule Api Apps?

Answer 5

Hi ,

I would suggest to create  policy depending on your SQL data . below MSDN article will guide you with the steps 

https://azure.microsoft.com/en-in/documentation/articles/app-service-logic-use-biztalk-rules/

Thanks

Abhishek

Answer 6

Yes, I did follow the article. As mentioned in my earlier post, I can call the API, but I cannot get the return result from httpClient.PostAsync.