none
How to deal with Typed Data? RRS feed

  • Question

  • I have been playing with Logic Apps and have run into a couple situations that I am not sure how to address. Not sure if it is a limitation or if I am just missing out on something.

    The core question is how can I use 'typed' data when communicating with different SaaS connectors?

    For example, in Josh's Azure Friday video we saw a SQL polling scenario where we can simply refer to the inbound connector's data elements when populating SalesForce.  That is fine and works well.

    But, what happens if I have a different 'style' of end point?  For example let's consider receiving an XML file from a file folder.  How can I refer to data elements within that file when calling SalesForce?

    Another scenario I am curious about is if I expose an inbound HTTP endpoint and I am going to be receiving query parameters.  how can I use these query parameters when populating the SalesForce card?

    Ideally I would like to be able to drag a "Mapper" in between these two endpoints and then leverage the meta data within a Map. We already have the SalesForce meta data as we can populate text boxes in the Salesforce card.  But what if I can provide a Swagger definition, XML schema or flat file definition as a source.  I have also logged this request in user voice here: http://feedback.azure.com/forums/287593-logic-apps/suggestions/7367668-tighter-mapping-transformation-with-connectors

    Thanks,

    Kent


    http://kentweare.blogspot.com

    Monday, March 30, 2015 5:48 PM

Answers

  • Thanks for the feedback Kent - we're definitely looking at better mapping experiences. Appreciate you creating a UV item for your request :)

    Also, remember where we don't have the metadata you can still navigate a JSON structure from a response by editing the expression directly (you don't have to use the dropdown).

    We'll also add a JSON encoder in the near future to help take XML and make it accessible to the logic apps runtime.

    Thanks!

    Josh


    http://twitter.com/joshtwist

    Monday, April 6, 2015 7:25 PM