BizTalk Flat File Encoder: Convert a given flat file instance to JSON
A very common integration scenario is that a flatfile (csv) gets uploaded to a ftp server. The file contains e.g. informations about an order which must send to a LOB-system like Salesforce. It would be nice to use a Logic App therefor, together with a FTP Connector, BizTalk Flat File Encoder and Salesforce Connector. But it is not that simple today. As far as I can see so far, we would need need a BizTalk XPath Extractor in addition. So I wish like to see a BizTalk Flat File Encoder which supports json other than just xml. I think with this it would be possible to just select the json output from the BizTalk Flat File Encoder in the Salesforce Connector. Maybe there is also a JSON Encoder (API) planned, but I would prefer my described process above (FTP Connector --> BizTalk Flat File Encoder --> Salesforce Connector) instead of converting a flatfile to xml and then to json (FTP Connector --> BizTalk Flat File Encoder --> JSON Encoder --> Salesforce Connector).
Thanks for your feedback!
I'm moving this to the Azure Logic Apps page to provide visibility to the Azure Connectors team
Alex - Azure App Service