Subquery - AppDaddy-Software-Solutions-Inc/framework-markup-language GitHub Wiki
The SUBQUERY is a child of Datasources that takes a Datasource as a child, and preforms that data query on each row inserting the record into the target.
SUBQUERY, like all data transforms, is very hardware intensive and therefore must be used sparingly. If the ability to preform an operation on the backend is available, that should be the first option. SUBQUERY, will add the speed for each call to the time to return for the parent datasource, and therefore will make it slower by a multiple of each row vs time to complete of the child queries.
| Name | Type | Default | Description | Req |
|---|---|---|---|---|
| target | string | "" | the target name to assign the returned value to | ✔ |
| enabled | bool | "true" | boolean expression to (en/dis)able the datasource | ✔ |
SUBQUERY on a GET datasource, with a GET child
<GET id="trackerdata" autoexecute="false" url="resources/planedata.json">
<SUBQUERY target="jeff">
<GET id="departureLocationData" autoexecute="false" url="https://aircharterguide-api.tuvoli.com/api/v1/airport/details?airportCode={estDepartureAirport}">
<HEADER key="Content-Type" value="application/json; charset=utf-8"/>
</GET>
</SUBQUERY>
</GET>
<TEXT value="data 1: {trackerdata.data:0.jeff.AirportName}" color="black"/>