Import Export JSON

Canvas has now revamped the query generation modules by introducing the capabilities to export metadata in JSON format, bulk export of metadata in JSON format and import the exported JSON. To promote the component configurations requires a manual intervention to execute the exported queries from one environment to the other. The ability to import metadata resolves this challenge by avoiding the need for manual executing the exported queries for promoting changes. Promoting the configuration can now be easily done by exporting the metadata from a lower environment and importing it in a higher environment. 

For example, you can move metadata from lower environments such as SIT or UAT to Production.

Benefits
With these features Canvas enables you to:

• Export configurations of a component in JSON format.
• Export configurations of many components in bulk.
• Import configurations of a component in JSON format.

Bulk Export

Bulk Export utility feature enables the user to generate the queries related to a Workspace/App/Form.

For Bulk Export, select the Workspace/Apps/Forms, click the export icon on the Workspace Canvas List/App List/Form Definition List as shown in the following screen shot.

Newly generated queries will be saved in the Canvas workbench folder. For example,

Path: D:\Canvas\CodeGen\generated\wdktemplate\1.0\BulkExport

The difference between Bulk Export and generating query by right clicking a Workspace/App/Form are follows:

1. The Bulk Export utility feature generate all the queries (queries of Workspace, Workspace Menu, App, View, Form) related to a Workspace, whereas generating query by right clicking generates only the Workspace query.
2. Bulk Export utility feature enables the user to generate queries of multiple Apps/Forms by using the checkbox selection.

During import of the Bulk Exported query to create another Workspace/App/Form, it will fetch only the configuration details. The database tables and SQL maps have to be configured again.