How to construct JSON list in an automation

[PradeepUrala]

Constructing a JSON list that is compatible with the destination application requires few steps in automation.

1. Add a variable block and define a list:
   
   
   1. Go to Manage Variables
   2. Enter List name
   3. Change variable type to "List"
   4. Save.
      
      
      
      
2. Empty this list by selecting the 'Empty' operation in the block.
   
   
   
   
3. Loop through the Source list to iterate through each object of the list.
   
   
   
   
4. At this point, we'll have to construct each object for our destination list with the appropriate Key-Value pair.
   You will need another variable block inside the loop with the type "Object".
5. Select the "Set key/value" operation for this variable block and enter the destination Object's Keys. Map the values for this object by selecting the values from the source list.
   
   
   
   
6. Add another variable block and select the previous list variable. Now, add the operation "Add Item to" and select the object variable previously constructed.
   
   
   
   
7. We can use the output of this final list variable as a destination list.

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.