From BizTalk 2013 R2 & upper version, BizTalk also provides in-build REST service capability. Before this, there was required custom coding for Json file and rest services. Now it’s easy to create schema from Json file.

Select JSON Schema Wizard, following window will open

Select Json file in instance file and change the root node name and click finished. It will create schema.

This JSON schema Wizard does not provide schema creation for array-list json files. for arraylist json file you need to create custom pipeline.

Click here for cusom pipeline for below rquirement

  1. Handle Non-List/Array json messages
  2. Handle List/Array json messages
  3. Remove special characters before json Decoder pipeline stage

https://vkbiztalk.com/2018/08/31/handle-array-list-json-messages-in-biztalk-receive-pipeline/

One thought on “Create Schema from JSON files:

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s