Creating JSON schema using JSON schema wizard in BizTalk

 Introduction

Let us try to create a JSON schema in BizTalk using the sample JSON invoice given below.

{

    "invoiceNumber": "INV2023-001",
    "date": "2023-10-01",
    "dueDate": "2023-10-15",
    "customer": {
        "name": "ABC Company",
        "address": "123 Main Street",
        "city": "Anytown",
        "postalCode": "12345",
        "country": "USA"
    },
    "items": [
        {
            "description": "Product A",
            "quantity": 5,
            "unitPrice": 10.99,
            "total": 54.95
        },
        {
            "description": "Product B",
            "quantity": 3,
            "unitPrice": 15.99,
            "total": 47.97
        }
    ],
    "subTotal": 102.92,
    "taxRate": 0.08,
    "taxAmount": 8.23,
    "totalAmount": 111.15,
    "notes": "Thank you for your business!"
}

Steps

  • Right on the project -->Add -->New Item -->BizTalk Project Items
  • Click on JSON schema Wizard


  • Give the schema a proper name as shown below


  • Click next

  • Provide the path to the sample invoice file and provide the name of the root node and the target namespace. Click on Finish.



  • You can see that the JSON schema is created




Comments

Post a Comment

Popular posts from this blog

Error: Number of included segments do not match

Introduction In this blog, we tackle a crucial issue encountered during the reprocessing of an X12 EDI message. We will get into the root cause of the problem and provide you with a solution to overcome it. Error: An output message of the component "Unknown " in receive pipeline "Microsoft.BizTalk.Edi.DefaultPipelines.EdiReceive, Microsoft.BizTalk.Edi.EdiPipelines, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" is suspended due to the following error:       Error encountered during parsing. The X12 transaction set with id '103465910' contained in functional group with id '02', in interchange with id '000000009', with sender id '4532345856     ', receiver id '8038025150     ' is being suspended with following errors: Error: 1 (Miscellaneous error) 4: Number of included segments do not match . The sequence number of the suspended message is 1.  Root Cause: The issue stems from a mismatch in the number of se...
Read more

REST API Calls with Query Parameters in BizTalk: A Step-by-Step Guide

Image
 Introduction In this blog, I will provide a comprehensive guide on how to call a REST API that requires query parameters. We'll walk through the necessary steps to set up the environment and make successful API calls. Solution High Level Steps 1. API Overview: We will be using an open API for demonstration purposes. The API endpoint we'll be working with is: https://randomuser.me/api/?results=1 2. Schema Creation: Create a schema named "SourceA" that matches the structure of the messages you'll be dropping in the receive location. To create a JSON response schema, follow these steps: capture the JSON response by running a test in Postman, and then utilize a JSON schema generator to create the desired JSON schema. 3. Field Promotion: In the SourceA schema, promote the field called "results." This field will serve as the variable for the query parameter. 4. Receive JSON Pipeline: Develop a receive JSON pipeline that can receive JSON messages and convert t...
Read more

EDI X12 Trading partner configuration in BizTalk

Image
 Introduction In this blog post, we will explore the process of setting up trading partner configuration in BizTalk. This involves creating parties, configuring agreements, and testing the solution. Let's dive into the details. Steps Creating parties in BizTalk To begin, we need to create two parties - one for our company and another for our trading partner. Let's start by creating the party for our company named "Vipin." Follow these steps: Connect to the BizTalk Admin console. Right-click on "Party" and select "New" -> "Party." Name the party as "Vipin" and click on OK Creating the party will also create the profile for you. Next, let's create the party for our trading partner, "ABCCompany" by following the same steps. Understanding the X12 File Now, in order to configure the agreement, we need to have a sample X12 EDI message that "ABCCompany" will be sending to our company, "Vipin." Let...
Read more