How to add Queries to an API

• Click on “Design”.
• Click on the “Query” using the “Create” button under the “Names,” then select the “Named Range” you need to write a query.
• There, you can select the desired “Entities”. After adding them, you can see the added columns and conditions in the right frame.
• Below, you can select the “Trigger on Calculate”, or “Trigger on Load”, and bind it to a named range.
• After completed, publish the application.