Loads data from REST APIs that can be targeted with GET requests (Access to the network where the REST API resides is necessary, for distributed computation also the cluster nodes need that). A path through the retrieved JSON can be provided to further specify the content of the created rows.
WARNING: Note that THE URL THAT SHOULD BE USED AS A QUERY is the only mandatory field. All the other fields can be configured as per requirement.
The Multi URL API Load Processor operates on any input data containing a valid JSON URL.
The processor has two output nodes.
- The first output node returns the result JSON Object.
- The second output node returns the failing URLs along with the corresponding error messages.
In this example we're using an input table containing two valid JSON URLS, a non valid URL (here Google.de) and an empty row.
Error result table
Note that the result JSON is just one column since we didn't specify any JSONPath in our configuration. In the next example we will add $.response as JSONPath.
JsonPath uses special notation to represent nodes and their connections to adjacent nodes in a JsonPath path. There are two styles of notation, namely dot and bracket.