Skip to main content Skip to complementary content

Getting started with DSQL maps

Availability-noteBeta
Create a simple DSQL map and test it with sample data.

Before you begin

  • You have created an input and an output structure. You can use the JSON samples below to create your structures.
  • You have set the Map Lines preference in Window > Preferences > Mapping to All Elements.

About this task

In this example, you will create a simple DSQL map to extract and filter data about bicycles for sale in a shop. The input data looks like this:
{
   "store":"Bikes and Scoots",
   "address":{
      "street":"47 High St",
      "city":"Linlithgow",
      "zip":"75858",
      "phone":"713 844445"
   },
   "categories":[
      {
         "category":"bicycles",
         "items":[
            {
               "make":"MBIKE",
               "description":"27.5 inch electric mountain bike",
               "color":"blue",
               "price":899.99
            },
            {
               "make":"EBIKE",
               "description":"Electric hybrid bike",
               "color":"grey/green",
               "price":999.99
            },
            {
               "make":"WBIKE",
               "description":"Women's road bike",
               "color":"white",
               "price":299.99
            }
         ]
      },
      {
         "category":"scooters",
         "items":[
            {
               "make":"ESCOOT",
               "description":"Camou electric scooter",
               "color":"black",
               "price":749
            },
            {
               "make":"EVSCOOT",
               "description":"Folding electric velocity+ scooter",
               "color":"black",
               "price":599.99
            },
            {
               "make":"KSCOOT",
               "description":"24 volt kid scooter",
               "color":"white",
               "price":299.99
            }
         ]
      }
   ]
}
The output structure looks like this:
{
   "items":[
      {
         "make":"",
         "description":"",
         "price":""
      }
   ]
}

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!