Integration Basics

Scenario When attempting to convert XML to JSON format using the map in the BizTalk send port, I encountered an issue. The output I received was not in the expected format. Please note that the XML format would be then converted to the corresponding JSON format by means of a JSON encoder. Expected format     < Order >         < CustomerPO > 1234 </ CustomerPO >         < DeliveryDate > 0610202312:00 </ DeliveryDate >         < OrderSource > Sales Order </ OrderSource >         < LineItems >             < LineItem >                 < ItemNumber > 1111 </ ItemNumber >                 < OrderQuantity > 2 </ OrderQuantity >                 < UnitOfMeasure > CASE </ Unit...

 Error: I encountered the following error while testing a BizTalk map in Visual Studio: Error Exception Caught: Cannot load source/destination schema: POCSinglePointAPI.Schemas.SinglePointRequest.  Either the file/type does not exist, or if a project dependency exists, the dependent project is not built. C:\Users\c-vJayanarayanan\source\repos\POCSinglePointAPI\POCSinglePointAPI.Maps\CanonicalSalesOrder_TO_SinglePointRequest.btm 1 Solution: Right click on the map project and build the solution After successfully building the solution, the test map should function properly.

 Scenario In some cases, you might want to map multiple source variables to one target schema. This is because the data might be spread across 2 schemas. To do this follow the below steps. 1. Create a map via an orchestration. This will help you choose 2 message variables as a source and one Destination schema. Refer Fig 1 and Fig 2.                                               Fig 1                                    Fig 2 2. This will create the map as shown in Fig 3. Here you can see that a map has been created with multiple source schemas and one target schema. Now you can perform your mapping based on the data you have in these 2 schemas. Fig 3 Hope this helps. Happy coding.