Informix (Preview)

Informix (Preview)

Microsoft Connector for Informix integrates Azure applications with resources stored in an IBM Informix database. Connector supports SELECT, INSERT, UPDATE, and DELETE operations.

This connector is available in the following products and regions:

Service Class Regions
Logic Apps Standard All Logic Apps regions except the following:
     -   Azure Government regions
     -   Azure China regions
Flow Premium All Flow regions except the following:
     -   US Government (GCC)
PowerApps Premium All PowerApps regions except the following:
     -   US Government (GCC)

Throttling Limits

Name Calls Renewal Period
API calls per connection 100 60 seconds

Creating a connection

To connect your account, you will need the following information:

Server
string
Server
Database
string
Database
Authentication
string
Authentication type
Username
securestring
Username
Password
securestring
Password
Gateway
gatewaySetting

Actions

Delete row

Deletes a row from a Informix table

Required Parameters

Table name
string
Name of Informix table
Row id
string
Unique identifier of the row to delete

Get row

Retrieves a single row from a Informix table

Required Parameters

Table name
string
Name of Informix table
Row id
string
Unique identifier of the row to retrieve

Returns

The outputs of this operation are dynamic.

Get rows

Retrieves rows from a Informix table

Required Parameters

Table name
string
Name of Informix table

Optional Parameters

Filter Query
string
An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).
Order By
string
An ODATA orderBy query for specifying the order of entries
Skip Count
integer
Number of entries to skip (default = 0)
Maximum Get Count
integer
Maximum number of entries to retrieve (default = 256)
Select Query
string
Specific fields to retrieve from entries (default = all).

Returns

The outputs of this operation are dynamic.

Get tables

Retrieves tables from a Informix database

Required Parameters

Table name
string
Name of Informix table
Row id
string
Unique identifier of the row to delete

Returns

Body
TablesList

Insert row

Inserts a new row into a Informix table

Required Parameters

Table name
string
Name of Informix table
Row
dynamic
Row to insert into the specified table in Informix

Returns

The outputs of this operation are dynamic.

Update row

Updates an existing row in a Informix table

Required Parameters

Table name
string
Name of Informix table
Row id
string
Unique identifier of the row to update
Row
dynamic
Row with updated values

Returns

The outputs of this operation are dynamic.

Definitions

Table

DisplayName
string
Name
string

TablesList

value
array of Table