How do a merge two arrays in Infinity datasource with UQL

[yosiasz]

Here is one of many examples. Also search for https://try.jsonata.org/
in this forum.

Join by field not working with JSON from URL API - Infinity Datasource

sorry got tied up with other stuff. what data point do you need from detections list that you have to join it to the details? try one of the jsonatas below. parse-json | scope "resources" #|jsonata "$.{'detection_id': detection_id, 'hostname': device.hostname, 'external_ip': device.external_ip, 'local_ip': device.local_ip}" |jsonata " ( $data := $map($, function($v) { { 'detection_id': $v.detection_id, 'hostname': $v.device.hostname, 'external_ip': $v.device.external_ip, 'local_ip': $v.device.…