HTTP Trigger

Previous  Next |  Direct link to this topic

[See a video of the feature]

With an HTTP trigger you have the option to HTTP post request to different URLs. the main purpose of this function is to send messages to channels in either Microsoft Teams or slack.

clip0177

Field

Description

URL

The URL you want to post to.

Video sample: How to get an incoming Web-hook URL in Microsoft Teams

Video sample: How to get an incoming Web-hook URL to Slack

Template

A selection of predefined templates with different target in mind.

There's  different templates designed for specific target like MS Teams  and Slack, plus an advanced raw format there consists of Raw JSON

based on the selected template different fields will be available, to ensure a fast and essay setup

 

Template specific fields

Each template is different and contains different fields.

 

These fields support the usage of the following syntax's:

Dynamic Syntax

SQLHtmlTable(<sql>) this will if given a SQL create a HTML table with a header containing the name of the columns and create rows containing the values. (MS TEAMS ONLY)

oExample: SQLHtmlTable(SELECT CardCode, CardName FROM OCRD)

SQL(<sql>) this will if given a SQL insert the first value returned by the SQL into the email body.

oExample: SQL(SELECT Balance FROM OCRD WHERE CardCode = '$[$4.0.0]')

SQLBULLETLIST(<sql>) this will if given a SQL create a Bullet list (one item per row the SQL return)

oExample: SQLBULLETLIST(SELECT TOP 5 CardCode FROM OCRD)

SQLNUMBEREDLIST(<sql>) this will if given a SQL create a Numbered list (1,2,3... one item per row the SQL return)

oExample: SQLNUMBEREDLIST(SELECT TOP 5 CardCode FROM OCRD)