TRANSFORMER

JSON source

Use a JSON source to connect to a File, Remote resource, or External file resource.

 To configure a JSON source, you must have working knowledge of .json file formats and the JSON syntax.

Properties

General

• Name - the name "JSON source" is generated automatically but you can change it at any point.

• Description - an optional text that describes the JSON source.

Configuration

• Resource - the resource from which Corporater BMP imports the data.
  Click the Edit button () and select the resource from Resources.
  To import data from a remote system or a public web service, select a Remote resource.
   Corporater BMP uses the remote resource's authentication type as the security protocol to connect to the web service.
  For Corporater BMP to use the Auth0 security protocol, configure two remote resources as stated in Remote resource. Then, select the dependent remote resource.

• URL parameters - available only if the resource you selected for Resource is an external file resource. The additional URL parameters to use for the data import.
  Click the Lookup button () and configure a tag with one or more context variables.
  For example, cases.json?limit=100&status=NEW,OPEN&start_time=${this.bop.iso}.

• Name of data array - the full path of the array from which to import data.
   The array can be located at any level in the data structure.
  Specify the path based on the array's position in the data source.
  The path must be a concatenation of data objects separated by a period, with the last item being the name of the array.

• Next URL - available only if the resource you selected for Resource is an external file resource. The URL from which to get more data.

• Fields - the full path of the name-value pairs from which to import data.

   You can specify one or multiple name-value pairs from the array.

  Corporater BMP requires you enter the full path for each pair.

  The path must be a concatenation of objects from the data hierarchy separated by a period, with the last item being the name of
  the name-value pair.

  For best practice, Corporater recommends you configure both Fields and Name of data array for a JSON source.

  If you specify the full path of the array from which to import selected data in Name of data array, and each name-value pair
  to import belongs to that array, you can enter only the name for each name-value pair in Fields instead of the corresponding
  full path.

  If the object that includes the array with the name-value pairs contains additional name-value pairs that are common for each array, Corporater BMP imports also the data that's associated with these common name-value pairs.

Version 5.1.2.0

This document contains confidential information. Not to be copied by third parties without written authorization.

© Copyright Corporater AS - All rights reserved.