<flow name="getFlights">
<db:select doc:name="Query Flights" doc:id="pvuqsc" config-ref="Database_Config" >
<db:sql>
<![CDATA[Select * FROM american]]>
</db:sql>
</db:select>
<ee:transform doc:name="Transform Message" doc:id="uniqueId" >
<ee:message >
<ee:set-payload >
<![CDATA[
%dw 2.0
output application/json
---
payload map ( payload01 , indexOfPayload01 ) -> {
ID: payload01.ID,
code: (payload01.code1 default "") ++ (payload01.code2 default ""),
price: payload01.price default 0,
departureDate: payload01.takeOffDate as String default "",
origin: payload01.fromAirport default "",
destination: payload01.toAirport default "",
emptySeats: payload01.seatsAvailable default 0,
plane: {
"type": payload01.planeType default "",
totalSeats: payload01.totalSeats default 0
}
}
]]>
</ee:set-payload>
</ee:message>
</ee:transform>
</flow>