خرید بک لینک

Vote count: 0

I'm trying to build a logic app that inserts data into a Sql database. The data is coming from s Stream Analytics job, outputting it on a Service Bus topic, consumed in Logic Apps in Service Bus trigger.

To populate the properties of the row inserted (lets say it only has one column 'Name'), I've found that this should work using following syntax:

 "body": {
          "Name": "@{json(decodeBase64(triggerBody()['ContentData'])).Name}"
  },

Provided the message body contains a 'Name' property.

However I get following error message when ruing this:

{"code":"InvalidTemplate","message":"Unable to process template language expressions in action 'Insert_row' inputs at line '1' and column '2017': 'The template language function 'json' parameter is not valid. The provided value '@u0006stringb3http://schemas.microsoft.com/2003/10/Serialization/��{"time":"2016-05-25T10:29:17.4953250Z","Name":"Y-Axis","Value":81.0,"Date":"2016-05-25T10:29:17.4953250","EventProcessedUtcTime":"2016-05-25T10:29:17.5525449Z","PartitionId":2,"EventEnqueuedUtcTime":"2016-05-25T10:29:17.2220000Z"}u0001' caot be parsed: 'Unexpected character encountered while parsing value: @. Path '', line 0, position 0.'. Please see https://aka.ms/logicexpressions#json for usage details.'."}

So it seems like that the content is enclosed in another envelope that is preventing json parsing to work.

1) Any simple way how to get around this?

2) Isn't such an integration all within Microsoft Stack just supposed to work without this mocking around?

Thanks, Stefan

asked 5 mins ago

برچسب: نویسنده: استخدام کار تاريخ: چهارشنبه 5 خرداد 1395 ساعت: 18:11

صفحه بندی