What is and how to write an instruction for a technical connector?

What is an instruction?

An instruction is a command or query used to interact with systems or services within an integration flow. It allows data manipulation or triggering operations, such as querying information, sending data, or executing specific actions, being essential for the exchange and management of information between integrated systems.

When configuring the form of a technical connector, you need to fill in the INSTRUCTION field according to the type of connector you selected. In this field, you will create a script using the native syntax of the protocol the connector accesses.

Most of the technical connectors available in Sensedia Integrations require instructions with SQL syntax.

How to write an instruction?

You can write the instruction in two ways, using the Properties that allow the use of environment variables and properties from previous steps in the flow:

  • Insert input attributes: Select the desired items from Properties on the left panel.

  • Create an expression: Combine items from Properties using the Concat function. To use it, click the fx button available to create expressions.

Check more details on how to build SQL instructions and how to use the Concat function to create expressions.

See the videos below that demonstrate how to create a simple instruction for a MySQL connector:

  • With the Concat function:

  • Without the Concat function:

Thanks for your feedback!
EDIT

Share your suggestions with us!
Click here and then [+ Submit idea]